| From: | Christine Penner <chris(at)fp2(dot)ca> |
|---|---|
| To: | rod(at)iol(dot)ie |
| Cc: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: function problems |
| Date: | 2010-11-16 22:13:09 |
| Message-ID: | 19740413173256.B37490D274504B37@edtnaa11.telusplanet.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jorge Arévalo | 2010-11-16 22:35:00 | Re: Programming error: Out of Memory |
| Previous Message | Raymond O'Donnell | 2010-11-16 22:12:56 | Re: function problems |