we need to be able to support
SELECT jobsdb.upsert_location(
:city,
:state,
:postal,
:country
) as id;
in addition to
SELECT upsert_location(
:city,
:state,
:postal,
:country
) as id;
not everyone will want to update their search path - and depending on how they setup their db it could be useful to join cross schemas
consider also:
and