Why not working under 8.3

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

Browse pgsql-general by date

  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