[SQL] Invalid syntax for integer

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 intege

Re: [SQL] Invalid syntax for integer

From: [email protected] [mailto:[email protected]] On Behalf Of Rehan Saleem Sent: Tuesday, March 13, 2012 2:26 PM To: [email protected] Subject: [SQL] Invalid syntax for integer hi , what is wrong with this if statement in this function if distance =''