Skip to content

Instantly share code, notes, and snippets.

@PedersenThomas
Created September 23, 2013 20:26
Show Gist options
  • Save PedersenThomas/6676398 to your computer and use it in GitHub Desktop.
Save PedersenThomas/6676398 to your computer and use it in GitHub Desktop.
CREATE OR REPLACE FUNCTION
InsertPerson(text, text, timestamp, double precision)
RETURNS
INTEGER
AS
$delimiter$
INSERT INTO person(firstname, lastname, dateofbirth, height) VALUES
($1, $2, $3, $4)
RETURNING id
$delimiter$
LANGUAGE SQL;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment