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

Re: What's going on here?

From: jdassen(at)cistron(dot)nl (J(dot)H(dot)M(dot) Dassen (Ray))
To: pgsql-general(at)postgresql(dot)org
Subject: Re: What's going on here?
Date: 2001-07-26 19:24:20
Message-ID: slrn9m0rfc.29a.jdassen@odin.cistron-office.nl (view raw or flat)
Thread:
Lists: pgsql-general
Dave Cramer <Dave(at)micro-automation(dot)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


In response to

Responses

pgsql-general by date

Next:From: Dave CramerDate: 2001-07-26 19:46:23
Subject: RE: Re: What's going on here?
Previous:From: Stephan SzaboDate: 2001-07-26 19:21:54
Subject: Re: What's going on here?

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