Received: from smtp122.fibertel.com.ar (smtp122.fibertel.com.ar [24.232.0.122] (may be forged)) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0OLZsq75928 for ; Wed, 24 Jan 2001 16:35:54 -0500 (EST) (envelope-from rb@desinet-sa.com) Received: from server.rbsoft (24.232.56.2) by smtp122.fibertel.com.ar (5.1.046) id 3A4BA35C00576DD9 for pgsql-novice@postgresql.org; Wed, 24 Jan 2001 18:34:31 -0300 From: Roberto Bertolusso Date: Wed, 24 Jan 2001 18:29:34 -0300 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: pgsql-novice@postgresql.org Subject: Cannot CREATE INDEX that contains a function MIME-Version: 1.0 Message-Id: <01012418293404.01344@server.rbsoft> Content-Transfer-Encoding: 8bit X-Archive-Number: 200101/274 X-Sequence-Number: 741 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