From: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
To: Chantal Ackermann <chantal.ackermann@biomax.de>
To: pgsql-sql@postgresql.org
Subject: Re: creating functional index over multiple columns
Date: Sat, 29 Jun 2002 12:19:49 +0800
Message-ID: <00f001c21f24$35e74d70$0200a8c0@SOL> (raw)
References: <3D1C44DD.9040400@biomax.de>
CREATE INDEX my_idx ON my_table(lower(name), type_id, syn_id); ???
Chris
----- Original Message -----
From: "Chantal Ackermann" <chantal.ackermann@biomax.de>
To: <pgsql-sql@postgresql.org>
Sent: Friday, June 28, 2002 7:13 PM
Subject: [SQL] creating functional index over multiple columns
> 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
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>
>
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: chriskl@familyhealth.com.au, chantal.ackermann@biomax.de
Subject: Re: creating functional index over multiple columns
In-Reply-To: <00f001c21f24$35e74d70$0200a8c0@SOL>
* 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