Skip to content

Instantly share code, notes, and snippets.

@dgillis

dgillis/ex.sql

Created September 11, 2015 16:03
Show Gist options
  • Save dgillis/2df7e7c78818ca1f7cd3 to your computer and use it in GitHub Desktop.
Save dgillis/2df7e7c78818ca1f7cd3 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
ex.sql
create table tbl (id serial primary key, obj jsonb);
select json_populate_record(null::tbl, '{"id": 1, "obj": {"id": 8}}');
-- ERROR: invalid input syntax for integer: "{"id": 8"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment