Thread

RE: [SQL] indexing a datetime by date

Herouth Maoz <herouth@oumail.openu.ac.il> — 1999-03-30T11:59:14Z

At 06:07 +0200 on 30/03/1999, Jackson, DeJuan wrote:


>
> Part of the problem is that PostgreSQL Assumes that a functions value will
> change each time it is required, therefore automatic table scan and the
> function is called for each row.
> Try using 'now'::date instead of now()::date

How about using the ANSI standard CURRENT_DATE instead of either? It's
already of type date. Or is it considered a function call?

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma