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