indexing tables using my owns functions

From: "Pau Marc Munoz Torres" <paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat>
To: "PgSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: indexing tables using my owns functions
Date: 2007-11-26 15:54:10
Message-ID: 19b5841a0711260754m197bbbackc8915d078e6ae23c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi every body

Recently i wrote my own function into postgesql... and it works perfecly!!,
now i would like use it to index a table like this guy do at the link (
http://www.faqs.org/docs/ppbook/r24254.htm)

but i get the following error

mhc2db=> create index h2iab on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));
ERROR: functions in index expression must be marked IMMUTABLE
mhc2db=>

in this indexation p1,p4,p6,p7,p9 are variables that depends on the field.

could anyone help me?

--
Pau Marc Muñoz Torres

Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)

telèfon: 93 5812807
Email : paumarc(dot)munoz(at)bioinf(dot)uab(dot)cat

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2007-11-26 16:01:44 Re: Migrating from 32 to 64 bit
Previous Message Vivek Khera 2007-11-26 15:25:06 Re: Migrating from 32 to 64 bit