pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedAre piped columns indexable
2+ messages / 2 participants
[nested] [flat]
* Are piped columns indexable
@ 2008-03-12 20:38 Mark Steben <msteben@autorevenue.com>
2008-03-12 20:55 ` Re: Are piped columns indexable Merlin Moncure <mmoncure@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mark Steben @ 2008-03-12 20:38 UTC (permalink / raw)
To: pgsql-performance
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 <blocked::mailto:name@autorevenue.com> @autorevenue.com
Visit our new website at
<blocked::http://www.autorevenue.com/; 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Are piped columns indexable
2008-03-12 20:38 Are piped columns indexable Mark Steben <msteben@autorevenue.com>
@ 2008-03-12 20:55 ` Merlin Moncure <mmoncure@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Merlin Moncure @ 2008-03-12 20:55 UTC (permalink / raw)
To: Mark Steben <msteben@autorevenue.com>; +Cc: pgsql-performance
On Wed, Mar 12, 2008 at 4:38 PM, Mark Steben <msteben@autorevenue.com> 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 various op classes and so far have just gotten sequential scans
create index t_idx on t((a || b));
:-)
merlin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-03-12 20:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-03-12 20:38 Are piped columns indexable Mark Steben <msteben@autorevenue.com>
2008-03-12 20:55 ` Merlin Moncure <mmoncure@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox