Re: Problem using CASTed timestamp column - Mailing list pgsql-general

From Richard Broersma
Subject Re: Problem using CASTed timestamp column
Date
Msg-id AANLkTik+24UwHCnxPXa8ScOt-EgMt0aoEwZSP6j6jDR6@mail.gmail.com
Whole thread Raw
In response to Problem using CASTed timestamp column  (Digimer <linux@alteeve.com>)
List pgsql-general
On Thu, Nov 11, 2010 at 2:26 PM, Digimer <linux@alteeve.com> wrote:

> http://pastebin.com/sExiBynp
>  Any hints on what I am doing wrong?

You can't refer to a column alias name in the order by clause
unfortunately.  You'll need to either nest this query in another query
to use the alias name, or you have to use a physical column name or an
expression.


--
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug

pgsql-general by date:

Previous
From: Digimer
Date:
Subject: Problem using CASTed timestamp column
Next
From: Dann Corbit
Date:
Subject: Re: Schema tool