Re: Proposal TODO Item: SQL-language reference parameters by name - Mailing list pgsql-hackers

From Gevik Babakhani
Subject Re: Proposal TODO Item: SQL-language reference parameters by name
Date
Msg-id 004301c81b45$97ad75c0$0a01a8c0@gevmus
Whole thread Raw
In response to Proposal TODO Item: SQL-language reference parameters by name  ("Gevik Babakhani" <pgdev@xs4all.nl>)
Responses Re: Proposal TODO Item: SQL-language reference parameters by name
List pgsql-hackers
Thank you Tom.

> I think the most likely implementation would involve adding hooks
> in the parser at places where "unknown column" errors are about to
> be thrown, so that a function language could check for a match to
> one of its variable names only after the query-exposed names are
> checked.
Would this be the right path to follow?

Assuming we are allowed to include parameter names into ParseState, we can
match the "non existing" colnames against the list of parameter
names when transformColumnRef (or someware safe in that path). I Think this 
way
we at least can parse a function when CreateFunction is called.

If the above is correct to implement then the check should have low 
precedence in order to not break
the current functionality (first colnames, then $n params and then parameter 
names)

Regards,
Gevik.








pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: URGENT HELP about 'duration' stats
Next
From: Peter Eisentraut
Date:
Subject: Re: [COMMITTERS] pgsql: simple script to pull together a very small (<500k) tar file