From: | Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl> |
---|---|
To: | "jose' soares" <sferac(at)bo(dot)nettuno(dot)it> |
Cc: | Sascha Schumann <sas(at)schell(dot)de>, pgsql-sql(at)hub(dot)org |
Subject: | Re: [SQL] index on aggregate function |
Date: | 1999-02-15 13:50:00 |
Message-ID: | Pine.GS4.4.02A.9902151448560.25743-100000@netra.gdansk.sprint.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
> --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 * *
-----------------------------------------------------------------*****----------
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Subert | 1999-02-15 20:35:09 | [SQL] difficulties combining nextval and rules |
Previous Message | jose' soares | 1999-02-15 12:07:59 | Re: [SQL] index on aggregate function |