What is the correct way to do a subquery?

Question

PostgreSQL

ERROR: ERROR: subquery in expression returned more than one row
Limit 1 not needed

select (select name from citi where zip_code = t.ship ) from town t

Answer 1

(LEFT) JOIN
If you want to return more than one row, return them as an array of JSONs, for example