V0.1 patch for TODO Item: SQL-language reference parameters by name.

Hello all,

Hereby an alpha version regarding the:

TODO Item: SQL-language reference parameters by name.

I am sending this patch to check if I am on the right track.

So please take a look at this if possible.

What does this patch do?

As discussed in thread:
http://archives.postgresql.org/pgsql-hackers/2007-10/msg01490.php,

this patch adds an additional parameter (char **argnames) to
pg_parse_and_rewrite and

pg_analyze_and_rewrite and ParseState.

When transformColumnRef is about to report an error for a non existing
column,a final match is

performed to see if the non existing column is a parameter name. (argnames)

If true, then a new node is created by transformParamRef

NOTE:

- This patch is created using MSVC++ !

- Nothing is done yet for polymorphic arguments.

My test where:

create table tbl1(id serial,field1 integer,field2 varchar);

insert into tbl1 (field1,field2) values(11,'zzzz');

insert into tbl1 (field1,field2) values(22,'yyyy');

create or replace function func1(par1 integer,par2 integer,par3 varchar)
returns setof record as

$$

select

par1::text,

par2,

par1+par2,

par2+par1,

par1+field1,

(field1+par2)::varchar,

par3,

field2 || ' ' || par3

from

tbl1;

$$ language sql;

select func1(2,4,'aaaa');

select * from func1(5,16,'bbbb') as (a text ,b int ,c int, e int, f int,g
varchar,h varchar,i text);

results:

"(2,4,6,6,13,15,aaaa,"zzzz aaaa")"

"(2,4,6,6,24,26,aaaa,"yyyy aaaa")"

And

"5";16;21;21;16;"27";"bbbb";"zzzz bbbb"

"5";16;21;21;27;"38";"bbbb";"yyyy bbbb"

Regards,

Gevik