Re: Correcting Error message

Поиск
Список
Период
Сортировка
От Michael Glaesemann
Тема Re: Correcting Error message
Дата
Msg-id D015AB00-E316-48B6-8B25-22D510A6914D@seespotcode.net
обсуждение исходный текст
Ответ на Re: Correcting Error message  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Hot Standby query cancellation and Streaming Replication integration
Следующее
От: Greg Smith
Дата:
Сообщение: Re: Hot Standby query cancellation and Streaming Replication integration