Perhaps you have a solution??
Bob
----- Original Message -----
From: "Scott Marlowe" <smarlowe@xxxxxxxxxxxxxxxxx>
To: "Bob Pawley" <rjpawley@xxxxxxx>
Cc: "Postgresql" <pgsql-general@xxxxxxxxxxxxxx>
Sent: Wednesday, January 18, 2006 10:03 AM
Subject: Re: [GENERAL] Dates
On Wed, 2006-01-18 at 12:00, Bob Pawley wrote:
Hi Folks
I have a column for date which defaults to the ambigous 2005-1-1
format.
The documantation indicates how to change this to the unambigous Jan 1
2005, but the instructions aren't clear to me.
Actually, if the year comes first, it is not ambiguous. It will always
be month-day if the year comes first. It's the
mm/dd/yyyy or dd/mm/yyyy that is the issue.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
