3 ms·

Will this be part of the ANSI SQL standard?

by hbarka 4y ago

nerdponx 4y ago
This is the latest SQL Standard.
fulafel 4y ago
The ISO standard is all there is. From https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/ https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016... ''' The “ANSI Standard” for SQL There is no such thing as “ANSI Standards,” as ANSI does not develop standards. Instead, there’s American National Standards and other documents written by ANSI-approved committees of standards developing organizations. Nonetheless, we get a lot of inquiries for the “ANSI standard” for SQL. It’s worth noting that, while this phrase is misleading and inaccurate for numerous reasons, it is referring to existing standard documents. SQL, just like many great things that outlasted the 70s, has a powerful history auspiciously intertwined with standards. At the conception of SQL’s specifications was ANSI (just another great feat throughout our 100-year history). The Current Edition of ISO/IEC 9075 for SQL If you don’t want to read all the history on SQL that we’ve detailed below, to make things short, SQL was standardized in ANSI X3.135 in 1986, and, within a few months, it was adopted by ISO as ISO 9075-1987. While most vendors modify SQL to meet their needs, they generally base their programs off the current version of this standard. The international standard (now ISO/IEC 9075) has been revised periodically ever since, most recently in 2016. It exists in 9 parts: [...] '''
- paulddraper 4y ago
  > There is no such thing as American National Standards Institute standards. :/
- hbarka 4y ago
  Thank you for enlightening me with that detail. I’ve taken for granted that there is a generally standard version of SQL and the token term for it is ANSI SQL. I was in T-SQL (Microsoft), PL-SQL (Oracle), and DB2 SQL (IBM) dialects and now I feel at home with PostgreSql (ANSI SQL) which generally works across other DB platforms.

Will this be part of the ANSI SQL standard?

by hbarka 4y ago

Will this be part of the ANSI SQL standard?

nerdponx 4y ago

This is the latest SQL Standard.

fulafel 4y ago

The ISO standard is all there is. From https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/ https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016... ''' The “ANSI Standard” for SQL There is no such thing as “ANSI Standards,” as ANSI does not develop standards. Instead, there’s American National Standards and other documents written by ANSI-approved committees of standards developing organizations. Nonetheless, we get a lot of inquiries for the “ANSI standard” for SQL. It’s worth noting that, while this phrase is misleading and inaccurate for numerous reasons, it is referring to existing standard documents. SQL, just like many great things that outlasted the 70s, has a powerful history auspiciously intertwined with standards. At the conception of SQL’s specifications was ANSI (just another great feat throughout our 100-year history). The Current Edition of ISO/IEC 9075 for SQL If you don’t want to read all the history on SQL that we’ve detailed below, to make things short, SQL was standardized in ANSI X3.135 in 1986, and, within a few months, it was adopted by ISO as ISO 9075-1987. While most vendors modify SQL to meet their needs, they generally base their programs off the current version of this standard. The international standard (now ISO/IEC 9075) has been revised periodically ever since, most recently in 2016. It exists in 9 parts: [...] '''

paulddraper 4y ago
> There is no such thing as American National Standards Institute standards. :/
hbarka 4y ago
Thank you for enlightening me with that detail. I’ve taken for granted that there is a generally standard version of SQL and the token term for it is ANSI SQL. I was in T-SQL (Microsoft), PL-SQL (Oracle), and DB2 SQL (IBM) dialects and now I feel at home with PostgreSql (ANSI SQL) which generally works across other DB platforms.