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
James B. Byrne byrn...@harte-lyne.ca 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
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 the date