Declare and Update in PostgreSQL query?

Asked Mar 17 '23 at 16:32

Active Mar 17 '23 at 16:33

Viewed 14 times

what will be the equivalent PostgreSQL query of the below T-SQL query?

DECLARE @IncrementValue int
SET @IncrementValue = 1
UPDATE Table1 SET Column1 = Column1 + @IncrementValue

edited Mar 17 '23 at 16:33

asked Mar 17 '23 at 16:32

sjMalik

2

`UPDATE Table1 SET Column1 = Column1 + 1`? Probably, providing sample data and desired results would clarify your question. – GMB Mar 17 '23 at 16:33

0 Answers0