Re: RFE: Column aliases in WHERE clauses - Mailing list pgsql-general

From Rafal Pietrak
Subject Re: RFE: Column aliases in WHERE clauses
Date
Msg-id 1348059802.21898.275.camel@localhost.localdomain
Whole thread Raw
In response to Re: RFE: Column aliases in WHERE clauses  (Craig Ringer <ringerc@ringerc.id.au>)
List 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 by date:

Previous
From: Craig Ringer
Date:
Subject: Re: drop table if exists ;
Next
From: "David Johnston"
Date:
Subject: Re: RFE: Column aliases in WHERE clauses