Re: Did this work in earlier version of Postgres?

Which is actually a float8 :)

CREATE TABLE public.test
(
junk double precision,
);

alter table public.test add column foo float8;
        Table "public.test"Column |       Type       |
--------+------------------+--junk   | double precision |punk | double precision |


Regards,
Guido Barosio


On 3/23/06, Peter Eisentraut <peter_e@gmx.net> wrote:
> 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;
>
> There has never been a type named double in PostgreSQL.  The type name
> mandated by the SQL standard is double precision, and PostgreSQL
> supports that.
>
> --
> Peter Eisentraut
> http://developer.postgresql.org/~petere/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo@postgresql.org so that your
>        message can get through to the mailing list cleanly
>


--
Guido Barosio
-----------------------