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