Re: How to find out the weekday from a date???

Jose Manuel Lorenzo Lopez <jose-manuel.lorenzo-lopez@ica.conti.de> writes:
> I am using Postgresql 7.0.3!

Support for 'dow' in extract() is new in PG 7.1.  Time to update.

Or use the underlying date_part function:

play=> select date_part('dow', now());
 date_part
-----------
         2
(1 row)

seems to work fine in 7.0 as well as 7.1.

            regards, tom lane