How to do an Update Query on one to many relationship tables.

[jaiswal-rishabh]

How do I write a query like below, using go-pg. I am trying to update child table records based on where clause both on child table and parent table columns. Working Postgres raw query is

UPDATE child_table ct
set col_ct_A = 'foo'
FROM parent_table pt where pt.id = ct.reference_id
and pt.col_pt_X = 'some_value' AND ct.id IN ('foo','bar') Returning ct.*;