Re: Usage of RETURN QUERY

Yes, 'SELECT * FROM' works fine


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Wednesday, December 08, 2010 5:38 PM
To: edorofeyev@gmail.com
Cc: pgsql-novice@postgresql.org
Subject: Re: [NOVICE] Usage of RETURN QUERY

"Eugene Dorofeyev" <edorofeyev@gmail.com> writes:
> But it returns data as a set of rows like

> (10354,"EXCEPTION: ...")
> (4363,"Access Violation Exception.")

> Is there a way to get columns as in a view ?

Try "SELECT * FROM func(...)" rather than just "SELECT func(...)".

            regards, tom lane