We have for same questions different answers now:
(DAY OF WEEK)
test=# select date_part('dow', now());date_part
----------- 1
(1 row)
test=# select to_char(now(), 'D');to_char
---------2
(1 row)
For to_char() I use POSIX definition of 'tm' where week start on Sunday.
Is it right? (Exuse me, I see archive, but without some effect...).
Or we will support both styles?
Karel