Functional index definition

From: Josué Maldonado <josue(at)lamundial(dot)hn>
To: pgsql-general(at)postgresql(dot)org
Subject: Functional index definition
Date: 2003-11-11 15:27:46
Message-ID: 3FB0FFF2.2@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

Is there a way to create indexes using functions like these:
substring(prod_no,8,4)
to_char(fkardex,'YYYYMM')
substr(facnum,1,2)

Help says is not possible but I would like to know if someone know an
undocumented/tricky way to get that done.

Thanks in advance

--
Josué Maldonado.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dennis Gearon 2003-11-11 15:32:16 Re: multibyte support
Previous Message ryan p bobko 2003-11-11 15:12:50 PGexec dumps core at pqResultAlloc