"prasad" <prasad05_qs(at)yahoo(dot)co(dot)in> writes:
> i'm created a function
> ...
> Select *
> from "vw_getAllMessages"
> where "Message_Posted_To" = $1
> order by "Message_ID" desc;
> ...
> i get error
> ERROR: SELECT query has no destination for result data
> HINT: If you want to discard the results, use PERFORM instead.
> CONTEXT: PL/pgSQL function "Get_Inbox" line 5 at SQL statement
This is not a bug.
SELECT in plpgsql should always be a SELECT INTO. Like the hint
says, if you aren't wanting to send the results anywhere, use PERFORM.
regards, tom lane