Returning multiple columns with a function??
От | Joshua D. Drake |
---|---|
Тема | Returning multiple columns with a function?? |
Дата | |
Msg-id | 3DFE5823.7090003@commandprompt.com обсуждение исходный текст |
Ответы |
Re: Returning multiple columns with a function??
Re: Returning multiple columns with a function?? Re: Returning multiple columns with a function?? |
Список | pgsql-general |
Hello, We are starting to test 7.3 for Mammoth (we always test a release behind) and are having some problems understanding what the exact features limitations of the new table functionality is. Specifically in the announce (and talked about ALOT) is: Table Functions PostgreSQL version 7.3 has greatly simplified returning result sets of rows and columns in database functions. This significantly enhances the useability of stored procedures in PostgreSQL, and will make it even easier to port Oracle applications to PostgreSQL. But something like this fails: CREATE OR REPLACE FUNCTION test_multiple () RETURNS SETOF text AS 'SELECT ''a'', ''b''' LANGUAGE 'SQL'; ERROR: function declared to return text returns multiple columns in final SELECT What are we missing? Sincerley, Joshua Drake -- <COMPANY>CommandPrompt - http://www.commandprompt.com </COMPANY> <CONTACT> <PHONE>+1.503.222-2783</PHONE> </CONTACT>
В списке pgsql-general по дате отправления: