X-Original-To: pgsql-performance@postgresql.org Received: from sabre.velocet.net (sabre.velocet.net [216.138.209.205]) by postgresql.org (Postfix) with ESMTP id 0CE95474E44 for ; Fri, 7 Mar 2003 21:39:12 -0500 (EST) Received: from stark.dyndns.tv (H162.C233.tor.velocet.net [216.138.233.162]) by sabre.velocet.net (Postfix) with ESMTP id BB4BE13809E; Fri, 7 Mar 2003 21:39:09 -0500 (EST) Received: from localhost ([127.0.0.1] helo=stark.dyndns.tv ident=foobar) by stark.dyndns.tv with smtp (Exim 3.36 #1 (Debian)) id 18rUEv-0002Ib-00; Fri, 07 Mar 2003 21:39:09 -0500 To: "scott.marlowe" Cc: Lucas Adamski , "Postgresql Performance Mailing list (E-mail)" Subject: Re: Index / Performance issues References: In-Reply-To: From: Greg Stark Organization: The Emacs Conspiracy; member since 1992 Date: 07 Mar 2003 21:39:09 -0500 Message-ID: <877kbalgz6.fsf@stark.dyndns.tv> Lines: 15 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200303/63 X-Sequence-Number: 1361 "scott.marlowe" writes: > select * from table where 8bitintfield='123456789'; Or: select * from table where 8bitintfield=123456789::int8 I'm not sure which is aesthetically more pleasing. -- greg