Gabriel Fernandez <[EMAIL PROTECTED]> writes:
> Is it possible to create an index using a function(field) sintaxis ?
Yes, but *only* on a function of one or more raw fields.
> CREATE INDEX "i1_cdu" on "cdu" using btree ( substr(cdu_code,1,1)
> "varchar_ops" );
This doesn't work because you hav
Hi,
Is it possible to create an index using a function(field) sintaxis ?
For instance:
CREATE INDEX "i1_cdu" on "cdu" using btree ( substr(cdu_code,1,1)
"varchar_ops" );
If not, should I alter the table to include a field with the value
'substr(codigo,1,1)'.
Thanks
Gabi :-)
--
