Re: [GENERAL] variable name in plpgsql

2010-09-08 Thread Darren Duncan
zhong ming wu wrote: It seems that one cannot use the variable name that is the same as the column name of a relation like in the following function -- create or replace function bla() returns void language plpgsql as $$ declare email varchar; begin select email into email fr

Re: [GENERAL] variable name in plpgsql

2010-09-08 Thread Adrian Klaver
On Wednesday 08 September 2010 5:23:20 pm zhong ming wu wrote: > It seems that one cannot use the variable name that is the same as the > column name of a relation like in the following function > > -- > create or replace function bla() returns void language plpgsql as $$ > declare > emai

[GENERAL] variable name in plpgsql

2010-09-08 Thread zhong ming wu
It seems that one cannot use the variable name that is the same as the column name of a relation like in the following function -- create or replace function bla() returns void language plpgsql as $$ declare email varchar; begin select email into email from pass where id=1;