On Friday, December 30, 2011 9:41:18 am Carlos Mennens wrote: > I'm trying to understand what is the recommended data type for $ in > PostgreSQL. I've done some research and from what I've gathered, there > are a few options: > > 1. decimal > 2. money > > I've read the 'money' data type is non-standard and I should avoid > using this. I see it a bunch of Microsoft SQL Server which I assume > works great but I'm using PostgreSQL and want to make sure I'm ANSI > SQL compliant. I would normally just use 'decimal' however when I'm in > doubt, I use pgAdmin3 as a cheat sheet and upon building a new column, > under 'data type', there is no option for decimal but there is for > money. I'm very confused as I assumed 'money' was a non-standard > option for SQL Server and 'decimal' was the correct value but it's not > an option in the pgAdmin3 GUI. > > Any tips and or advice? My guess is it is listed as numeric which is equivalent to decimal: http://www.postgresql.org/docs/9.1/interactive/datatype-numeric.html -- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
