CAN YOU PLEASE SOLVE MY QUERY? I AM GETTING ERRORS AGAIN AND AGAIN
Asked
Active
Viewed 15 times
0
-
Please do **not** post code as images. See here for more details why: http://meta.stackoverflow.com/questions/285551 – Jun 13 '22 at 12:21
-
Unless you have some weird Unicode characters instead of `"` there, that should work as is… – deceze Jun 13 '22 at 12:24
-
2@deceze: no it shouldn't. String constants have to be enclosed in single quotes in SQL (`'`), double quotes (`"`) are for identifiers (e.g. column names) – Jun 13 '22 at 12:25
-
https://stackoverflow.com/questions/39474081/postgres-column-x-does-not-exist – Jun 13 '22 at 12:27
-
@a_horse Right, didn't pay attention to the [tag:postgresql] tag. – deceze Jun 13 '22 at 12:28
-
@deceze: well that has nothing to do with "Postgres" - this is how it was defined in the SQL standard over 40 years ago. – Jun 13 '22 at 12:30
-
@a_horse But certain other implementations don't really care too much about it… – deceze Jun 13 '22 at 12:31
-
@deceze: it's not Postgres' fault if other implementations ignore syntax rules that are older than those implementations. – Jun 13 '22 at 12:33