Skip to content

Query error when using reserved words as column names #78

Description

@mirceaalexandru

I am trying to sort by "when" column - that is created by seneca-user.

The resulting query is something like this:

# SELECT * FROM sys_login ORDER BY when DESC;
ERROR:  syntax error at or near "when"
LINE 1: SELECT * FROM sys_login ORDER BY when DESC;

the following query is running correctly:

# SELECT * FROM sys_login ORDER BY "when" DESC;

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions