Skip to content

Instantly share code, notes, and snippets.

@ringerc
Created September 16, 2014 11:54
Show Gist options
  • Save ringerc/d1163c0ff76b9a5e28b0 to your computer and use it in GitHub Desktop.
Save ringerc/d1163c0ff76b9a5e28b0 to your computer and use it in GitHub Desktop.
CREATE SCHEMA myschema;
CREATE TABLE myschema.zzafter(id integer);
CREATE OR REPLACE FUNCTION myschema.aabefore()
RETURNS void
LANGUAGE plpgsql
AS $$
DECLARE
somefield myschema.zzafter.id%TYPE;
BEGIN
RETURN;
END;
$$;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment