Need help adding user.id to array column

I have a column in the table called "interested" I am trying to attach ther user.id to this table. I have the column as text and as an array. I've tried several different methods and cannot get it working.

is .update the right way? Currently it just overwrites whatever is in the column.

nivekzOP•10/13/22, 8:26 PM

What I’m trying to do is.

I have an audience table with 2 columns events.id and users.id. My goal is to attach users to the users.id column that match corresponding event. When button is pressed on my website.

I need them as array so I can later pull this data to show all users who are interested in attending event.

garyaustin•10/13/22, 9:00 PM

To change an array you can only read it to the client, add to the array, and write it back.
You would need to use an rpc function and SQL to insert into an array.

You could also have a separate table with with user_id and event_id and use that to match users to events.

nivekzOP•10/13/22, 10:19 PM

ah ok that makes sense, I do have a table with both profiles and events. I'll look into matching them this way

Need help adding user.id to array column

Similar Threads

Similar Threads

Similar Threads