SELECT * FROM vocalistas JOIN canciones OF (vocalistas.id_voc = canciones.id_voc)
ERROR: error de sintaxis en o cerca de «.»
LINE 1: ...CT * FROM vocalistas JOIN canciones OF (vocalistas.id_voc = .

No entiendo el error
CREATE TABLE canciones
(
id_can serial NOT NULL,
id_voc integer,
nom_can character varying(50),
tip_can character varying(10),
CONSTRAINT id_can PRIMARY KEY (id_can ),
CONSTRAINT id_voc FOREIGN KEY (id_voc)
REFERENCES vocalistas (id_voc) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE
);
ALTER TABLE canciones
OWNER TO postgres;

CREATE TABLE vocalistas
(
id_voc serial NOT NULL,
nom_voc character varying(50),
ape_voc character varying(50),
tip_gen character varying(12),
CONSTRAINT id_voc PRIMARY KEY (id_voc )
)
WITH (
OIDS=FALSE
);
ALTER TABLE vocalistas
OWNER TO postgres;