CODEWITHSUNDEEP
functionnullsnowflake-cloud-data-platformuser-defined-functions
Raj
Raj

Reputation: 13

How to return 0 if null from UDF in Snowflake

I am writing user defined functions in Snowflake and doing some SELECT in the functions. I need to return 0 if select returns NULL.

In the below example if there is no rid available from tableA, function is returning NULL, but i need my function to return 0 instead of NULL.

Also, how to declare a variable inside function in snowflake?

Eg:

CREATE OR REPLACE FUNCTION A(ID int)
RETURNS float(53)
AS 
$$
         
        SELECT rid from tableA;
$$
;

Upvotes: 1

Views: 751

Answers (1)

NickW
NickW

Reputation: 9778

Returning 0:

SELECT nvl(rid,0) from tableA;

To use variables you would need to write javascript UDFs rather than sql UDFs

Upvotes: 1

Related Questions