hi,
I  am trying to make a function that takes four varchar arguments as in
CREATE FUNCTION address(varchar,varchar,varchar,varchar) ...

when i try to pass the function a NULL value, it turns all the values into
NULL:
select address('foo','foo',NULL,'foo').

i also tried putting in type record(i'm not sure that this is a valid
argument type but documentation
listed it for declarations), and i tried putting in the name of a table.
none of it works.

Is there anyway to define argument type(s) that accept NULL values?
                a             n            d              r            e
w