Re: Math Huh?
От
Larry Rosenman
Тема
Re: Math Huh?
Дата
Msg-id
1022805419.356.0.camel@lerlaptop
Ответ на
Re: Math Huh? (Josh Berkus)
Список
Дерево обсуждения
Math Huh? Josh Berkus <josh@agliodbs.com>
Re: Math Huh? Larry Rosenman <ler@lerctr.org>
Re: Math Huh? David Stanaway <david@stanaway.net>
Re: Math Huh? Tom Lane <tgl@sss.pgh.pa.us>
Re: Math Huh? Josh Berkus <josh@agliodbs.com>
Re: Math Huh? Larry Rosenman <ler@lerctr.org>
Re: Math Huh? Achilleus Mantzios <achill@matrix.gatewaynet.com>
On Thu, 2002-05-30 at 18:59, Josh Berkus wrote: > > Tom, > > > (yawn) int4 overflow. Use float or numeric if you want overflow > > robustness... > > Shouldn't it give me an error? This does: > > SELECT (255^4)::INT4 Why? You're doing 3 multiplications, instead of one power. It has no idea what the number is. > > > -- > -Josh Berkus > > ______AGLIO DATABASE SOLUTIONS___________________________ > Josh Berkus > Complete information technology josh@agliodbs.com > and data management solutions (415) 565-7293 > for law firms, small businesses fax 621-2533 > and non-profit organizations. San Francisco > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: ler@lerctr.org US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749
В списке pgsql-sql по дате отправления
