Postgres Pro
Downloads
Home   >   mailing lists

Re: Opinion / advice needed for TODO: function params ref by name - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Opinion / advice needed for TODO: function params ref by name
Date
Msg-id 22432.1194367058@sss.pgh.pa.us
Whole thread Raw
In response to Opinion / advice needed for TODO: function params ref by name  ("Gevik Babakhani" <pgdev@xs4all.nl>)
List pgsql-hackers
Tree view 
"Gevik Babakhani" <pgdev@xs4all.nl> writes:
> Unfortunately for func.param is this problematic because
> qualifiedNameToVar and transformWholeRowRef/ParseFuncOrColumn
> internally call RTE functions which justifiably throw an "ambiguous column
> error". 

What's the problem?  If it's ambiguous within the query, it's ambiguous.

> a) Check for func.param before qualifiedNameToVar and 
>     transformWholeRowRef/ParseFuncOrColumn 

This is 100% backwards.
        regards, tom lane

pgsql-hackers by date:

Previous
From: "Gevik Babakhani"
Date:
Subject: Opinion / advice needed for TODO: function params ref by name
Next
From: Tom Lane
Date:
Subject: Re: regtype sorting broken in 8.3