I want to update the value of one column of a composite type, but I'm
getting a syntax error on the sql sequel generates.
DB[:my_table].where(id: 1).update(:complex_column.pg_row[:my_column] =>
'my_value')
This results in the following SQL
UPDATE "my_table" SET ("complex_column")."my_column" = 'my_value' WHERE (
"id" = 1)
Postgres doesn't like the parentheses around complex_column (here's a link
to the docs that say this
https://www.postgresql.org/docs/9.5/static/rowtypes.html#AEN8116). Is there
another way to do this other than using
"complex_column.my_column".lit
for the column name in the update call?
ruby version: 2.3.1
sequel version: 4.44.0
sequel_pg version: 1.6.17
pg version: 0.18.4
PostgreSQL Version 9.5.0
Thanks,
Matt
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
