On 7 Mar 2003, Greg Stark wrote:
> "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> writes:
> > select * from table where 8bitintfield='123456789';
> 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 Buchan||Date: 2003-03-10 18:58:26|
|Subject: Large difference between elapsed time and run time for queries|
|Previous:||From: Bruce Momjian||Date: 2003-03-10 16:05:21|
|Subject: Re: OIDs as keys|