Skip site navigation (1) Skip section navigation (2)

Re: [SQL] 16 parameter limit

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Joe Conway <mail(at)joeconway(dot)com>
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:36:04
Message-ID: 200208140336.g7E3a4e25289@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patchespgsql-sql
Joe Conway wrote:
> 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.

OK, added to 7.3 open items:

	Allow PL/PgSQL functions to return sets

> CREATE PROCEDURE is not planned for 7.3 at all (I don't think; see the 
> CALL foo recent discussion).

Right, on TODO.

> 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.

Not sure.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2002-08-14 03:44:19
Subject: Re: Temporary Views
Previous:From: Bruce MomjianDate: 2002-08-14 03:34:28
Subject: Re: Possible enhancement : replace view ?

pgsql-patches by date

Next:From: Bruce MomjianDate: 2002-08-14 05:09:16
Subject: Re: Better handling of parse errors
Previous:From: Joe ConwayDate: 2002-08-14 03:28:52
Subject: Re: [SQL] 16 parameter limit

pgsql-sql by date

Next:From: Christopher Kings-LynneDate: 2002-08-14 04:37:56
Subject: tsearch vs. fulltextindex
Previous:From: Joe ConwayDate: 2002-08-14 03:28:52
Subject: Re: [SQL] 16 parameter limit

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group