Re: allowed variable names in functions?

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(at)gmail(dot)com>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>