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@gmx.net   http://funkturm.homeip.net/~peter