Received: from tincan.org ([216.64.180.202])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6QLEMf23266
	for <pgsql-general@postgresql.org>;
	Thu, 26 Jul 2001 17:14:22 -0400 (EDT)
	(envelope-from raanders@tincan.org)
Received: from localhost (raanders@localhost)
	by tincan.org (8.9.3/8.8.7) with ESMTP id OAA09989;
	Thu, 26 Jul 2001 14:14:03 -0700
Date: Thu, 26 Jul 2001 14:14:03 -0700 (PDT)
From: "Roderick A. Anderson" <raanders@tincan.org>
To: Dave Cramer <Dave@micro-automation.net>
cc: pgsql-general@postgresql.org
Subject: Re: What's going on here?
In-Reply-To: <020501c11603$8f5cef70$8201a8c0@inspiron>
Message-ID: <Pine.LNX.4.10.10107261412170.9836-100000@tincan.org>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Archive-Number: 200107/955
X-Sequence-Number: 13075

On Thu, 26 Jul 2001, Dave Cramer wrote:

> ebox=# select eitemcode,itemavail from inventory where itemavail = 1
> limit 1;
>  eitemcode | itemavail 
> -----------+-----------
>    6100122 |         1
> (1 row)
> 
> ebox=# update inventory set itemavail=0 where eitemcode=6100122;
> UPDATE 0

Did eitemcode get left padded with some whitespace character(s)?


Rod
Rod
-- 
                 Remove the word 'try' from your vocabulary ... 
                     Don't try.  Do it or don't do it ...
                                Steers try!

                                                            Don Aslett