Re: the integer type

> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Tony Caduto
> Sent: 13 April 2006 16:19
> To: chris smith
> Cc: Zahir Lalani; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] the integer type
>
> It's not a error, pgAdmin III simply does not display the
> word integer in it's drop down comboboxes, it uses all the
> internal representation of types not the SQL standard aliases.

Which allows you to use any custom datatype or domain that you like.

> PG Lightning Admin on the other hand does use the SQL
> standard names in the comboboxes which make things a little
> easier for those coming from other databases and that's why
> PG Lightning Admin is the best choice for all users running a
> win32 desktop or coming from another database system such as
> MS SQL server.  Just because it's free (pgAdminIII) does not
> mean it should be your only or best choice.
>
> pgAdmin III also won't accept double precision in it's type
> selection combobox.

double precision == float8
(http://www.postgresql.org/docs/8.1/interactive/datatype.html) which
works just fine.

Regards, Dave.