From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Did this work in earlier version of Postgres? |
Date: | 2006-03-23 23:38:09 |
Message-ID: | 44233161.9010501@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tony Caduto wrote:
> I could have swore that this worked in earlier releases of Postgresql
> i.e. 7.4.
>
> CREATE TABLE public.test
> (
> junk double NOT NULL,
> CONSTRAINT junk_pkey PRIMARY KEY (junk)
> )WITHOUT OIDS;
>
> Now it gives a error that type double does not exist.
From the docs:
http://www.postgresql.org/docs/8.1/static/datatype.html#DATATYPE-FLOAT
the type is double precision.
J
>
> During the summer of 2004 I ported a large Firebird database to 7.x and
> firebird uses the term double which in PG is a float8 I believe.
> Anyway i was able to just paste the Firebird ddl in to the query editor
> and the server would substitute the correct PG native type.
>
> varchar works, how come double does not?
>
> Thanks,
>
> Tony
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-23 23:38:49 | Re: Did this work in earlier version of Postgres? |
Previous Message | Rod Taylor | 2006-03-23 23:35:58 | Re: Did this work in earlier version of Postgres? |