| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Adrian Klaver <aklaver(at)comcast(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org, Jerzy Bialas <jbialas3(at)wp(dot)pl> |
| Subject: | Re: |
| Date: | 2009-09-26 20:10:20 |
| Message-ID: | 162867790909261310y1dadd17bl4a23d705af9e5758@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello
2009/9/26 Adrian Klaver <aklaver(at)comcast(dot)net>:
> On Friday 25 September 2009 9:52:09 am Pavel Stehule wrote:
>> Hello
>>
>> this isn't possible now. All what you want are limited by SELECT
>> statement in PostgreSQL. Simply PL knows only SELECT statement and
>> structure of result have to be strongly static - because it is based
>> on static execution plan - it is determined before query start.
>>
>> Statement CALL isn't implemented yet.
>>
>> Regards
>> Pavel Stehule
>
> I may be misinterpreting the docs section below, but I beg to differ.
>
> http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN
>
the sql for EXECUTE statement should be dynamic, but the structure of
result have to be stable.
Pavel
>
>
>
> --
> Adrian Klaver
> aklaver(at)comcast(dot)net
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2009-09-26 20:12:38 | Re: Column names in rowsets returned from function |
| Previous Message | Iain Barnett | 2009-09-26 19:59:27 | Re: INSERT... RETURNING with a function |