My issue is I am also not a DB guy, but a software guy.
So while I appreciate the idea of a 40 bit field, that I would use as a mask
to test against the query (an AND would do very nicely). I wonder if this
would work well in a DB with 20M+ records in the table.
The other fields (type, producer, etc.) are indexed as a B-Tree, but if one
indexed this field, it is not clear to me if the DB planner would do an
effective search. (that is what I do not know).
View this message in context: http://postgresql.1045698.n5.nabble.com/WHERE-clause-with-40-conditions-tp5686659p5691174.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
In response to
pgsql-novice by date
|Next:||From: Daniel Staal||Date: 2012-05-07 15:06:11|
|Subject: Re: WHERE clause with 40+ conditions|
|Previous:||From: Merlin Moncure||Date: 2012-05-07 14:11:23|
|Subject: Re: execute stored function from ms visual foxpro|