From: Ross J. Reedstrom <reedstrm@rice.edu>
To: Michael Agbaglo <byteshifter@shifted-bytes.de>
Cc: Wei Weng <wweng@kencast.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: syntax for access an alias in the where clause ?
Date: Wed, 19 Jun 2002 18:56:22 -0500
Message-ID: <20020619235622.GA3650@rice.edu> (raw)
In-Reply-To: <3D10F3FB.6090706@shifted-bytes.de>
References: <3D10C770.7040100@shifted-bytes.de>
<1024516580.20296.8.camel@Monet>
<3D10F3FB.6090706@shifted-bytes.de>
On Wed, Jun 19, 2002 at 11:13:31PM +0200, Michael Agbaglo wrote:
>
>
> Wei Weng wrote:
>
> >Is it allowed to use spaces in postgresql alias?
> >
> >Why dont you try to use alias1 instead of "alias 1"?
>
>
>
> really amusing... muhahaha...
I'm sure he didn't mean to make a joke, nor ridicule you, it was just a
misundertanding.
> I don't use the brackets either... I didn't assume that you might be
> interested in how the expression looks like or what aliases I'm using...
Sometimes, it makes all the difference. In this case, it doesn't. Aliases
are not available in the 'order by' clause: you need to repeat te full
expressions there.
Ross
>
>
> >
> >
> >On Wed, 2002-06-19 at 14:03, Michael Agbaglo wrote:
> >
> >>Hi !
> >>
> >>It's long ago since I used SQL :-)
> >>
> >>select [expression 1] as [alias 1], [expression 2] as [alias 2]
> >>where [alias 1] < [alias 2]
> >>order by [alias 2] - [alias 1]
> >>
> >>---> ERROR: Attribute '[alias 1]' not found
> >>
> >>I found a lot of 'select [expression] as' but I've never seen somebody
> >>accessing the alias ... Can't this be done ?
> >>
> >>M.
> >>
> >>
> >>
> >>
> >>---------------------------(end of broadcast)---------------------------
> >>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
> >>
> >>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: reedstrm@rice.edu, byteshifter@shifted-bytes.de, wweng@kencast.com
Subject: Re: syntax for access an alias in the where clause ?
In-Reply-To: <20020619235622.GA3650@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox