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.