Postgres Pro
Downloads
Home   >   mailing lists

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

From Greg Stark
Subject Re: Index / Performance issues
Date
Msg-id 877kbalgz6.fsf@stark.dyndns.tv
Whole thread Raw
In response to Re: Index / Performance issues  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: Index / Performance issues  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-performance
Tree view 

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

--
greg

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Index / Performance issues
Next
From: Tom Lane
Date:
Subject: Re: Stored Procedures and compiling