----- "Andreas Moeller" <a.moeller@xxxxxxx> wrote: > 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 Are you sure this worked in 8.1? SELECT INTO in plpgsql needs to point to a variable as noted by the error message. You need to declare a variable. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
