Re: [HACKERS] Interesting behaviour ! - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Interesting behaviour !
Date
Msg-id 199907142007.QAA00451@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Interesting behaviour !  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Constantin Teodorescu <teo@flex.ro> writes:
> > Bruce Momjian wrote:
> >> I thought we had this fixed in 6.5.  Is that what you are using?
> 
> > Yes!
> 
> It's not fixed, obviously.  We talked about the issue a while back,
> but it isn't 100% clear what the most reasonable fix is.  Just making
> the parser label small constants as int2 rather than int4 is no
> answer; that'll only move the problem over to int4 tables :-(.

Added to TODO:
* Allow SELECT * FROM tab WHERE int2col = 4 use int2col index 

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Re: Arrays versus 'type constant' syntax
Next
From: Evan Klinger
Date:
Subject: SELECT using arrays