"prasad" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
