Can someone tell me why this works in MySQL but not PostgreSQL?
select "hi" as ham, 1 as eggs
I'm trying to union a query with some hard-coded values.
Postgres says "ERROR: column "hi" does not exist Position: 8"
MySQL says the right thing.
3 Answers
you need to change the " to ' double qoute to single qoute in postgress
select 'hi' as ham, 1 as eggs
4 Comments
offwhitelotus
that works, thanks. i'll accept this answer in 11 minutes when I'm allowed ;)
offwhitelotus
is there any deep reason for this, or just arbirary syntactical design decision?
HuntsMan
double quotes are used to name an identifier without changing its case like you want to create table CREATE TABLE "Sample" something like that
You need to use single quote, not double quote.
Select 'hi' as ham;
Comments
If you want to let hi be row value you need to use single-qoute otherwise PostgreSQL DB Engine will take it as a column.
This sample ORDER is a keyword but I can use double-qoute to escape the keyword as column name, although I didn't encourage use keyword as a column name.
CREATE TABLE T("ORDER" INT);
INSERT INTO T VALUES (1);
SELECT "ORDER"
FROM T
so you might use like this.
select 'hi' as ham, 1 as eggs
single quoteinsteaddouble quote..Postgresqlknowhias column not string..