Received: from magenta.timewarp.co.uk (mail.wisps.co.uk [195.188.56.7]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0V6PCq92186 for ; Wed, 31 Jan 2001 01:25:12 -0500 (EST) (envelope-from ken@kencorey.com) Received: from [195.167.153.42] by magenta.timewarp.co.uk (NTMail 5.06.0016/NT9060.00.3234d82d) with ESMTP id dkszhaaa for pgsql-sql@postgresql.org; Wed, 31 Jan 2001 06:21:21 +0000 Message-ID: <3A77B078.8D33CE1F@kencorey.com> Date: Wed, 31 Jan 2001 06:28:08 +0000 From: Ken Corey Reply-To: ken@kencorey.com X-Mailer: Mozilla 4.75 [en] (X11; U; Linux 2.2.15-4mdk i686) X-Accept-Language: en MIME-Version: 1.0 To: Frederic Metoz CC: pgsql-sql@postgresql.org Subject: Re: binary operators References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/468 X-Sequence-Number: 1144 Frederic Metoz wrote: > I am looking for the binary AND and OR ... SHIFT as well. > Do they exist for postgresql ? Depending on what you're doing...you might get away with using mathematical operators to accomplish the above... A right SHIFT would be dividing by 2. A left shift would be multiplying by 2. I don't know off the top of my head about AND and OR. Doesn't the manual cover this? -Ken