Skip site navigation (1) Skip section navigation (2)

Re: allowed variable names in functions?

From: "A B" <gentosaker(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: allowed variable names in functions?
Date: 2008-06-30 10:38:40
Message-ID: dbbf25900806300338r2d65e7ccye68ad728fae1e389@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
Then my assumption was wrong.
Here is the entire function and it fails with the names
c2,c2div,c3,c3div, but if names are changed, it works!
(by works I mean I get the "hello" lines printed) There is nothing
wrong with the select statement either, that works fine if I run it
stand-alone, or with the names of c2,c2div,c3,c3div changed.

CREATE OR REPLACE FUNCTION foo(pid_ INTEGER) RETURNS void AS $$
DECLARE
	c2 REAL;
	c2div REAL;
	c3 REAL;
	c3div REAL;
	weights RECORD;
	tmp RECORD;
	retval RECORD;
	t RECORD;
BEGIN
RAISE NOTICE 'starting...';
	FOR tmp IN SELECT id,c2,c3 FROM Master  WHERE pid=pid_  AND c3 !=0 LOOP
		RAISE NOTICE 'hello %',tmp.id;
	END LOOP;
	RETURN;
END; $$  LANGUAGE plpgsql;


2008/6/30 Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>:
> 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.

In response to

Responses

pgsql-general by date

Next:From: A BDate: 2008-06-30 10:44:31
Subject: Re: allowed variable names in functions?
Previous:From: Pavel StehuleDate: 2008-06-30 10:30:47
Subject: Re: allowed variable names in functions?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group