> 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.
Right syntax is
CREATE INDEX test_idx ON test (lower(name) text_ops);
I try it and index was generated without error
Rem
-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems@gdansk.sprint.pl * *
-----------------------------------------------------------------*****----------
