Total number of rooms

I have a table with hosts, and there are several colums there about amount of different sooms. Living rooms, kitchens etc.

Now I also need a count of total rooms to this host object. What is the best practice of doing this? Can I have a column, that takes an int as the sum of other columns? Or how does that work?

thanks!

garyaustin•8/23/22, 2:26 PM

Alot depends on what you need to do with the extra column. You can use this: https://www.postgresql.org/docs/current/ddl-generated-columns.html to add a column that automatically calculates and can be used in any operation. The cost is extra storage for a column. You might be able to just post process and add them up if it is just for display.

PostgreSQL Documentation

5.3. Generated Columns

5.3. Generated Columns A generated column is a special column that is always computed from other columns. Thus, it is for …

Ggaryaustin Alot depends on what you need to do with the extra column. You can use this: h...

TARSOP•8/23/22, 7:18 PM

I see, in this case I want a column in this supabase table, that is the sum of the value from 5 other columns.

garyaustin•8/23/22, 7:26 PM

Yes that method will work for that.

Total number of rooms

Similar Threads

Similar Threads

Similar Threads