Re: precision and scale functions for numeric
От
Robert Haas
Тема
Re: precision and scale functions for numeric
Дата
Msg-id
CA+TgmoaW8ZZh1CTawE_wVfMeo5ebhCLeCBQ=LTLo_uSSTiamcA@mail.gmail.com
Ответ на
Re: precision and scale functions for numeric (David Johnston)
Список
Дерево обсуждения
precision and scale functions for numeric Peter Eisentraut <peter_e@gmx.net>
Re: precision and scale functions for numeric Robert Haas <robertmhaas@gmail.com>
Re: precision and scale functions for numeric "David Johnston" <polobo@yahoo.com>
Re: precision and scale functions for numeric "Kevin Grittner" <Kevin.Grittner@wicourts.gov>
Re: precision and scale functions for numeric Robert Haas <robertmhaas@gmail.com>
On Mon, Apr 30, 2012 at 3:33 PM, David Johnston wrote: >> -----Original Message----- >> From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers- >> owner@postgresql.org] On Behalf Of Robert Haas >> Sent: Monday, April 30, 2012 2:20 PM >> To: Peter Eisentraut >> Cc: pgsql-hackers >> Subject: Re: [HACKERS] precision and scale functions for numeric >> >> >> I think you could test for integer-ness by testing whether val % 0 = 0. >> > > Either I am missing something here or you are. Since Modulus is a division > function anything "% 0" results in a division-by-zero ERROR - division has > to occur before a remainder can be obtained. > > Maybe "val % 2 NOT IN (0,1)" ... Oops. I meant (val % 1) = 0, not (val % 0) = 0. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления
