Re: [BUGS] Bugs in bigint indexes

Title: Message Try this    explain SELECT id FROM it_test WHERE id='123'; QUERY PLAN Index Scan using it_test_pkey on it_test  (cost=0.00..4.82 rows=1 width=8)   Index Cond: (id = 123

Re: [BUGS] Bugs in bigint indexes

Nishad Prakash <[EMAIL PROTECTED]> writes: > Why doesn't the query planner notice that an int-type index is present > and perform the cast on its own? Perhaps one of the developers > can explain? I think users would like this property if it could be > implemented without breaking anything. It's

Re: [BUGS] Bugs in bigint indexes

On Wed, 17 Dec 2003, Gustavo Scotti wrote: > > _ > > > Dear developers, > > I almost got nuts those two days I'm stuck with this issue... > Let's get straight to the point. I'm using a small portion of my actual > table, but this is enough.

Re: [BUGS] Bugs in bigint indexes

Gustavo Scotti writes: > when the key is bigint, it ignores any kind of index scan, it always use > Seq scan. Why? RTFM: http://www.postgresql.org/docs/7.4/static/datatype.html#DATATYPE-INT Please don't post to pgsql-bugs unless you have found a bug. ---(end of broadcast