From: Chantal Ackermann <chantal.ackermann@biomax.de>
To: pgsql-sql@postgresql.org
Subject: creating functional index over multiple columns
Date: Fri, 28 Jun 2002 13:13:33 +0200
Message-ID: <3D1C44DD.9040400@biomax.de> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: chantal.ackermann@biomax.de
Subject: Re: creating functional index over multiple columns
In-Reply-To: <3D1C44DD.9040400@biomax.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox