Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 1BC0F2E30EA for ; Wed, 12 Mar 2008 17:38:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 68762-08 for ; Wed, 12 Mar 2008 17:38:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mail.autorevenue.com (ip-208.178.167.106.gblx.net [208.178.167.106]) by postgresql.org (Postfix) with ESMTP id D5DE42E2FD6 for ; Wed, 12 Mar 2008 17:38:38 -0300 (ADT) Received: (qmail 9505 invoked from network); 12 Mar 2008 16:39:56 -0400 Received: from unknown (HELO dei26g028575) (msteben@10.10.1.20) by mail.autorevenue.com with SMTP; 12 Mar 2008 16:39:56 -0400 From: "Mark Steben" To: Subject: Are piped columns indexable Date: Wed, 12 Mar 2008 16:38:14 -0400 Message-ID: <013201c88480$fe93f990$14010a0a@dei26g028575> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0133_01C8845F.77825990" X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2992 Thread-Index: AciEgP6DSlP4bd3RSH+Wqh/qBZmdOA== X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/262 X-Sequence-Number: 29216 This is a multi-part message in MIME format. ------=_NextPart_000_0133_01C8845F.77825990 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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 gotten sequential scans Thanks for your time Mark Steben Senior Database Administrator @utoRevenueT A Dominion Enterprises Company 480 Pleasant Street Suite B200 Lee, MA 01238 413-243-4800 Home Office 413-243-4809 Corporate Fax msteben @autorevenue.com Visit our new website at www.autorevenue.com IMPORTANT: The information contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is prohibited. If you have received this e-mail message in error, please reply to the sender that you have received this e-mail message in error and then delete it. Thank you. ------=_NextPart_000_0133_01C8845F.77825990 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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 =3D = ‘124cab’  (or whatever)

    Assume a and b are defined as = char(3)

 

I have tried various op classes and so far have just gotten = sequential scans

 

Thanks for your time

 

 

Mark Steben

Senior Database Administrator
@utoRevenue™
A Dominion = Enterprises Company
480 = Pleasant Street
Suite = B200
Lee, MA 01238
413-243-4800 Home Office 
413-243-4809 Corporate Fax

msteben@autorevenue.com

Visit our = new website at
www.autorevenue.com

 

IMPORTANT: The information = contained in this e-mail message is confidential and is intended only for the named addressee(s). If the reader of this e-mail message is not the intended recipient (or the individual responsible for the delivery of this e-mail message to the intended recipient), please be advised that any re-use, dissemination, distribution or copying of this e-mail message is = prohibited.  If you have received this e-mail message in error, please reply to = the sender that you have received this e-mail message in error and then = delete it.  Thank you.

 

------=_NextPart_000_0133_01C8845F.77825990--