error in expr. with array or wrong in documentation ?
От | And. Andruikhanov |
---|---|
Тема | error in expr. with array or wrong in documentation ? |
Дата | |
Msg-id | Pine.BSF.3.96.1010521185809.4832B-100000@euinf.dp.ua обсуждение исходный текст |
Ответ на | temp table in pl/pgsql language ("And. Andruikhanov" <andy@euinf.dp.ua>) |
Ответы |
Re: error in expr. with array or wrong in documentation ?
|
Список | pgsql-bugs |
Good day. System Configuration --------------------- Architecture: Intel Pentium Operating System: FreeBSD 4.2-STABLE PostgreSQL version: PostgreSQL-7.1RC1 or 7.1.1 Compiler used: gcc 2.95.2 Description of problem ---------------------- 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 Best regards.. --
В списке pgsql-bugs по дате отправления: