RE: Re: What's going on here?
От | Dave Cramer |
---|---|
Тема | RE: Re: What's going on here? |
Дата | |
Msg-id | 020d01c11612$c55f63f0$8201a8c0@inspiron обсуждение исходный текст |
Ответ на | RE: Re: What's going on here? ("omid omoomi" <oomoomi@hotmail.com>) |
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: