xivSolutions/gist:50f4944acc3399133dd9

Created July 19, 2014 22:13

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/xivSolutions/50f4944acc3399133dd9.js"></script>
Save xivSolutions/50f4944acc3399133dd9 to your computer and use it in GitHub Desktop.

Download ZIP

PG - Include inserted ID in JSON

Raw

gistfile1.sql

INSERT INTO "ClientDocuments" ("ClientDocumentId", body) VALUES (nextval('"ClientDocuments_ClientDocumentId_seq"'::regclass), cast('{"id":"' || lastval() || '", "name":"John"}' as json)) 

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment