Skip to content

Instantly share code, notes, and snippets.

@jkatz
Created February 1, 2013 21:39
Show Gist options
  • Save jkatz/4694340 to your computer and use it in GitHub Desktop.
Save jkatz/4694340 to your computer and use it in GitHub Desktop.
WITH first AS (
INSERT INTO y
SELECT * FROM
generate_series(1, 100)
RETURNING a
)
SELECT *
FROM first f1
JOIN first f2 ON f1.a = f2.a;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment