Skip site navigation (1) Skip section navigation (2)

Re: BIG files

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Bruno Wolff III <bruno(at)wolff(dot)to>, rabt(at)dim(dot)uchile(dot)cl,pgsql-novice(at)postgresql(dot)org
Subject: Re: BIG files
Date: 2005-06-19 16:33:01
Message-ID: 20050619092922.L16897@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Sun, 19 Jun 2005, Michael Fuhr wrote:

> PostgreSQL 8.0.3:
>
>           n1          |          n2          |       ?column?
> ----------------------+----------------------+----------------------
>  10000000000000000000 | 10000000000000000001 | 20000000000000000001
>
> MySQL 4.1.12:
>
> +----------------------+----------------------+-----------------------+
> | n1                   | n2                   | n1 + n2               |
> +----------------------+----------------------+-----------------------+
> | -8446744073709551616 | -8446744073709551615 | -16893488147419099136 |
> +----------------------+----------------------+-----------------------+
>
> Beauty.  Nice of MySQL not to raise an error if I've exceeded some
> implementation-defined limit.

To be fair, we didn't raise proper errors for integer math until fairly
recently (as recently as 7.4, we had overflow issues on operators where
the arguments were in range but the result was not).

In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2005-06-19 18:20:50
Subject: Re: BIG files
Previous:From: Michael FuhrDate: 2005-06-19 14:17:42
Subject: Re: BIG files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group