Received: from hotmail.com (f215.law14.hotmail.com [64.4.21.215])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6QKZNf08601
	for <pgsql-general@postgresql.org>;
	Thu, 26 Jul 2001 16:35:23 -0400 (EDT)
	(envelope-from oomoomi@hotmail.com)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Thu, 26 Jul 2001 13:35:21 -0700
Received: from 213.29.16.6 by lw14fd.law14.hotmail.msn.com with HTTP;
	Thu, 26 Jul 2001 20:35:18 GMT
X-Originating-IP: [213.29.16.6]
From: "omid omoomi" <oomoomi@hotmail.com>
To: Dave@micro-automation.net, pgsql-general@postgresql.org
Subject: RE: Re: What's going on here?
Date: Thu, 26 Jul 2001 20:35:18 
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <F215CDBHy3SpwBGpEI200002735@hotmail.com>
X-OriginalArrivalTime: 26 Jul 2001 20:35:21.0432 (UTC)
	FILETIME=[7D873580:01C11612]
X-Archive-Number: 200107/950
X-Sequence-Number: 13070

any rule on this table?


>From: "Dave Cramer" <Dave@micro-automation.net>
>Reply-To: <Dave@micro-automation.net>
>To: <pgsql-general@postgresql.org>
>Subject: RE: [GENERAL] Re: What's going on here?
>Date: Thu, 26 Jul 2001 15:46:23 -0400
>
>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
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster


_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp