X-Original-To: pgsql-performance@postgresql.org Received: from filer (12-234-86-219.client.attbi.com [12.234.86.219]) by postgresql.org (Postfix) with ESMTP id 3FB2947592C for ; Mon, 10 Mar 2003 22:44:32 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) (uid 1000) by filer with local; Mon, 10 Mar 2003 19:44:36 -0800 Date: Mon, 10 Mar 2003 19:44:36 -0800 From: Kevin Brown To: pgsql-performance@postgresql.org Subject: Re: Index / Performance issues Message-ID: <20030311034436.GG1847@filer> Mail-Followup-To: Kevin Brown , pgsql-performance@postgresql.org References: <877kbalgz6.fsf@stark.dyndns.tv> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.4i Organization: Frobozzco International X-Archive-Number: 200303/74 X-Sequence-Number: 1372 scott.marlowe wrote: > > select * from table where 8bitintfield=123456789::int8 > > > > > > I'm not sure which is aesthetically more pleasing. > > The cast is self documenting, so it's probably a better choice for most > setups. On the other hand, it's not as likely to be portable. May as well make it as portable as possible, though: select * from table where 8bitintfield = CAST(123456789 AS bigint) -- Kevin Brown kevin@sysexperts.com