Skip site navigation (1) Skip section navigation (2)

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

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: "And(dot) Andruikhanov" <andy(at)euinf(dot)dp(dot)ua>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: error in expr. with array or wrong in documentation ?
Date: 2001-05-21 16:45:03
Message-ID: Pine.LNX.4.30.0105211844150.757-100000@peter.localdomain (view raw or flat)
Thread:
Lists: pgsql-bugs
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


In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-05-21 17:41:07
Subject: psql dumps core when entering invalid backslash command
Previous:From: And. AndruikhanovDate: 2001-05-21 16:06:06
Subject: error in expr. with array or wrong in documentation ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group