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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches
Attached is a patch to allow
functinal indecies to use functions that
are for 'binary-compatible' types.


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

create table vc ( a varchar );

create index on vc ( foobar(a) );

should now work.

Mark Hollomon


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-2017 The PostgreSQL Global Development Group