Good day. System Configuration --------------------- Architecture: Intel Pentium Operating System: FreeBSD 4.2-STABLE PostgreSQL version: PostgreSQL-7.1RC1 or 7.1.1 Compiler used: gcc 2.95.2 Description of problem ---------------------- Chapter 6. Arrays (In Documentation). It say: To search the entire array (not just specified columns), you could use: SELECT * FROM sal_emp WHERE pay_by_quarter *= 10000; But, If client try to execute query, for example: select * from pg_group where grolist *= 1003::integer; Then it received message: ERROR: Unable to identify an operator '*=' for types '_int4' and 'int4' You will have to retype this query using an explicit cast Best regards.. -- ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly