Can you *insert* a new record as JSON?  Updating seems to work, but I can't
seem to get the syntax for inserting.

Success:
$pg->db->update('cache', {record => {-json => {a => 2}}});

No success:
$pg->db->insert('cache', {record => {-json => {a => 2}}});

SQL::Abstract::Pg#JSON
<https://mojolicious.org/perldoc/SQL/Abstract/Pg#JSON> demonstrates that an
*update* can take a JSON structure, but does not demonstrate such for
*insert*.  If one can update a record to include JSON, why not allow to
insert it?  If you have a table with a json column, how is one to populate
the column on the initial insert?

-- 
You received this message because you are subscribed to the Google Groups 
"Mojolicious" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to mojolicious+unsubscr...@googlegroups.com.
To post to this group, send email to mojolicious@googlegroups.com.
Visit this group at https://groups.google.com/group/mojolicious.
For more options, visit https://groups.google.com/d/optout.

Reply via email to