<#C0A974TJ9|ktor> <#C0CG7E0A1|exposed>
#dls
Funct...
# servera
Andrea Alberti
03/26/2024, 1:30 PM#ktor #exposed
#dls
Function selectAll() create a sql query with name column quote .
Ex.
Products.selectAll()
SELECT PRODUCTS.ID, PRODUCTS."NAME" FROM PRODUCTS
"NAME" quotes are error.
l
Leonardo Silveira
03/26/2024, 1:33 PMname might be a reserved word in the dialect therefore the quotes. those quotes are perfectly legal SQL
a
Andrea Alberti
03/26/2024, 1:34 PMPostgresql use name as reserved word?
l
Leonardo Silveira
03/26/2024, 1:38 PMlooks like it is reserved but in postgresql dialect it is not: https://www.postgresql.org/docs/current/sql-keywords-appendix.html
so, someone decided to quote reserved SQL keywords.
but would that query end up in error because the quotes? unlikely.
3 Views