pg_atoi error - Mailing list pgsql-sql

From Oleg Lebedev
Subject pg_atoi error
Date
Msg-id 3C698464.DC9D6218@waterford.org
Whole thread Raw
List pgsql-sql
Hi everybody,
I am getting the following error when calling a procedure on one
database, but the same procedure runs ok on another database, which is a
smaller instance of the former database:
ERROR: pg_atoi: error in "Production": can't parse "Production"

Inside the procedure I am trying to compare one of the table fields to
''Procedure'' as follows:
..
IF OLD.status != ''Procedure''   AND NEW.status=''Procedure''
...

I have no idea what can cause this.
Please help.

thanks,

Oleg




pgsql-sql by date:

Previous
From: "Andrew G. Hammond"
Date:
Subject: Re: SQL request to retrieve the type of columns
Next
From: Oleg Lebedev
Date:
Subject: Re: pg_atoi error