> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
