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

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 (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-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

pgsql-novice by date

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

pgsql-sql by date

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

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