How PostgreSQL’s SQL dialect stays ahead of its competitors [PDF slides]

modern-sql.com

4 pointsMarkusWinand2 comments

Is it correct that SQL Server does not support IDENTITY(slide 29)?

IDENTITY property is supported from as far as I can remember: https://docs.microsoft.com/en-us/sql/t-sql/statements/create...

Second approach is DEFAULT with sequence.

CREATE SEQUENCE seq; CREATE TABLE tab(i INT DEFAULT NEXT VALUE FOR seq, b VARCHAR(100))

Thanks for pointing out!

The syntax used by SQL Server doesn't follow the standard. Or, in other words, the standard syntax gives an error in SQL server. However, I'll note that there is an alternative syntax in future versions of these slides.

Thanks again.

Reply on news.ycombinator.com