Re: RFE: Column aliases in WHERE clauses

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: Steve Haresnape <s(dot)haresnape(at)creativeintegrity(dot)co(dot)nz>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: RFE: Column aliases in WHERE clauses
Date: 2012-09-19 12:36:18
Message-ID: 5059BC42.7010906@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Craig Ringer

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2012-09-19 12:39:16 Re: drop table if exists <VIEW_NAME>;
Previous Message Marc Mamin 2012-09-19 11:54:39 drop table if exists <VIEW_NAME>;