Postgres mistaking value as a colum

Question

I have a section of a larger query, which we are working on converting from SQL to postgres that is giving an error of (Error: column "CEL" does not exist) and I am not sure why as CEL is a value nota column. I get the same result if I change "CEL" to CEL.

Select id, MIN(pos) as position from perphone

where personal_phone_type = "CEL"

GROUP BY id

Answer 1

"" is for quoting identifiers like columns and tables.

'' is for quoting constant values

select
  id,
  min(pos) as position
from perphone
where personal_phone_type = 'CEL'
group by id