creating functional index over multiple columns

From: Chantal Ackermann <chantal(dot)ackermann(at)biomax(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: creating functional index over multiple columns
Date: 2002-06-28 11:13:33
Message-ID: 3D1C44DD.9040400@biomax.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

hello all,

I am new to this list, and I hope my request is well placed, here. I
tried searching the archives but I wasn't lucky.

I want to create an index over two columns and one function:

the WHERE clause is:
WHERE lower(name)=? AND type_id=? AND syn_id=?

I know from the docs that I have to create on function that wraps these
three values for creating the appropriate index. I have practically no
idea how to do this (e.g. what type/set should this function return?).

Thanks a lot for pointers to documentation/former postings or any help
Cheers
Chantal

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chantal Ackermann 2002-06-28 11:22:02 Re: creating functional index over multiple columns
Previous Message Karel Zak 2002-06-28 07:59:37 Re: to_char() and order-by