> From: Tom Lane [mailto:[EMAIL PROTECTED]
> My guess is that the original SQL was
> WHERE ... date_from = current_timestamp
> This should be
> WHERE ... date_from = localtimestamp
> if timestamp without tz is the intended column datatype.
Thank you. The problem was exactly this:
current_timestamp: TIMESTAMP with TZ
my attribute "date_from TIMESTAMP " - without TZ
After change to
WHERE ... date_from = localtimestamp
the plan worked just well.
> (it really sucks that SQL specifies "timestamp" to default to "without time
zone" ...)
Tzones is one area I never delt with and IMMEDIATELY ran into problem,
implicit type conversion is an evil.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
