Postgres query syntax error . I am querying in navicat-CodePudding

Home > Software engineering > Postgres query syntax error . I am querying in navicat

Postgres query syntax error . I am querying in navicat

Time：06-28

I try to add quotes. But it did not work:

I'm using Postgres.

Here is my query in navicat which results in syntax errors:

WITH t1 AS 
(
    SELECT
        * 
    FROM
        "olympics_history" 
)

CodePudding user response：

Yes it works like this:

WITH t1 AS 
(
    SELECT
        * 
    FROM
        "olympics_history" 
)
SELECT games 
FROM t1 
WHERE t1.season = 'Summer'

Thanks @a_horse_with_no_name