From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, John Proctor <jproctor(at)prium(dot)net>, Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>, peter_e(at)gmx(dot)net, tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: [SQL] 16 parameter limit |
Date: | 2002-08-14 03:28:52 |
Message-ID: | 3D59CE74.6010606@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches pgsql-sql |
Bruce Momjian wrote:
>>12) The biggie: Allowing the easy return of query results from a
>>procedure. This is currently supported through a rather difficult
>>workaround involving either the ROWTYPE datatype or a return Cursor.
>> Both approaches require the use of a procedural code loop on the
>>interface side to read the data being returned ... much clumsier than
>>just dumping the data ala PL/SQL or T-SQL. If implemented, this rowset
>>return would the the difference between a CREATE FUNCTION and a CREATE
>>PROCEDURE statement.
>
>
> Done for 7.3.
Um, not done yet (PL/pgSQL table functions). Currently only SQL and C
functions supported. I've had an off-line discussion with Neil, and I
think he is working this item and plans to have it ready for 7.3.
CREATE PROCEDURE is not planned for 7.3 at all (I don't think; see the
CALL foo recent discussion).
It's not clear to me which one is meant by the above. "Dumping the data
ala PL/SQL or T-SQL" could mean either. PL/SQL supports table functions;
T-SQL only supports the CALL foo type capability. See:
http://archives.postgresql.org/pgsql-general/2002-08/msg00602.php
for a description of the difference.
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-08-14 03:32:59 | Re: Temporary Views |
Previous Message | Hannu Krosing | 2002-08-14 03:26:19 | Re: OOP real life example (was Re: Why is MySQL more |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-14 03:36:04 | Re: [SQL] 16 parameter limit |
Previous Message | Tatsuo Ishii | 2002-08-14 02:52:24 | Re: [HACKERS] SQL99 CONVERT() function |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-08-14 03:36:04 | Re: [SQL] 16 parameter limit |
Previous Message | Bruce Momjian | 2002-08-14 02:48:12 | Re: [SQL] 16 parameter limit |