Retype - Mailing list pgsql-sql

From Rado Petrik
Subject Retype
Date
Msg-id 1055150663.1819.9.camel@caj
Whole thread Raw
Responses Re: Retype
List pgsql-sql
Hi, 

I have query  " SELECT id_user FROM user WHERE (freg_u & 2 ) > 0 ".

freg_u is type smallint.
Query return this error.  

PostgreSQL query failed: ERROR: Unable to identify an operator '&' for
types 'smallint' and 'integer' You will have to retype this query using
an explicit cast in 

How I retype freg_u to interger ? 
-- 
Rado Petrik <r.p@szm.sk>




pgsql-sql by date:

Previous
From: Michael A Nachbaur
Date:
Subject: Re: "Join" on delimeter aggregate query
Next
From: george young
Date:
Subject: find open transactions/locks in 7.2?