[patch] modified columns

[prev] [thread] [next] [Date index for 2004/06/01]

  This message is in MIME format.  The first part should be readable text,
  while the remaining parts are likely unreadable without MIME-aware tools.
  Send mail to mime@xxxxxxxxx.xxx.xxxxxxxxxx.xxx for more info.

--1134876513-1925123241-1086120181=:4169
Content-Type: TEXT/PLAIN; charset=US-ASCII

I submitted this patch (against 0.96, attached), originally against 0.94,
some time ago.  itt wasn't incorporated into a release, but it wasn't flat
out rejected either.  I need this functionality to take advantage of
PostgreSQL functional indexes, for instance:

  SELECT * FROM book WHERE lower(title) LIKE 'symbolic logic'

can use a functional index defined as:

  CREATE INDEX ON book(lower(title))

which performs much better than the ILIKE version of the same query:

  SELECT * FROM book WHERE title ILIKE 'symbolic logic';

Please let me know if this patch is acceptable for 0.97, and if not what
needs to be done to get it merged in.

-Allen
--1134876513-1925123241-1086120181=:4169
Content-Type: TEXT/PLAIN; charset=US-ASCII; name="Class-DBI-0.96-modfied-columns.patch"
Content-Transfer-Encoding: BASE64
Content-ID: <Pine.LNX.4.58.0406011303010.4169@xxxx.xxxxxxxx.xxxx.xxx>
Content-Description: 
Content-Disposition: attachment; filename="Class-DBI-0.96-modfied-columns.patch"

LS0tIERCSS5wbS5vcmlnCTIwMDQtMDYtMDEgMTI6NDI6NTYuMDAwMDAwMDAw
IC0wNzAwDQorKysgREJJLnBtCTIwMDQtMDYtMDEgMTI6NDk6MzEuMDAwMDAw
MDAwIC0wNzAwDQpAQCAtMTA3OCwxMCArMTA3OCwyMSBAQCBzdWIgX2RvX3Nl
YXJjaCB7DQogCW15IChAY29scywgQHZhbHMpOw0KIAlteSAkc2VhcmNoX29w
dHMgPSBAYXJncyAlIDIgPyBwb3AgQGFyZ3MgOiB7fTsNCiAJd2hpbGUgKG15
ICgkY29sLCAkdmFsKSA9IHNwbGljZSBAYXJncywgMCwgMikgew0KKwkJI3Ro
aXMgcmVnZXggYWxsb3dzIHRoZSBmaWVsZCBiZWluZyBzZWFyY2hlZCB0byBi
ZSB0cmFuc2Zvcm1lZCwNCisJCSN3aGljaCBjYW4gYmUgdXNlZnVsIGZvciBj
ZXJ0YWluIGluZGV4ZXMsIGVnLCBpbiBwb3N0Z3JlczoNCisJCSMgIFNFTEVD
VCAqIEZST00gYm9vayBXSEVSRSBsb3dlcih0aXRsZSkgTElLRSAnc3ltYm9s
aWMgbG9naWMnDQorCQkjY2FuIHVzZSBhIGZ1bmN0aW9uYWwgaW5kZXggZGVm
aW5lZCBhczoNCisJCSMgIENSRUFURSBJTkRFWCBPTiBib29rKGxvd2VyKHRp
dGxlKSkNCisJCSN3aGljaCBwZXJmb3JtcyBtdWNoIGJldHRlciB0aGFuIHRo
ZSBJTElLRSB2ZXJzaW9uIG9mIHRoZSBzYW1lIHF1ZXJ5Og0KKwkJIyAgU0VM
RUNUICogRlJPTSBib29rIFdIRVJFIHRpdGxlIElMSUtFICdzeW1ib2xpYyBs
b2dpYyc7DQorDQorCQlteSgkeCwkeSwkeikgPSAkY29sID1+IC9eKC4rXCgp
KC4rKShcKSkkLzsNCisJCSRjb2wgPSAkeSBpZiAkeTsNCisNCiAJCW15ICRj
b2x1bW4gPSAkY2xhc3MtPmZpbmRfY29sdW1uKCRjb2wpDQogCQkJfHwgKExp
c3Q6OlV0aWw6OmZpcnN0IHsgJF8tPmFjY2Vzc29yIGVxICRjb2wgfSAkY2xh
c3MtPmNvbHVtbnMpDQogCQkJfHwgJGNsYXNzLT5fY3JvYWsoIiRjb2wgaXMg
bm90IGEgY29sdW1uIG9mICRjbGFzcyIpOw0KLQkJcHVzaCBAY29scywgJGNv
bHVtbjsNCisJCXB1c2ggQGNvbHMsICR5ID8gIiR4JGNvbCR6IiA6ICRjb2w7
DQogCQlwdXNoIEB2YWxzLCAkY2xhc3MtPl9kZWZsYXRlZF9jb2x1bW4oJGNv
bHVtbiwgJHZhbCk7DQogCX0NCiANCg==

--1134876513-1925123241-1086120181=:4169--