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