Re: returning a recordset from PLpg/SQL

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: returning a recordset from PLpg/SQL
Дата
Msg-id 20040301073006.A71391@megazone.bigpanda.com
обсуждение исходный текст
Ответ на Re: returning a recordset from PLpg/SQL  (Terence Kearns <terencek@isd.canberra.edu.au>)
Ответы Re: returning a recordset from PLpg/SQL  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: returning a recordset from PLpg/SQL  (Terence Kearns <terencek@isd.canberra.edu.au>)
Список pgsql-sql
On Tue, 2 Mar 2004, Terence Kearns wrote:

> Tom Lane wrote:
>  > Terence Kearns <terencek@isd.canberra.edu.au> writes:
>  >
>  >>I tried
>  >>RETURNS SETOF RECORD
>  >>but that doesn't work
>  >
>  >
>  > Sure it does, if you use it correctly.  Better show us what you did.
>  >
>  >             regards, tom lane
>
> Well I haven't yet done anything because I couldn't get anything to
> compile which returned SETOF RECORD..

As a starting point, SETOF "RECORD" is different from SETOF RECORD given
PostgreSQL's fold case to lower case for unquoted names.


В списке pgsql-sql по дате отправления:

Предыдущее
От: Terence Kearns
Дата:
Сообщение: Re: returning a recordset from PLpg/SQL
Следующее
От: Dana Hudes
Дата:
Сообщение: Re: User defined types -- Social Security number...