Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am jsgv on github.
  • I am jsgv (https://keybase.io/jsgv) on keybase.
  • I have a public key ASDbYVEwwlQ6ZIU7-aHu6BLwZGstX90G6FwuGSyAFD62SQo

To claim this, I am signing this object:

@jsgv
jsgv / psql-returns.sql
Created May 23, 2016 18:05
Postgres function using returns
CREATE OR REPLACE FUNCTION public.fn_subscriber_save(
IN _emailaddress character varying,
IN _firstname character varying,
IN _lastname character varying,
IN _subscribeurl character varying,
IN _mobilenumber character varying DEFAULT NULL::character varying,
IN _ipaddress cidr DEFAULT NULL::cidr)
RETURNS TABLE(subscriberid integer) AS
$BODY$
DECLARE