Re: Correcting Error message - Mailing list pgsql-hackers

From Michael Glaesemann
Subject Re: Correcting Error message
Date
Msg-id D015AB00-E316-48B6-8B25-22D510A6914D@seespotcode.net
Whole thread Raw
In response to Re: Correcting Error message  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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





pgsql-hackers by date:

Previous
From: Greg Smith
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration
Next
From: Greg Smith
Date:
Subject: Re: Hot Standby query cancellation and Streaming Replication integration