Skip to content

Instantly share code, notes, and snippets.

@abelcallejo

abelcallejo/function_name_here.sql

Created June 27, 2018 02:14
Show Gist options
  • Save abelcallejo/897c7adedb77f7e2dbd60c362a531d98 to your computer and use it in GitHub Desktop.
Save abelcallejo/897c7adedb77f7e2dbd60c362a531d98 to your computer and use it in GitHub Desktop.
Download ZIP
Creating a user-defined PostgreSQL function
Raw
function_name_here.sql
CREATE FUNCTION function_name_here(character varying) RETURNS text AS $$
SELECT column_name FROM "TABLE_NAME" GROUP BY "_ORDINAL_NUMBER" ORDER BY "_ORDINAL_NUMBER"; $$
LANGUAGE SQL
IMMUTABLE
RETURNS NULL ON NULL INPUT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment