On Sun, 17 Aug 2003, andrea gelmini wrote:
> test=# SELECT * FROM sal_emp WHERE pay_by_quarter[1:4] *= 1;
> ERROR: Unable to identify an operator '*=' for types 'integer[]' and 'integer'
> You will have to retype this query using an explicit cast
I see from those docs:
However, this
andrea gelmini wrote:
test=# SELECT * FROM sal_emp WHERE pay_by_quarter[1:4] *= 1;
ERROR: Unable to identify an operator '*=' for types 'integer[]' and 'integer'
You will have to retype this query using an explicit cast
There's nothing wrong with the docs (well, at least not with respe
Hi all,
I'm in trouble with examples in
http://www.postgresql.org/docs/7.3/interactive/arrays.html.
Step by step:
-cut here---
[EMAIL PROTECTED]:~$ createdb test
CREATE DATABASE
[EMAIL PROTECTED]:~$ psql test
Welcome to psql 7.3.3, the PostgreSQL interac