Retype

From: Rado Petrik <r(dot)p(at)szm(dot)sk>
To: pgsql-sql(at)postgresql(dot)org
Subject: Retype
Date: 2003-06-09 09:24:24
Message-ID: 1055150663.1819.9.camel@caj
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)p(at)szm(dot)sk>

Responses

  • Re: Retype at 2003-06-10 07:20:44 from Richard Huxton

Browse pgsql-sql by date

  From Date Subject
Next Message Mendola Gaetano 2003-06-09 11:22:25 Re: Using a RETURN NEXT
Previous Message Eivind Kvedalen 2003-06-09 08:35:10 Re: "Join" on delimeter aggregate query