That works. Thx :)
On Thursday, May 11, 2017 at 2:08:29 PM UTC-5, Jeremy Evans wrote:
>
> On Thursday, May 11, 2017 at 9:19:31 AM UTC-7, Matt Campbell wrote:
>>
>> 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
>>
>
> It looks like what you want is just a regular qualified identifier:
>
> Sequel[:complex_column][:my_column]
> # or :complex_column__my_column if you are still splitting symbols
>
> Thanks,
> Jeremy
>
--
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.
