Received: from net2.micro-automation.com (net2.micro-automation.com
	[64.7.141.29])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f6QKe3f10513
	for <pgsql-general@postgresql.org>;
	Thu, 26 Jul 2001 16:40:03 -0400 (EDT)
	(envelope-from Dave@micro-automation.net)
Received: (qmail 32738 invoked from network); 26 Jul 2001 20:40:00 -0000
Received: from eboxwest.ebox.com (HELO inspiron) (206.51.23.194)
	by net2.micro-automation.com with SMTP; 26 Jul 2001 20:40:00 -0000
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 16:37:21 -0400
Organization: Micro Automation Inc.
Message-ID: <020d01c11612$c55f63f0$8201a8c0@inspiron>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2616
In-reply-to: <F215CDBHy3SpwBGpEI200002735@hotmail.com>
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Importance: Normal
X-AntiVirus: scanned for viruses by AMaViS 0.2.1 (http://amavis.org/)
X-Archive-Number: 200107/952
X-Sequence-Number: 13072

No, I don't think so

ebox=# select * from pg_rules 
ebox-# ;
 tablename | rulename | definition 
-----------+----------+------------
(0 rows)

-----Original Message-----
From: omid omoomi [mailto:oomoomi@hotmail.com] 
Sent: July 26, 2001 8:35 PM
To: Dave@micro-automation.net; pgsql-general@postgresql.org
Subject: RE: [GENERAL] Re: What's going on here?


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