Re: [BUGS] BUG #1470: Boolean expression index not used when it could be

2005-02-27 Thread Sergey Koshcheyev
Tom Lane wrote: "Sergey Koshcheyev" <[EMAIL PROTECTED]> writes: I'm trying to optimize "is null" queries, since PgSQL doesn't index null values. I have found that creating an expression index on (column is null) could work, but it doesn't get used

[BUGS] BUG #1510: Indexes on boolean fields

2005-02-27 Thread Sergey Koshcheyev
The following bug has been logged online: Bug reference: 1510 Logged by: Sergey Koshcheyev Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: Debian Linux Description:Indexes on boolean fields Details: Hi, this is an addition to my bug

[BUGS] BUG #1470: Boolean expression index not used when it could be

2005-02-09 Thread Sergey Koshcheyev
The following bug has been logged online: Bug reference: 1470 Logged by: Sergey Koshcheyev Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Linux (Debian) Description:Boolean expression index not used when it could be Details: I'm t

[BUGS] BUG #1471: Corrected e-mail address - bug 1470

2005-02-09 Thread Sergey Koshcheyev
The following bug has been logged online: Bug reference: 1471 Logged by: Sergey Koshcheyev Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.6 Operating system: Linux (Debian) Description:Corrected e-mail address - bug 1470 Details: Sorry for this dummy