Re: Usage of RETURN QUERY - Mailing list pgsql-novice

From Tom Lane
Subject Re: Usage of RETURN QUERY
Date
Msg-id 15347.1291822685@sss.pgh.pa.us
Whole thread Raw
In response to Re: Usage of RETURN QUERY  ("Eugene Dorofeyev" <edorofeyev@gmail.com>)
Responses Re: Usage of RETURN QUERY  ("Eugene Dorofeyev" <edorofeyev@gmail.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: "Eugene Dorofeyev"
Date:
Subject: Re: Usage of RETURN QUERY
Next
From: "Eugene Dorofeyev"
Date:
Subject: Re: Usage of RETURN QUERY