select cast(coalesce(nullif('', trim(callingip)), '127.0.0.1') as inet) ERROR: invalid input syntax for type inet: "" what is it trying to tell me? -- How many Vietnam vets does it take to screw in a light bulb? You don't know, man. You don't KNOW. Cause you weren't THERE. http://bash.org/?255991 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster