[BUGS] Re: date_part returns wrong day for 1974-04-28

2001-04-09 Thread Phil Steinke
* Thomas Lockhart was mumbling about.. > You are likely running across a "known feature" in PostgreSQL for > versions before the almost-here v7.1. I do not know which time zone you > are running in (need that info!) but in the US Pacific Time Zone Aha.. I'm in Eastern (Canada), and doing this fo

[BUGS] Re: date_part returns wrong day for 1974-04-28

2001-04-09 Thread Thomas Lockhart
> Short Description > date_part returns wrong day for 1974-04-28 > Long Description > The date_part function is returning the wrong value for the date 1974-04-28. It >seems to work with other similar dates (+/- a day, +/- a year). > Feel free to contact me for more information. You are likely r

Re: [BUGS] Comment bug in psql

2001-04-09 Thread Bruce Momjian
Looks like this is fixed in 7.1RC4: test=> /* Foo bar test*>gazonk's gurka test*>2001*/ test-> CREATE TABLE foo (bar INTEGER); CREATE Thanks. > > Hi! > > I just found a bug in psql 7.0.3 (a FreeBSD 4.2 port). > > 1 db=# /* Foo bar

[BUGS] date_part returns wrong day for 1974-04-28

2001-04-09 Thread pgsql-bugs
Phil Steinke ([EMAIL PROTECTED]) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description date_part returns wrong day for 1974-04-28 Long Description The date_part function is returning the wrong value for the date 1974-04-28. It seems to work with other

[BUGS] Comment bug in psql

2001-04-09 Thread Martin Olsson
Hi! I just found a bug in psql 7.0.3 (a FreeBSD 4.2 port). 1 db=# /* Foo bar 2 db*#gazonk's gurka 3 db'#2001*/ 4 db'# CREATE TABLE foo (bar INTEGER); 5 db'# ' 6 db*# */ 7 db-# CREATE TABLE gazonk (blirp INTEGER); 8 ERROR: Unterminated quoted string 1 Prompt is =, ok Star