Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id F14EF476921 for ; Fri, 28 Jun 2002 07:17:32 -0400 (EDT) Mailbox-Line: From chantal.ackermann@web.de Fri Jun 28 07:17:32 2002 Received: from smtp.web.de (smtp01.web.de [194.45.170.210]) by postgresql.org (Postfix) with ESMTP id 4EC2F475F94 for ; Fri, 28 Jun 2002 07:17:32 -0400 (EDT) Received: from kostyaleucin.biomax.de ([212.6.137.236] helo=web.de) by smtp.web.de with asmtp (WEB.DE(Exim) 4.70 #5) id 17Ntks-0006b3-00 for pgsql-sql@postgresql.org; Fri, 28 Jun 2002 13:17:34 +0200 Message-ID: <3D1C46DA.7020808@web.de> Date: Fri, 28 Jun 2002 13:22:02 +0200 From: Chantal Ackermann User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.0) Gecko/20020529 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Re: creating functional index over multiple columns Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=0.0 required=5.0 tests=none version=2.30 X-Spam-Level: X-Archive-Number: 200206/386 X-Sequence-Number: 8351 hello once more, sorry, I just found Josh Berkus posting (Re: unique index on function and column). I thought (while reading the documentation) it would be better to have multicolumn indeces with "multicolumn" constraints. Obviously it makes no difference. Chantal