[BUGS] to_date problem.

2002-06-12 Thread lewwid
select to_date('December 12 2002','Month dd '); to_date 2002-12-02 select to_date('January 12 2002','Month dd '); to_date 0005-06-24 <- Problem right there. select to_date('January 12, 2002','Month dd, '); to_date

Re: [BUGS] Bug #691: CREATE TABLE AS ignores explicit column names with UNION

2002-06-12 Thread Tom Lane
[EMAIL PROTECTED] writes: > CREATE TABLE AS ignores explicitly specified column names when the query contains a >UNION. This is illustrated in the example below. Good catch! If you need a fix immediately, I think the attached patch will do the trick. (Line numbers are for current sources, but

[BUGS] Bug #691: CREATE TABLE AS ignores explicit column names with UNION

2002-06-12 Thread pgsql-bugs
Todd Reed ([EMAIL PROTECTED]) reports a bug with a severity of 3 The lower the number the more severe it is. Short Description CREATE TABLE AS ignores explicit column names with UNION Long Description CREATE TABLE AS ignores explicitly specified column names when the query contains a UNION. Th

Re: [HACKERS] [BUGS] Bug #659: lower()/upper() bug on

2002-06-12 Thread Enke, Michael
Tatsuo Ishii wrote: > > > > > > There are "full width alphabets" in Japanese. Thoes include not only > > > > > ASCII letters but also some European characters. > > > > > > > > Are these ASCII and European characters uppercased in some > > > > Japanese-specific way ? > > > > > > Probably not, but