Re: error in expr. with array or wrong in documentation ?

And. Andruikhanov writes:

> 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

The documentation also says:

: To install this optional module, look in the contrib/array directory of
: the PostgreSQL source distribution.

Did you do that?

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter