Thread

1. ERROR: pg_atoi: error in "NULL": can't parse "NULL"

   Rado Petrik <r.p@szm.sk> — 2003-05-07T14:57:27Z

   Hi , 
   
   
   I have any column. 'test' . When I insert 'none' to column 'test' , no
   problem.
   
   test
   -----
   NONE 
   
   But when I update column , postgreSQL return this error.
    
   ERROR:  pg_atoi: error in "NULL": can't parse "NULL"
   
   Where is problem ? 
   
   Thanks
   -- 
   Rado Petrik <r.p@szm.sk>
   
   
   

2. Re: ERROR:Â pg_atoi: error in "NULL": can't parse "NULL"

   Josh Berkus <josh@agliodbs.com> — 2003-05-07T15:37:25Z

   Rado,
   
   > But when I update column , postgreSQL return this error.
   >
   > ERROR:  pg_atoi: error in "NULL": can't parse "NULL"
   >
   > Where is problem ?
   
   Please post your updated statement.
   
   -- 
   Josh Berkus
   Aglio Database Solutions
   San Francisco
   
   
   

3. Re: ERROR:   pg_atoi: error in "NULL": can't

   Jean-Luc Lachance <jllachan@nsd.ca> — 2003-05-07T15:47:01Z

   Use NULL without quotes
   
   
   Rado Petrik wrote:
   > 
   > Hi ,
   > 
   > I have any column. 'test' . When I insert 'none' to column 'test' , no
   > problem.
   > 
   > test
   > -----
   > NONE
   > 
   > But when I update column , postgreSQL return this error.
   > 
   > ERROR:  pg_atoi: error in "NULL": can't parse "NULL"
   > 
   > Where is problem ?
   > 
   > Thanks
   > --
   > Rado Petrik <r.p@szm.sk>
   > 
   > ---------------------------(end of broadcast)---------------------------
   > TIP 5: Have you checked our extensive FAQ?
   > 
   > http://www.postgresql.org/docs/faqs/FAQ.html