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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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