index on aggregate function

From: Sascha Schumann <sas(at)schell(dot)de>
To: pgsql-sql(at)hub(dot)org
Subject: index on aggregate function
Date: 1999-01-30 15:20:17
Message-ID: 19990130162017.A3151@schell.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I somewhere read that it is possible to create an index on aggregate functions
in PostgreSQL. Which syntax do I have to use for it?

test=> CREATE TABLE test ( name VARCHAR(32) );
CREATE
test=> CREATE INDEX test_idx ON test lower(name);
ERROR: parser: parse error at or near "lower"

gives me a parser error.

--

Regards,

Sascha Schumann |
Consultant | finger sas(at)schell(dot)de
| for PGP public key

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bill Brandt 1999-01-30 17:00:54 Error msg
Previous Message Juan Pablo Marichal Catalan 1999-01-29 23:06:48 Re: [SQL] Equivalent for an Access query