Skip to content
Advertisement

how can i get the sum of two colums realtime

i have the following

I want to have something like that

select *, a+b as mes from maths;

but to have a column sum and evrytime the columns a and b get update calculate the new sum in columns sum

i try this and i get the following error

Advertisement

Answer

The syntax for generated column in PostgreSQL is:

Demo: https://dbfiddle.uk/?rdbms=postgres_12&fiddle=7f328dbdb991e68b46a8292bf7c480ab

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