| From: | "Andrus" <kobruleht2(at)hot(dot)ee> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: OR or IN ? |
| Date: | 2008-10-17 17:00:20 |
| Message-ID: | 6F0EBD72DC61423EB7ACDE711A2E1DE0@andrusnotebook |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>> 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.
I'm sorry. It seems that Richard Huxton suggestion in this mailing list
SELECT * FROM generate_series(1,10) s
WHERE s = ANY (string_to_array('1,3,5,7', ',')::int[]);
works in 8.0
I hope that this works as well as new array syntax.
Andrus.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-10-17 17:11:16 | Re: VACUUM PANIC: corrupted item pointer |
| Previous Message | Scott Marlowe | 2008-10-17 16:54:52 | Re: Drop database / database in use question |