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

Reply via email to