Skip site navigation (1) Skip section navigation (2)

functional index arg matching patch

From: Mark Hollomon <mhh(at)mindspring(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-patches(at)postgresql(dot)org
Subject: functional index arg matching patch
Date: 2000-08-21 15:47:54
Message-ID: 20000821114754.A13168@mindspring.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Attached is a patch to allow
functinal indecies to use functions that
are for 'binary-compatible' types.

eg

create function foobar(text) returns text as ....

create table vc ( a varchar );

create index on vc ( foobar(a) );

should now work.

-- 
Mark Hollomon
mhh(at)mindspring(dot)com

Responses

pgsql-hackers by date

Next:From: Tiago AntãoDate: 2000-08-21 15:48:08
Subject: Re: Optimisation deficiency: currval('seq')-->seq scan, constant-->index scan
Previous:From: Hannu KrosingDate: 2000-08-21 15:40:05
Subject: Re: Row Level Locking Problem

pgsql-patches by date

Next:From: Mark HollomonDate: 2000-08-21 15:59:42
Subject: Re: functional index arg matching patch
Previous:From: Tom LaneDate: 2000-08-21 15:19:31
Subject: Re: [HACKERS] functional index arg matching patch

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group