Postgres Pro
Downloads
Home   >   mailing lists

Re: OR or IN ? - Mailing list pgsql-general

From Tom Lane
Subject Re: OR or IN ?
Date
Msg-id 19328.1224261459@sss.pgh.pa.us
Whole thread Raw
In response to Re: OR or IN ?  ("Andrus" <kobruleht2@hot.ee>)
Responses Re: OR or IN ?  ("Andrus" <kobruleht2@hot.ee>)
List pgsql-general
Tree view 
"Andrus" <kobruleht2@hot.ee> writes:
> No.  I need to support 8.0.
> After those crashes I changed all IN clauses to
> docid = ANY ({1,2,3,4,5,7,8,96,5445,.., 34534534})

I'm afraid that hardly counts as "supporting" 8.0 (or 8.1 for that
matter).  The syntax may work but it can't be indexed.

            regards, tom lane

pgsql-general by date:

Previous
From: Ben
Date:
Subject: deferred triggers?
Next
From: André Volpato
Date:
Subject: Re: VACUUM PANIC: corrupted item pointer