Re: [SQL] index on aggregate function

> --lower() works with varchar...
>
> prova=> CREATE TABLE test ( name VARCHAR(32) );
> CREATE
> prova=> insert into test values ('AAAA');
> INSERT 188475 1
> prova=> select lower(name) from test;
> lower
> -----
> aaaa
> (1 row)
>
> but it doesn't work on create index...
>
> prova=> drop table test;
> DROP
> prova=> CREATE TABLE test ( name VARCHAR(32) );
> CREATE
> prova=> CREATE INDEX test_idx ON test lower(nome);
> ERROR: parser: parse error at or near "lower"

Yes, You're right - I check it now - strange thing - and I have nothing
more to say
Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------