Mike Mascari wrote:
> Tim McAuley wrote:
>
>>Hi,
>>
>>I have a table which I have populated with over 5000 entries. There is a
>>combined index placed on two of the columns (both bigint). I am trying
>>a simple select (i.e. select id where col1 = 1 and col2 = 1) covering
>>these two columns and it keeps using a seq scan. Is this correct? I
>>would have thought that with this number of entries that an index scan
>>should be used.
>
>
> You must cast the 1 to a bigint:
>
> SELECT id WHERE col1 = 1::bigint AND col1 = 2::bigint
That should read:
SELECT id WHERE col1 = 1::bigint AND col2 = 1::bigint.
My dyslexia is kicking in...
Mike Mascari
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
