Обсуждение:

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

andrew.wan@nu-net.com writes:

> 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').

This is a bug (??) that's fixed in 7.1, which is currently in beta.

-Doug