Skip to content
Advertisement

Save few values to the row in Postgres [closed]

Is it possible to save few values to the row. For example, I have 2 tables: For Participants:

And for Voters:

I want to get array of participants uuid after executing SELECT participants FROM voters WHERE uuid='someuuid';

Advertisement

Answer

then later use unnest function to expand the array to row records

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement