From: | zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: return setof : alternatives to holder table |
Date: | 2010-08-15 16:22:35 |
Message-ID: | AANLkTimUZ38iCGZ5Pk7soRT+GfFudD=q-sVnH78nq-EK@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Sun, Aug 15, 2010 at 12:21 PM, zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com> wrote:
> On Sun, Aug 15, 2010 at 11:57 AM, Joe Conway <mail(at)joeconway(dot)com> wrote:
>> On 08/15/2010 07:57 AM, zhong ming wu wrote:
>>> Here is what I have tried
>>>
>>> create or replace function te(out a int,out b int) returns setof record as
>>> $pgsql$
>>> declare
>>> r record;
>>> begin
>>> r.a := 1;
>>> r.b := 2;
>>> return next;
>>> end;
>>> $pgsql$ language plpgsql;
>>
>> Try:
>>
>> create or replace function te(out a int,out b int)
>> returns setof record as $pgsql$
>> begin
>> a := 1;
>> b := 2;
>> return next;
>> end;
>> $pgsql$ language plpgsql;
>>
>> contrib_regression=# select * from te();
>> a | b
>> ---+---
>> 1 | 2
>> (1 row)
>>
>> -- or --
>>
>> create or replace function te()
>> returns TABLE(a int, b int) as $pgsql$
>> begin
>> a := 1;
>> b := 2;
>> return next;
>> end;
>> $pgsql$ language plpgsql;
>>
>> contrib_regression=# select * from te();
>> a | b
>> ---+---
>> 1 | 2
>> (1 row)
>>
>
The second example is perfect in that I just need to insert my table
definition into function definition. Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-08-15 16:36:45 | Re: InitDB: Bad system call |
Previous Message | Torsten Zühlsdorff | 2010-08-15 16:07:04 | Re: InitDB: Bad system call |