Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
How to add a function that returns the result of a select statement?
- From: Gibson <gibson(at)nexgenstudio(dot)com>
- To: pgadmin-support(at)postgresql(dot)org
- Subject: How to add a function that returns the result of a select statement?
- Date: Fri, 18 Aug 2006 19:14:13 +0800
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>
- Follow-Ups:
- Prev by Date: Re: segfault with saving postgresql.conf
- Next by Date: Re: How to add a function that returns the result of a select statement?
- Previous by thread: segfault with saving postgresql.conf
- Next by thread: Re: How to add a function that returns the result of a select statement?
- Indexes: