Hello it works in my 8.1 postgres=# CREATE LANGUAGE plpgsql; CREATE LANGUAGE postgres=# create or replace function foo(a int) returns void as $$declare c2 real; c2div real; begin c2div := 10.9; end; $$ language plpgsql; CREATE FUNCTION postgres=# select foo(10); foo ----- (1 row) Regards Pavel Stehule 2008/6/30 A B <gentosaker@xxxxxxxxx>: > Hello. > I suspect that in a plpgsql function > > DECLARE > c2 REAL; > cadiv REAL; > > works but > > c2 REAL; > c2div REAL; > > doesn't. > > Is this true, and if so, what are the rules for the names in the > function? I use 8.1. > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
