On Tuesday 11 Nov 2003 2:00 pm, Stephan Szabo wrote:
> On Tue, 11 Nov 2003, Rajesh Kumar Mallah wrote:
> > Hmmm... am i doing anything really silly?
>
> Functional indexes on 7.3 and earlier only allow a function over one or
> more columns (which would disallow the below as a function over a functi
On Tue, 11 Nov 2003, Rajesh Kumar Mallah wrote:
> Hmmm... am i doing anything really silly?
Functional indexes on 7.3 and earlier only allow a function over one or
more columns (which would disallow the below as a function over a function
over a column). The usual workaround would be to make an
Hmmm... am i doing anything really silly?
tradein_clients=# CREATE INDEX profile_master2 on profile_master (lower( btrim(email)
) );
ERROR: parser: parse error at or near "(" at character 61
tradein_clients=#
Regds
mallah.
---(end of broadcast)---
