Re: Did this work in earlier version of Postgres?

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
>