From: | "Andreas Moeller" <a(dot)moeller(at)teia(dot)de> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Why not working under 8.3 |
Date: | 2009-03-04 15:18:53 |
Message-ID: | 806F7E346D4F954395CF26AC74B963B12FE4F5@spc-lv-001.SPCLEHRBUCH.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Following lines produce an error message under 8.3. - but not under 8.1.
Why?
CREATE OR REPLACE FUNCTION dodi() RETURNS boolean AS
$$
BEGIN
SELECT 'abc' INTO TEMPORARY foonana;
RETURN FALSE;
END;
$$
LANGUAGE 'plpgsql';
FEHLER: syntax error at "TEMPORARY"
DETAIL: Expected record variable, row variable, or list of scalar variables following INTO.
CONTEXT: compile of PL/pgSQL function "dodi" near line 2
********** Fehler **********
FEHLER: syntax error at "TEMPORARY"
SQL Status:42601
Detail:Expected record variable, row variable, or list of scalar variables following INTO.
Kontext:compile of PL/pgSQL function "dodi" near line 2
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2009-03-04 16:05:56 | Re: Why not working under 8.3 |
Previous Message | Douglas J Hunley | 2009-03-04 14:48:30 | Re: pgsql announce now on twitter |