Re: return setof and Temp tables
От
William Leite Araújo
Тема
Re: return setof and Temp tables
Дата
Msg-id
bc63ad820602170442u35477d9bl@mail.gmail.com
Ответ на
return setof and Temp tables (Justin B. Kay)
Список
Дерево обсуждения
return setof and Temp tables "Justin B. Kay" <jkay@2pattersons.com>
Re: return setof and Temp tables Robert Treat <xzilla@users.sourceforge.net>
Re: return setof and Temp tables Tony Caduto <tony.caduto@amsoftwaredesign.com>
Re: return setof and Temp tables William Leite Araújo <william.bh@gmail.com>
2006/2/17, Justin B. Kay <jkay@2pattersons.com>:
Please, send the sample. I test "Create temp table AS SELECT * FROM <setof function>" and works on 8.0.6
--
William Leite Araújo
I have looked around and found that you can use return setof in a function to return a result set, but can you use a temp table as the setof target?
Yes, you can ( PostgreSQL 8.0.6 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5 (Debian 1:3.3.5-13))!
I build a temp table using various select statements and then try to return the result as a recordset. I get an error: type t1 does not exist.
Please, send the sample. I test "Create temp table AS SELECT * FROM <setof function>" and works on 8.0.6
--
William Leite Araújo
В списке pgsql-general по дате отправления
