On Mon, 25 Oct 1999, Aaron J. Seigo wrote:
> hi...
> my experience has been that this:
>
> select date_time_field::date from table_name;
>
> is much faster than:
>
> select date_trunc('day',date) from table_name;
>
Yes, date_trunc() is comlicated routine, this func. must internal parse and
search your 'day' - it is slowly. (.. instead of datetime_date() which make
date from full DateTime only.)
Zakkr
------------------------------------------------------------------------------
<zakkr@zf.jcu.cz> http://home.zf.jcu.cz/~zakkr/
Kim Project: http://home.zf.jcu.cz/~zakkr/kim/ (process manager)
FTP: ftp://ftp2.zf.jcu.cz/users/zakkr/ (C/ncurses/PgSQL)
------------------------------------------------------------------------------
...and cathedral dilapidate