Re: Correcting Error message

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

> Michael Glaesemann <grzm(at)seespotcode(dot)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