Re: [BUGS] error in docs

2003-08-16 Thread Stephan Szabo
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

Re: [BUGS] error in docs

2003-08-16 Thread Joe Conway
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

[BUGS] error in docs

2003-08-16 Thread andrea gelmini
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