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

Re:How PostgreSQL’s SQL dialect stays ahead of its competito... by some_user54 on Sunday July 22, 2018 @08:14AM (#17586356)

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))

[ Parent | on HN ]

Re:How PostgreSQL’s SQL dialect stays ahead of its competito... by MarkusWinand on Sunday July 22, 2018 @08:18AM (#17586373)

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.

[ Parent | on HN ]