Re: What's going on here? - Mailing list pgsql-general

From Roderick A. Anderson
Subject Re: What's going on here?
Date
Msg-id Pine.LNX.4.10.10107261412170.9836-100000@tincan.org
Whole thread Raw
In response to What's going on here?  ("Dave Cramer" <Dave@micro-automation.net>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: /var/lib/postgres/data/base/?
Next
From: reina@nsi.edu (Tony Reina)
Date:
Subject: Re: Replication with PostgreSQL