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: Pine.LNX.4.33.0303100954280.14220-100000@css120.ihs.com (view raw or flat)
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

Responses

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-2014 The PostgreSQL Global Development Group