Chris Gamache <[EMAIL PROTECTED]> writes:
> By giving it a definitive range I was able to coax query planner to use the
> index:
> SELECT id FROM trans_table WHERE trans_date >= (SELECT
> current_date::timestamptz) AND trans_date < (SELECT current_timestamp);
> BTW, This didn't work:
> SELECT id FROM trans_table WHERE trans_date >= current_date::timestamptz AND
> trans_date < current_timestamp;
[ scratches head... ] AFAICS the latter should "work" too. Doesn't
EXPLAIN show the same estimated row count for both versions?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
