[BUGS] Bug in select to_char(now(), 'YYYY/MM/DD HH24:MI:SS:MS')

2008-06-11 Thread Pierre Le Mouëllic
Hi, Sometimes, when we run the SQL request : select to_char(now(), '/MM/DD HH24:MI:SS:MS') we've got the result : 2008/06/11 15:01:06:1000 instead of : 2008/06/11 15:01:07:000 Our version of postgres is PostgreSQL 8.2.6 64-bit on i386-pc-solaris2.10, compiled by /ws/on10-tools/SUNWs

Re: [BUGS] No way to list DDL for a new type

2008-06-11 Thread Merlin Moncure
On 6/11/08, Heikki Linnakangas <[EMAIL PROTECTED]> wrote: > Rajesh Chopra wrote: > > Hi, > > I created a new type as follows: > > CREATE TYPE compfoo AS (f1 int, f2 text); > > > > Now I need the DDL which postgres used to create this type. > > > > Huh, what do you mean? That CREATE TYPE statement i

Re: [BUGS] No way to list DDL for a new type

2008-06-11 Thread Heikki Linnakangas
Rajesh Chopra wrote: Hi, I created a new type as follows: CREATE TYPE compfoo AS (f1 int, f2 text); Now I need the DDL which postgres used to create this type. Huh, what do you mean? That CREATE TYPE statement is DDL. Anyway, this doesn't sound like a bug. Please use the appropriate mailing

[BUGS] No way to list DDL for a new type

2008-06-11 Thread Rajesh Chopra
Hi, I created a new type as follows: CREATE TYPE compfoo AS (f1 int, f2 text); Now I need the DDL which postgres used to create this type. Thanks. With Regards, rc_bio