Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 67612475D49 for ; Sat, 29 Jun 2002 00:23:43 -0400 (EDT) Mailbox-Line: From chriskl@familyhealth.com.au Sat Jun 29 00:23:43 2002 Received: from mail.iinet.net.au (symphony-04.iinet.net.au [203.59.3.36]) by postgresql.org (Postfix) with SMTP id 20461475BDF for ; Sat, 29 Jun 2002 00:23:42 -0400 (EDT) Received: (qmail 31092 invoked by uid 666); 29 Jun 2002 04:19:34 -0000 Received: from unknown (HELO SOL) (203.59.103.160) by iinet.net.au with SMTP; 29 Jun 2002 04:19:34 -0000 Message-ID: <00f001c21f24$35e74d70$0200a8c0@SOL> From: "Christopher Kings-Lynne" To: "Chantal Ackermann" , References: <3D1C44DD.9040400@biomax.de> Subject: Re: creating functional index over multiple columns Date: Sat, 29 Jun 2002 12:19:49 +0800 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300 X-Spam-Status: No, hits=2.1 required=5.0 tests=DOUBLE_CAPSWORD,RCVD_IN_MULTIHOP_DSBL, X_RCVD_IN_UNCONFIRMED_DSBL,FUDGE_MULTIHOP_RELAY version=2.30 X-Spam-Level: ** X-Archive-Number: 200206/410 X-Sequence-Number: 8375 CREATE INDEX my_idx ON my_table(lower(name), type_id, syn_id); ??? Chris ----- Original Message ----- From: "Chantal Ackermann" To: 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 > >