Re: RFE: Column aliases in WHERE clauses

Поиск
Список
Период
Сортировка
От Rafal Pietrak
Тема Re: RFE: Column aliases in WHERE clauses
Дата
Msg-id 1348059802.21898.275.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: RFE: Column aliases in WHERE clauses  (Craig Ringer <ringerc@ringerc.id.au>)
Список pgsql-general
On Wed, 2012-09-19 at 20:36 +0800, Craig Ringer wrote:
> On 09/19/2012 02:36 PM, Steve Haresnape wrote:
>
> > Since some dialects support the idiom and others don't there can't be
> > any compelling reason to withhold support. It's really a matter of style.
> > For my money the DRY style is better.
>
> So you're saying that you want the implementation to effectively clone
> the aliased SELECT term into the WHERE clause?
>
> If so, what about functions with side-effects?

What about them: if they are put in the where clause by the user - e.g.
not from unaliasing?

Just bug-traceing will be more difficult from alias obfuscating effects.
That's all.

-R



В списке pgsql-general по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: drop table if exists ;
Следующее
От: "David Johnston"
Дата:
Сообщение: Re: RFE: Column aliases in WHERE clauses