Karsten Hilbert <[EMAIL PROTECTED]> writes: >> So I figured it would make sense to add a functional index >> on date_trunc('day', dob) to the patients table. Which >> worked (appeared to, at least) with PG 7.4.
For the record, this was changed just before 8.0 release: http://archives.postgresql.org/pgsql-hackers/2004-10/msg00030.php regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly