Issue found on page 'Text Types': Double quotes section should not be here.

[rpbouman]

The https://duckdb.org/docs/sql/data_types/text page has a section about Double Quotes. This section is out of place as double quotes have nothing to do with the text type (or values of that type).

I get why it's there - as so many prog languages do use double quotes for delimiting strings/text-type values it's good to say something about that. But by giving it a separate section it suggests that double quoted "strings" are still, somehow text-type values. The sections text also doesn't explicitly say: it merely states what double quotes do do ('Double quote characters (") are used to denote table and column names. '), not what they don't do, which is relevant to this page ("Double quotes are not string delimiters").

My suggestion would be to remove this section. Instead, the section on text type values (which is currently called 'Formatting Strings') should have a line or para that first explains that double quotes are not string delimiters, but identifier delimiters, and this could have a crossreference to the documentation of identifiers, https://duckdb.org/docs/sql/keywords_and_identifiers#identifiers

Page URL: https://duckdb.org/docs/sql/data_types/text#double-quote-characters