Tony Caduto <tony_caduto@amsoftwaredesign.com> writes:
> 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.
[ tries it... ] Sorry, fails in everything back to 7.0, which is the
oldest branch I have running. The error message varies a bit.
> varchar works, how come double does not?
The SQL spec has varchar, it does not have double.
<character string type> ::= CHARACTER [ <left paren> <length> <right paren> ] | CHAR
[<left paren> <length> <right paren> ] | CHARACTER VARYING <left paren> <length> <right paren>
|CHAR VARYING <left paren> <length> <right paren> | VARCHAR <left paren> <length> <right paren>
<approximate numeric type> ::= FLOAT [ <left paren> <precision> <right paren> ] |
REAL | DOUBLE PRECISION
regards, tom lane