Cannot CREATE INDEX that contains a function - Mailing list pgsql-sql

From Roberto Bertolusso
Subject Cannot CREATE INDEX that contains a function
Date
Msg-id 01012418293404.01344@server.rbsoft
Whole thread Raw
Responses Re: Cannot CREATE INDEX that contains a function  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-sql by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: "'" in SQL INSERT statement
Next
From: Jan Wieck
Date:
Subject: Re: Rule not invoked in 7.1