error in expr. with array or wrong in documentation ? - Mailing list pgsql-bugs

From And. Andruikhanov
Subject error in expr. with array or wrong in documentation ?
Date
Msg-id Pine.BSF.3.96.1010521185809.4832B-100000@euinf.dp.ua
Whole thread Raw
In response to temp table in pl/pgsql language  ("And. Andruikhanov" <andy@euinf.dp.ua>)
Responses Re: error in expr. with array or wrong in documentation ?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-bugs
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..
  --

pgsql-bugs by date:

Previous
From: "And. Andruikhanov"
Date:
Subject: temp table in pl/pgsql language
Next
From: Peter Eisentraut
Date:
Subject: Re: error in expr. with array or wrong in documentation ?