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(at)gmx(dot)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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

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