Re: Index / Performance issues - Mailing list pgsql-performance

From scott.marlowe
Subject Re: Index / Performance issues
Date
Msg-id Pine.LNX.4.33.0303100954280.14220-100000@css120.ihs.com
Whole thread Raw
In response to Re: Index / Performance issues  (Greg Stark <gsstark@mit.edu>)
Responses Re: Index / Performance issues  (Kevin Brown <kevin@sysexperts.com>)
List pgsql-performance
On 7 Mar 2003, Greg Stark wrote:

>
>
> "scott.marlowe" <scott.marlowe@ihs.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.


pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: OIDs as keys
Next
From: "Scott Buchan"
Date:
Subject: Large difference between elapsed time and run time for queries