The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

strict = Vertica::RETURN_NULL_ON_NULL_INPUT behavior in UDx


When I am specifying

strict = Vertica::RETURN_NULL_ON_NULL_INPUT;

my UDx never gets any nulls. Seems to be Vertica is filtering them out before passing to my UDx.

It is a welcome behavior, but undocumented.

Can you ask developers, can I rely on UDx functionality - when Vertica::RETURN_NULL_ON_NULL_INPUT is set, null argument values are filtered out for me?

Can this behavior be documented?

Thank you!

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file