Re: Correcting Error message

On Feb 26, 2010, at 21:03 , Tom Lane wrote:

> Michael Glaesemann <grzm@seespotcode.net> writes:
>> On Feb 26, 2010, at 3:30 , Piyush Newe wrote:
>>> SELECT (footable.*).foofunc FROM footable;
>>> ERROR:  column footable.foofunc does not exist
>
>> Is that calling syntax correct?  I'd think it should be:
>> SELECT foofunc(footable.*, 10) FROM footable;
>
> He's relying on the f(x) === x.f syntactic equivalence, as per the
> comments for ParseFuncOrColumn:


>> Note there are two arguments to foofunc (in either version)
>
> ... and the example also relies on the presence of default arguments  
> for
> both functions.  This makes both of them match a single-argument call,
> resulting in an ambiguous-function situation.  The proposed change
> would cause it to actually throw an "ambiguous function" error.

Ah! Learned two new things. Thanks, Tom!

Michael Glaesemann
grzm seespotcode net