Skip site navigation (1) Skip section navigation (2)

Re: using column alias to make operations

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: using column alias to make operations
Date: 2008-01-23 09:36:34
Message-ID: 20080123093634.GD20579@a-kretschmer.de (view raw or flat)
Thread:
Lists: pgsql-novice
am  Wed, dem 23.01.2008, um  9:10:09 +0100 mailte Raimon Fernandez folgendes:
> I thought I could use the column alias, because in the ORDER BY  
> clausule I can use them ...

You can't, because first PG fetch the result, this result has the
column-aliases. A consecutively ORDER BY can access this aliases, but not
the SELECT self.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2008-01-23 10:12:59
Subject: Re: using column alias to make operations
Previous:From: Andrej Ricnik-BayDate: 2008-01-23 08:24:23
Subject: Re: Need help with a function boolean --> text or array

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group