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
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
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
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