Re: [HACKERS] Is indexing broken for bigint columns?

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dann Corbit Sent: Tuesday, February 24, 2004 4:21 PM To: Peter Eisentraut; PostgreSQL-development Subject: Re: [HACKERS] Is indexing broken for bigint columns? -Original Message- From

Re: [HACKERS] Is indexing broken for bigint columns?

-Original Message- From: Nigel J. Andrews [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:33 PM To: Dann Corbit Cc: PostgreSQL-development Subject: Re: [HACKERS] Is indexing broken for bigint columns? Dann, Did you mean to forward this to -hackers? Yes

[HACKERS] Is indexing broken for bigint columns?

Title: Message http://www.phpbuilder.com/columns/smith20010821.php3?page=3

Re: [HACKERS] Is indexing broken for bigint columns?

Dann Corbit wrote: http://www.phpbuilder.com/columns/smith20010821.php3?page=3 bigint indexes work fine. The queries probably referenced 32-bit integer constants that were neither quoted nor CAST. I always start bigint sequences at 5 billion. This ensures that client applications aren't

Re: [HACKERS] Is indexing broken for bigint columns?

-Original Message- From: Mike Mascari [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:27 PM To: Dann Corbit Cc: PostgreSQL-development Subject: Re: [HACKERS] Is indexing broken for bigint columns? Dann Corbit wrote: http://www.phpbuilder.com/columns/smith20010821

Re: [HACKERS] Is indexing broken for bigint columns?

Dann Corbit wrote: http://www.phpbuilder.com/columns/smith20010821.php3?page=3 http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-INT ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Is indexing broken for bigint columns?

-Original Message- From: Peter Eisentraut [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 3:38 PM To: Dann Corbit; PostgreSQL-development Subject: Re: [HACKERS] Is indexing broken for bigint columns? Dann Corbit wrote: http://www.phpbuilder.com/columns/smith20010821

Re: [HACKERS] Is indexing broken for bigint columns?

Dann Corbit wrote: PostgreSQL is the only database that requires casts to do an index lookup. Possibly (quite probably) true, but you don't show any evidence that SQL*Server, Oracle, or MySQL uses indexes either. Like I said before, Tom (of course) already has a fix is already in the

Re: [HACKERS] Is indexing broken for bigint columns?

Dann Corbit wrote: Dann Corbit wrote: http://www.phpbuilder.com/columns/smith20010821.php3?page=3 http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-INT PostgreSQL is the only database that requires casts to do an index lookup. This issue has been discussed on these