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

error in expr. with array or wrong in documentation ?

From: "And(dot) Andruikhanov" <andy(at)euinf(dot)dp(dot)ua>
To: pgsql-bugs(at)postgresql(dot)org
Subject: error in expr. with array or wrong in documentation ?
Date: 2001-05-21 16:06:06
Message-ID: Pine.BSF.3.96.1010521185809.4832B-100000@euinf.dp.ua (view raw or flat)
Thread:
Lists: 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..
  --


In response to

Responses

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-05-21 16:45:03
Subject: Re: error in expr. with array or wrong in documentation ?
Previous:From: And. AndruikhanovDate: 2001-05-21 15:47:01
Subject: temp table in pl/pgsql language

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