Postgres Pro
Downloads
Home   >   mailing lists

Re: functions vs stored procedures - Mailing list pgsql-admin

From Tom Lane
Subject Re: functions vs stored procedures
Date
Msg-id 14063.1121347025@sss.pgh.pa.us
Whole thread Raw
In response to functions vs stored procedures  (Ezequiel Tolnay <mail@etolnay.com.ar>)
Responses Re: functions vs stored procedures  (Ezequiel Tolnay <mail@etolnay.com.ar>)
List pgsql-admin
Tree view 
Ezequiel Tolnay <mail@etolnay.com.ar> writes:
> I just can't get used to the annoyance of having to create a type for
> every single function that returns a rowset. It is frankly cumbersome.

Yup.  See coming attractions at, eg,
http://developer.postgresql.org/docs/postgres/xfunc-sql.html#XFUNC-OUTPUT-PARAMETERS
http://developer.postgresql.org/docs/postgres/plpgsql-declarations.html#PLPGSQL-DECLARATION-ALIASES

            regards, tom lane

pgsql-admin by date:

Previous
From: Marc McIntyre
Date:
Subject: Re: Anyone running PostgreSQL on Sun Solaris?
Next
From: Stephan Szabo
Date:
Subject: Re: LOOP and EXIT