Re: Invalid syntax for integer

От:

"David Johnston" <polobo@yahoo.com>

Дата:

13 марта 2012 г. в 15:35:24

Invalid syntax for integer

От:

Rehan Saleem <pk_rehan@yahoo.com>

Дата:

13 марта 2012 г. в 15:25:56

hi ,

what is wrong with this if statement in this function

if distance ='' THEN
distance := 1;
end if;

here distance variable is of type integer , this function has been created successfully but when i execute this function it gives me this error ,

ERROR: invalid input syntax for integer: ""
LINE 1: SELECT distance =''
^
QUERY: SELECT distance =''
CONTEXT: PL/pgSQL function "getsitesbytfid" line 6 at IF

********** Error **********

ERROR: invalid input syntax for integer: ""
SQL state: 22P02
Context: PL/pgSQL function "getsitesbytfid" line 6 at IF