Re: function problems

ERROR:  query has no destination for result data
HINT:  If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT:  PL/pgSQL function "subjectdisplay" line 7 at SQL statement

********** Error **********

ERROR: query has no destination for result data
SQL state: 42601
Hint: If you want to discard the results of a SELECT, use PERFORM instead.
Context: PL/pgSQL function "subjectdisplay" line 7 at SQL statement

At 02:09 PM 16/11/2010, Raymond O'Donnell wrote:
>On 16/11/2010 21:57, Christine Penner wrote:
>>I have seen other functions (written by others) that do this.  So I
>>assume its ok. I'm open to suggestions though. As long as it works.
>
>OK, fair enough. What error are you getting?
>
>Ray.
>
>--
>Raymond O'Donnell :: Galway :: Ireland
>rod@iol.ie