Re: Did this work in earlier version of Postgres?

["Joshua D. Drake" <jd(at)commandprompt(dot)com>]

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