On Fri, Jan 30, 2004 at 10:55:13 -0800, Chris Gamache <[EMAIL PROTECTED]> wrote: > Well, after living with the (depreciated) Money datatype for 5 years, I think > its finally time to say goodbye (and now that we have DROP COLUMN it'll be MUCH > easier transition). What's the preferred monetary datatype? numeric(10,2)? > float4? float8? We're dealing only with US Dollars.
You probably just want plain numeric. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend