On Monday 09 Jun 2003 10:24 am, Rado Petrik wrote:
> I have query " SELECT id_user FROM user WHERE (freg_u & 2 ) > 0 ".
>
> freg_u is type smallint.
> How I retype freg_u to interger ?
... WHERE (freg_u::integer & 2) ...
Or you could use the more standard but long-winded CAST function
-- Richard Huxton
