On Sun, Jul 19, 2009 at 01:20:27PM -0400, James B. Byrne wrote:
> I was sending off a where clause that looked somewhat like this:
>
> WHERE 'date_of_interest' <= 2009-07-18
>
> Now, as the date of interest was, in all but one case, prior to 1970
> this appeared to work. However, in one case th
"James B. Byrne" writes:
> My error was in not encapsulating a programmically inserted date
> string within quotation marks. This meant that I was sending off a
> where clause that looked somewhat like this:
> WHERE 'date_of_interest' <= 2009-07-18
Ah. You are apparently using a pre-8.3 PG re
I encountered a situation wrt date expressions that, although I
eventually resolved, has left me with a few unanswered questions
regarding how PG handles dates.
My error was in not encapsulating a programmically inserted date
string within quotation marks. This meant that I was sending off a
wher
