Re: Problem using CASTed timestamp column

From: Richard Broersma <richard(dot)broersma(at)gmail(dot)com>
To: Digimer <linux(at)alteeve(dot)com>
Cc: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Problem using CASTed timestamp column
Date: 2010-11-11 22:59:49
Message-ID: AANLkTik+24UwHCnxPXa8ScOt-EgMt0aoEwZSP6j6jDR6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Nov 11, 2010 at 2:26 PM, Digimer <linux(at)alteeve(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2010-11-11 23:56:31 Re: Schema tool
Previous Message Jeff Ross 2010-11-11 22:51:15 Re: Instructions/status of modpglogger