How to add a function that returns the result of a select statement?

Поиск
Список
Период
Сортировка
От Gibson
Тема How to add a function that returns the result of a select statement?
Дата
Msg-id 44E5A105.8020909@nexgenstudio.com
обсуждение исходный текст
Ответы Re: How to add a function that returns the result of a select statement?  ("ben sewell" <mosherben@gmail.com>)
Список pgadmin-support
Hi,

I've tried using the "New function" option to create a new SQL function 
that will return the result of a select statement "Select * from user". 
I've set the return type to be the "user" table. But i keep getting an 
error about "Syntax error at or near Select". My SQL statement is very 
simple "select * from user" so there is no syntax error. Anyone can help?
-- 

Cheers
Gibson Tang
Game Programmer
179, River Valley Building #04-09
Singapore 179033
Nexgen Studio <www.nexgenstudio.com>


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

Предыдущее
От: Tim Rupp
Дата:
Сообщение: Re: segfault with saving postgresql.conf
Следующее
От: "ben sewell"
Дата:
Сообщение: Re: How to add a function that returns the result of a select statement?