Skip to content

Instantly share code, notes, and snippets.

@biswanaths

biswanaths/python_udf.sql

Created January 28, 2020 14:19
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save biswanaths/889366e58e5be38a391ac9eba9b29211 to your computer and use it in GitHub Desktop.
Save biswanaths/889366e58e5be38a391ac9eba9b29211 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
python_udf.sql
CREATE FUNCTION appendbar(s1 varchar) RETURNS varchar IMMUTABLE AS $$
def appendbar(value):
value = value or ""
return value + "_bar"
return appendbar(s1)
$$ language plpythonu;
-- usage example
select name, appendbar(name) from table_foo limit 20;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment