Problem using CASTed timestamp column

From: Digimer <linux(at)alteeve(dot)com>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: Problem using CASTed timestamp column
Date: 2010-11-11 22:26:58
Message-ID: 4CDC6DB2.5000902@alteeve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I've got an odd problem. I've got a column with a non-standard
date/time in it that I carve up and re-cast as a timestamp. This works
fine. Now though, I am trying to check/restrict my results to dates
before now() and it's telling me that the columns doesn't exist.

http://pastebin.com/sExiBynp

Any hints on what I am doing wrong?

Thanks!

--
Digimer
E-Mail: digimer(at)alteeve(dot)com
AN!Whitepapers: http://alteeve.com
Node Assassin: http://nodeassassin.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-11-11 22:27:12 Re: Schema tool
Previous Message Demitri Muna 2010-11-11 22:05:06 Seeking advice on database replication.