Re: Migrate Store Procedure Sybase to PostgreSQL

[marc(at)oscar(dot)eng(dot)cv(dot)net (Marc Spitzer)]

In article <23aa5c00(dot)0112190638(dot)2f919e52(at)posting(dot)google(dot)com>,
Yamil Bendek wrote:
> yibendek(at)ubiquando(dot)com(dot)co (Yamil Bendek) wrote in message news:<23aa5c00(dot)0112181417(dot)5265270a(at)posting(dot)google(dot)com>...
> 
> I need to migrate a Sybase Database to PostgreSQL, In the Sybase DB we
> have store procedure that return result Sets, how can i to migrate
> these store procedure?????????

you could try storing the result in a tmp table and returning the
name of the table.  I dont think you can return a result set from
a stored procedure.

good luck

marc

> 
> 
>> is it possible to create or to write store procedures that return a
>> Result Set of a Query? How, Please ?
>> 
>> Similar to the store procedures of sybase
>> 
>> Example sybase : 
>> 
>> create procedure sp_sv44InfCiudades @s_cod_pais smallint as
>>   SELECT ciudades.cciu_codigo_iata,   
>>          ciudades.vciu_nombre_ciudad,   
>>          paises.vpai_nombre_pais  
>>     FROM ciudades,   
>>          paises  
>>    WHERE ( paises.spai_codigo_pais = ciudades.sciu_codigo_pais ) and
>> 	   ( paises.spai_codigo_pais = @s_cod_pais )  
>>    ORDER BY ciudades.vciu_nombre_ciudad ASC  
>> 
>> 
>> 
>> 
>> 
>> return multiple rows and columns
>> 
>> that is possible in postgeSQL ?