Michael Long wrote:
> ERROR: operator does not exist: character varying == "unknown"
> HINT: No operator matches the given name and argument type(s). You may need to add
> explicit type casts.
> CONTEXT: PL/pgSQL function "building_insert" line 14 at if
Common mistake, still make it myself on occasion. The '==' operator
doesn't exist in plpgsql, you should use '=' when comparing and ':=' for
assignment.
HTH
--
Richard Huxton
Archonet Ltd