Cannot CREATE INDEX that contains a function

From: Roberto Bertolusso <rb(at)desinet-sa(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Cannot CREATE INDEX that contains a function
Date: 2001-01-24 21:29:34
Message-ID: 01012418293404.01344@server.rbsoft
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

I am testing Postgresql-7.0.3

Please tell me what I am doing bad.

In psql...
testdb=# CREATE TABLE test (username varchar(50));
CREATE
testdb=# CREATE UNIQUE INDEX test_index ON test (lower(username));
ERROR: DefineIndex: function 'lower(varchar)' does not exist

The same happens using upper, initcap,...
Roberto Bertolusso

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Francisco Reyes 2001-01-25 03:33:17 Re: When replication?
Previous Message Tom Lane 2001-01-24 16:39:34 Re: "drop function" vs. "delete from pg_proc"

Browse pgsql-sql by date

  From Date Subject
Next Message clayton cottingham 2001-01-24 22:01:30 Veering OT opinions please XQL versus XML-QL
Previous Message Forest Wilkinson 2001-01-24 21:09:08 Re: unreferenced primary keys: garbage collection