Postgres Pro
Downloads
Home   >   mailing lists

Problem using CASTed timestamp column - Mailing list pgsql-general

From Digimer
Subject Problem using CASTed timestamp column
Date
Msg-id 4CDC6DB2.5000902@alteeve.com
Whole thread Raw
Responses Re: Problem using CASTed timestamp column  (Richard Broersma <richard.broersma@gmail.com>)
List pgsql-general
Tree view 
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@alteeve.com
AN!Whitepapers: http://alteeve.com
Node Assassin:  http://nodeassassin.org

pgsql-general by date:

Previous
From: Jeff Ross
Date:
Subject: Re: Instructions/status of modpglogger
Next
From: Richard Broersma
Date:
Subject: Re: Problem using CASTed timestamp column