Re: Index / Performance issues

From: Greg Stark <gsstark(at)mit(dot)edu>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
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-08 02:39:09
Message-ID: 877kbalgz6.fsf@stark.dyndns.tv
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"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.

--
greg

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2003-03-08 03:13:24 Re: Stored Procedures and compiling
Previous Message scott.marlowe 2003-03-08 00:33:26 Re: Index / Performance issues