Re: [PERFORM] Are piped columns indexable

2008-03-12 Thread Merlin Moncure
On Wed, Mar 12, 2008 at 4:38 PM, Mark Steben <[EMAIL PROTECTED]> wrote: > Given table t with columns a, b, c, d > > And index on t using btree (a,b) > >Is this indexable: > > Select * from t where a || b = '124cab' (or whatever) > > Assume a and b are defined as char(3) > I have tried

[PERFORM] Are piped columns indexable

2008-03-12 Thread Mark Steben
Hi all, Just upgraded to 8.2.5. Given table t with columns a, b, c, d And index on t using btree (a,b) Is this indexable: Select * from t where a || b = '124cab' (or whatever) Assume a and b are defined as char(3) I have tried various op classes and so far have just gotte