[BUGS] Local Host Security? All users should have passwords optionally...

Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Local Host Security? All users should have passwords optionally... Long Description I wanted to add passwords to all the users on the database, including the postgres

Re: [BUGS] date_part('dow', '2001-03-25') ??!

On Mon, Mar 26, 2001 at 03:43:49PM +0700, Dmitry Gercog wrote: > Hi! > > Why? > > SELECT date_part('dow', '2001-03-24'); > return '6' > > and > > SELECT date_part('dow', '2001-03-25'); > > return '6', but must be '0'!!! Fixed in 7.1. -- Karel Zak <[EMAIL PROTECTED]> http://home.zf.jcu

[BUGS] date_part('dow', '2001-03-25') ??!

Hi! Why? SELECT date_part('dow', '2001-03-24'); return '6' and SELECT date_part('dow', '2001-03-25'); return '6', but must be '0'!!! For last Sunday '2001-03-18' this construction return '0'! My system SuSe Linux 7.0 PostgreSQL version 7.0.3 When I use system command "date": date +%w -d