Stefan,
> My LEAST function would not work because
> my_timestamp_field has a datatype of "timestamp
> without time zone", and the TO_TIMESTAMP(...) creates
> a "timestamp *with* time zone". I could not find
> anything in the documentation about this behavior. I
> am running v7.3.2.
Just do a:
LEAST(my_timestamp_field,
TO_TIMESTAMP('2003-07-01 12:34:56',
'YYYY-MM-DD HH24:MI:SS')::TIMESTAMP WITHOUT TIME ZONE)
with and without time zone are effectively seperate data types with easy
casting.
--
Josh Berkus
Aglio Database Solutions
San Francisco
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
