Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] int8 and index - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] int8 and index
Date
Msg-id 6047.938185683@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] int8 and index  (Tatsuo Ishii <t-ishii@sra.co.jp>)
Responses Re: [HACKERS] int8 and index
List pgsql-hackers
Tree view 
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> How about   select .. from .. where .. = ..::int8;  ?
>> 
>> Without ::int8 PostgreSQL doesn't use int8 indexes.

> Oops. I forgot about that! Thanks.

Yes, this is on the TODO list (although I think TODO just mentions
the equivalent problem for int2).
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Re: [GENERAL] Update of bitmask type
Next
From: Daniel Péder
Date:
Subject: postgres startup script modification (Linux RedHat)