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>

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to