scott.marlowe wrote:
> > 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.
May as well make it as portable as possible, though:
select * from table where 8bitintfield = CAST(123456789 AS bigint)
--
Kevin Brown kevin(at)sysexperts(dot)com