Re: numeric data type?
От | Zlatko Matić |
---|---|
Тема | Re: numeric data type? |
Дата | |
Msg-id | 001801c62022$1551d820$52bffea9@zlatkovyfkpgz6 обсуждение исходный текст |
Ответ на | numeric data type? (Zlatko Matić <zlatko.matic1@sb.t-com.hr>) |
Список | pgsql-general |
OK. Thanks for clarification. ----- Original Message ----- From: "Doug McNaught" <doug@mcnaught.org> To: "Zlatko Matić" <zlatko.matic1@sb.t-com.hr> Cc: <pgsql-general@postgresql.org>; "Tony Caduto" <tony.caduto@amsoftwaredesign.com> Sent: Sunday, January 22, 2006 2:39 PM Subject: Re: [GENERAL] numeric data type? Zlatko Matić <zlatko.matic1@sb.t-com.hr> writes: > So, it seems that numeric without parameters (precision, scale) behave > similar to float, but is much exact. Am I right or I missunderstood? Right. It's also considerably slower, since floating point calculations can use the hardware. Unless you're doing a huge number of computations this may not be an issue. -Doug ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
В списке pgsql-general по дате отправления: