Skip to content

Instantly share code, notes, and snippets.

@alex-eri

alex-eri/kavychki

Created March 8, 2019 10:49
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 alex-eri/8d20c685e19284e4bcf404e4aac7a33d to your computer and use it in GitHub Desktop.
Save alex-eri/8d20c685e19284e4bcf404e4aac7a33d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
kavychki
postgres=# create function lala () returns numeric LANGUAGE plpgsql as $$ begin return 1; end;$$;
CREATE FUNCTION
postgres=# select lala();
lala
------
1
(1 row)
postgres=# select "lala"();
lala
------
1
(1 row)
postgres=# select public."lala"();
lala
------
1
(1 row)
postgres=# create function "lala" () returns numeric LANGUAGE plpgsql as $$ begin return 1; end;$$;
ERROR: function "lala" already exists with same argument types
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment