How to convert this Postgresql code to Snowflake? Or How is it written in Snowflake?

Viewed 80
Create function get_car_Price(Price_from int, Price_to int)  
returns int  
language plpgsql  
as  
$$  
Declare  
 Car_count integer;  
Begin  
   select count(*)   
   into Car_count  
   from Car  
   where Car_price between Price_from and Price_to;  
   return Car_count;  
End;  
$$;  
1 Answers

The translation is straighforward:

CREATE FUNCTION get_car_Price(PRICE_FROM int, PRICE_TO int)
RETURNS INT
AS 'SELECT COUNT(*) FROM CAR WHERE Car_price BETWEEN PRICE_FROM AND PRICE_TO';

Function call:

SELECT get_car_price(100,200);
-- 0

Related: Scalar SQL UDFs

Related