"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.