Skip site navigation (1) Skip section navigation (2)

Re: Index / Performance issues

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: Lucas Adamski <ladamski(at)breakwatersecurity(dot)com>,"Postgresql Performance Mailing list (E-mail)" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index / Performance issues
Date: 2003-03-10 16:55:53
Message-ID: (view raw or whole thread)
Lists: pgsql-performance
On 7 Mar 2003, Greg Stark wrote:

> "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> > select * from table where 8bitintfield='123456789';
> Or:
> 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.

In response to


pgsql-performance by date

Next:From: Scott BuchanDate: 2003-03-10 18:58:26
Subject: Large difference between elapsed time and run time for queries
Previous:From: Bruce MomjianDate: 2003-03-10 16:05:21
Subject: Re: OIDs as keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group