Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1EE9Sx35470 for ; Wed, 14 Feb 2001 09:09:28 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from news.tht.net (news.hub.org [216.126.91.242]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1ECV5x23722 for ; Wed, 14 Feb 2001 07:31:05 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.1/8.11.1) id f1ECP3d24550 for pgsql-sql@postgresql.org; Wed, 14 Feb 2001 07:25:03 -0500 (EST) (envelope-from news) From: =?iso-8859-1?Q?Jaros=B3aw=20B=B3=B9d?= X-Newsgroups: comp.databases.postgresql.sql Subject: Re: binary operators Date: Wed, 14 Feb 2001 13:22:23 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 24 Message-ID: <3A8A787F.5BE28756@e-point.pl> References: Reply-To: "jblad@e-point.pl" Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.76 [en] (WinNT; U) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200102/259 X-Sequence-Number: 1450 Frederic Metoz wrote: > Hello, > > I am looking for the binary AND and OR ... SHIFT as well. > Do they exist for postgresql ? > > Tanks, > > Fred In postgresql binary operators AND, OR ... don't exist, but you can simply extend postgresql by yours operators. You should use CREATE OPERATOR function. If you are interested in examples you can send me mail. -- Jaroslaw Blad Lead Engineer mailto:jaroslaw.blad@e-point.pl e-point S.A. POLAND (22) 853 48 30 http://www.e-point.pl