Thread

1. BUG: NOT boolfield kills backend

   Zsolt Varga <redax@agria.hu> — 1998-09-18T10:39:16Z

   Hi, 
   I just found an error in every postgres versions, 
   (I tried 6.2.1, 6.3.2, and 6.4beta1 )
   
   if I have a table with boolean field, and I want to negate that field,
   it's kills the backend process... meanwhile 'select not ( 'T'::bool )'
   works well...
   
   create table t1 ( b bool );
   insert into t1 values ( 'T' );
   
   select not b from t1;
   PQexec() -- Request was sent to backend, but backend closed the channel
   before responding.
           This probably means the backend terminated abnormally before or
   while processing the request.
   
   	don't you have some idea what to do,?
   	
   	thanks, 
   		Redax
   .----------------------------------------------------------.
   |Zsolt Varga            | tel/fax:   +36 36 422811         |
   | AgriaComputer LTD     | email:     redax@agria.hu        |
   | System Administrator  | URL:       http://www.agria.hu/  |
   `----------------------------------------------------------'
   
   
   

2. Re: [HACKERS] BUG: NOT boolfield kills backend

   jose' soares <sferac@bo.nettuno.it> — 1998-09-18T12:54:23Z

   Hello Zsolt,
   
   venerdì, 18 settembre 98, you wrote:
   
   
   ZV> Hi, 
   ZV> I just found an error in every postgres versions, 
   ZV> (I tried 6.2.1, 6.3.2, and 6.4beta1 )
   
   ZV> if I have a table with boolean field, and I want to negate that field,
   ZV> it's kills the backend process... meanwhile 'select not ( 'T'::bool )'
   ZV> works well...
   
   ZV> create table t1 ( b bool );
   ZV> insert into t1 values ( 'T' );
   
   ZV> select not b from t1;
   
   Wrong syntax.
   The logical operator must be used in WHERE condition.
   Try this:  SELECT b FROM t1 WHERE NOT b;
   It works! ;)
   
   Jose'
   
   
   
   

3. Re: [HACKERS] BUG: NOT boolfield kills backend

   Zsolt Varga <redax@agria.hu> — 1998-09-19T13:10:53Z

   On Fri, 18 Sep 1998, Sferacarta Software wrote:
   
   |ZV> create table t1 ( b bool );
   |ZV> insert into t1 values ( 'T' );
   |
   |ZV> select not b from t1;
   |
   |Wrong syntax.
   |The logical operator must be used in WHERE condition.
   |Try this:  SELECT b FROM t1 WHERE NOT b;
   |It works! ;)
   yes, but what I want is to list every touple, 
   and negate the bool field from 'T' -> 'F' and vica verse
   
   	thanks.
   
   	redax
   
   .----------------------------------------------------------.
   |Zsolt Varga            | tel/fax:   +36 36 422811         |
   | AgriaComputer LTD     | email:     redax@agria.hu        |
   | System Administrator  | URL:       http://www.agria.hu/  |
   `----------------------------------------------------------'
   
   
   

4. Re: [HACKERS] BUG: NOT boolfield kills backend

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-09-22T21:21:11Z

   Fixed.
   
   > 
   > Hi, 
   > I just found an error in every postgres versions, 
   > (I tried 6.2.1, 6.3.2, and 6.4beta1 )
   > 
   > if I have a table with boolean field, and I want to negate that field,
   > it's kills the backend process... meanwhile 'select not ( 'T'::bool )'
   > works well...
   > 
   > create table t1 ( b bool );
   > insert into t1 values ( 'T' );
   > 
   > select not b from t1;
   > PQexec() -- Request was sent to backend, but backend closed the channel
   > before responding.
   >         This probably means the backend terminated abnormally before or
   > while processing the request.
   > 
   > 	don't you have some idea what to do,?
   > 	
   > 	thanks, 
   > 		Redax
   > .----------------------------------------------------------.
   > |Zsolt Varga            | tel/fax:   +36 36 422811         |
   > | AgriaComputer LTD     | email:     redax@agria.hu        |
   > | System Administrator  | URL:       http://www.agria.hu/  |
   > `----------------------------------------------------------'
   > 
   > 
   > 
   
   
   -- 
   Bruce Momjian                          |  830 Blythe Avenue
   maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
   http://www.op.net/~candle              |  (610) 353-9879(w)
     +  If your life is a hard drive,     |  (610) 853-3000(h)
     +  Christ can be your backup.        |