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

#1

Post by MarkusWinand » Fri, Jul 20, 2018, 9:00 AM UTC

How PostgreSQL’s SQL dialect stays ahead of its competitors [PDF slides]
modern-sql.com

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

#2

Post by some_user54 » Sun, Jul 22, 2018, 12:14 PM UTC

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

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

#3

Post by MarkusWinand » Sun, Jul 22, 2018, 12:18 PM UTC

some_user54 wrote: post #2

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.