Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL stored procedure returning multiple result sets (SELECTs)?
Date: 2008-10-13 10:35:20
Message-ID: 20081013103520.GF17873@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

am Mon, dem 13.10.2008, um 11:34:03 +0200 mailte A. Kretschmer folgendes:
> or, simpler in plain sql:
>
> test=# create or replace function srf (OUT a int, OUT b int) returns setof record as $$select 1,2;select 1,3;$$language sql;
> CREATE FUNCTION
> test=*#
> test=*#
> test=*# select * from srf();
> a | b
> ---+---
> 1 | 3
> (1 row)

Sorry, i have overlooked that this isn't the expected result and thanks
to Pavel for the rectification.

Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ang Chin Han 2008-10-13 10:36:03 Re: [PERFORM] Drupal and PostgreSQL - performance issues?
Previous Message Gregory Stark 2008-10-13 10:33:50 Re: Chart of Accounts