Re: Problem using CASTed timestamp column

Поиск
Список
Период
Сортировка
От Richard Broersma
Тема Re: Problem using CASTed timestamp column
Дата
Msg-id AANLkTik+24UwHCnxPXa8ScOt-EgMt0aoEwZSP6j6jDR6@mail.gmail.com
обсуждение исходный текст
Ответ на Problem using CASTed timestamp column  (Digimer <linux@alteeve.com>)
Список 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 по дате отправления:

Предыдущее
От: Digimer
Дата:
Сообщение: Problem using CASTed timestamp column
Следующее
От: Dann Corbit
Дата:
Сообщение: Re: Schema tool