> 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])

Reply via email to