when the backtick is required

[rocuinneagain]

This is a qSQL statement:

https://code.kx.com/q/ref/delete/

q)delete ps from x

qSQL has some differences to q.

“delete is a qSQL query template and varies from regular q syntax.”

In qSQL statements backticks are not needed for looking up columns in a table or keys in a dictionary.

These are normal q statements:

q)load `:flatT //Uses ` to declare a symbol, this case is known as a hsym, denoting a filepath as it starts with :
q)`flatT in key `. //` used to declare a symbol `flatT and also to refer to . the default namespace

• This reply was modified 3 days, 21 hours ago by  megan_mcp.
• This reply was modified 3 days, 21 hours ago by  megan_mcp.
• This reply was modified 3 days, 21 hours ago by  megan_mcp.
• This reply was modified 3 days, 21 hours ago by  rocuinneagain.
• This reply was modified 3 days, 21 hours ago by  rocuinneagain.
• This reply was modified 3 days, 21 hours ago by  rocuinneagain.

code.kx.com

delete query | Reference | kdb+ and q documentation - kdb+ and q documentation

delete is a qSQL template that removes rows or columns from a table, entries from a dictionary, or objects from a namespace.

[lestat-jin]

I see, thanks for the explanation!

[rocuinneagain]

Full qSQL docs on: https://code.kx.com/q/basics/qsql/

The 4 keywords for qSQL are:

• select https://code.kx.com/q/ref/select/
• update https://code.kx.com/q/ref/update/
• delete https://code.kx.com/q/ref/delete/
• exec https://code.kx.com/q/ref/exec/