From: | marc(at)oscar(dot)eng(dot)cv(dot)net (Marc Spitzer) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Migrate Store Procedure Sybase to PostgreSQL |
Date: | 2001-12-19 23:51:08 |
Message-ID: | slrna229t9.2a87.marc@oscar.eng.cv.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 ?
From | Date | Subject | |
---|---|---|---|
Next Message | Matt Sauve-Frankel | 2001-12-20 00:05:19 | Re: More on Too Many Open Files... NetBSD |
Previous Message | Joseph Shraibman | 2001-12-19 21:03:51 | sql scripts |