On Tue, 20 Apr 2004, Han Holl wrote:
> palga=> create index nm_idx on main (rubriek(rapport, lseek, 'naamvrouw',0));
> ERROR: parser: parse error at or near "'naamvrouw'" at character 54
> palga=>
>
> This is postgresql-7.3.4-3.rhl9.
>
You cannot create functional indexes with a constant in t
On Tue, 20 Apr 2004, Han Holl wrote:
> Hi,
>
> Can anyone explain to me what I'm doing wrong:
> (The first select is to show that the function rubriek exists, and does work).
> I want to create an index on a computed column:
>
> palga=> select rubriek(rapport, lseek, 'naamvrouw',0) from main
>
On Tue, Apr 20, 2004 at 12:48:42PM -0700, Han Holl wrote:
> Can anyone explain to me what I'm doing wrong:
> (The first select is to show that the function rubriek exists, and does work).
> I want to create an index on a computed column:
Functional indexes could not have constants in 7.3; you can
