Re: [GENERAL] EXECUTE USING problem

2011-11-15 Thread Raymond O'Donnell
On 15/11/2011 12:45, Graham wrote: > Using PG 9.0.3, I wish to dynamically reference a column in a table > passed into a PL/PgSQL function as follows: > > -- A table with some values. > DROP TABLE IF EXISTS table1; > CREATE TABLE table1 ( > code INT, > descr TEXT > ); > > INSERT INTO

Re: [GENERAL] EXECUTE USING problem

2011-11-15 Thread Pavel Stehule
Hello 2011/11/15 Graham : > Using PG 9.0.3, I wish to dynamically reference a column in a table passed > into a PL/PgSQL function as follows: > > -- A table with some values. >  DROP TABLE IF EXISTS table1; >  CREATE TABLE table1 ( >     code INT, >     descr TEXT >  ); > > INSERT INTO table1 VALU

[GENERAL] EXECUTE USING problem

2011-11-15 Thread Graham
Using PG 9.0.3, I wish to dynamically reference a column in a table passed into a PL/PgSQL function as follows: -- A table with some values. DROP TABLE IF EXISTS table1; CREATE TABLE table1 ( code INT, descr TEXT ); INSERT INTO table1 VALUES ('1','a'); INSERT INTO table1 VALUES ('2