Re: create index on function - why?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Huselid" <dhuselid(at)pepperdash(dot)com>
Cc: wweng(at)kencast(dot)com, pgsql-sql(at)postgresql(dot)org
Subject: Re: create index on function - why?
Date: 2002-02-15 18:15:14
Message-ID: 15109.1013796914@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"David Huselid" <dhuselid(at)pepperdash(dot)com> writes:
> PostgreSQL 7.0.2

You need to update ...

> But I am getting the following error:
> ERROR: DefineIndex: function 'upper(varchar)' does not exist

7.0.* is quite picky about index functions; there has to be an exact
match in pg_proc, not just a binary-compatible match. You could work
around this by creating a pg_proc entry for upper(varchar) that matches
the one for upper(text) ... but I'd suggest updating instead.

regards, tom lane

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Benoit Menendez 2002-02-15 18:39:21 Problem with self-join updates...
Previous Message David Huselid 2002-02-15 18:01:15 Re: create index on function - why?