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
