Reply-To: <Dave@micro-automation.net>
From: "Dave Cramer" <Dave@micro-automation.net>
To: <pgsql-general@postgresql.org>
Subject: RE: Re: What's going on here?
Date: Thu, 26 Jul 2001 15:46:23 -0400
Organization: Micro Automation Inc.
Message-ID: <020601c1160b$a6885b50$8201a8c0@inspiron>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
In-reply-to: <slrn9m0rfc.29a.jdassen@odin.cistron-office.nl>
Importance: Normal

ebox=# select eitemcode,itemavail from inventory where
eitemcode=6100122;
 eitemcode | itemavail 
-----------+-----------
   6100122 |         1
(1 row)

Dave

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of J.H.M. Dassen
(Ray)
Sent: July 26, 2001 3:24 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Re: What's going on here?


Dave Cramer <Dave@micro-automation.net> wrote:
> ebox=# select version();
>                            version                           
> -------------------------------------------------------------
>  PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc 2.96

I wouldn't trust that build for production uses; see
http://gcc.gnu.org/gcc-2.96.html .

> ebox=# select eitemcode,itemavail from inventory where itemavail = 1 
> limit 1;  eitemcode | itemavail
> -----------+-----------
>    6100122 |         1

> ebox=# update inventory set itemavail=0 where eitemcode=6100122; 
> UPDATE 0

What do you get with "select eitemcode,itemavail from inventory where
eitemcode=6100122"? "UPDATE 0" means no row matched the "where" clause.

If this select does return rows, something truely weird is happening. If
it does not return rows, there may be some kind of typing/casting issue
at work.

HTH,
Ray
-- 
Javascript is EVIL!
	keyweed


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster