"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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2007-01-23 06:04:43|
|Subject: Re: BUG #2915: Not working: GRANT * TO GROUP * |
|Previous:||From: Adriaan van Os||Date: 2007-01-22 09:19:25|
|Subject: Re: [HACKERS] BUG #2907: pg_get_serial_sequence quoting|