Error de operadores en postgres

[dave_river89]

Ok encontre donde se genera el error aqui te lo dejo:

Select
cast(p.valor_1 as varchar) as valor_1,
cast(p.valor_2 as varchar) as valor_2,
s.signo_vital,
s.descripcion as desc_signo,
m.medida,
m.simbolo as desc_medida,
cast(p.valor_1||' '||m.simbolo as varchar) as valor1_completo,
cast(p.valor_2||' '||m.simbolo as varchar) as valor2_completo
From
pre_cita p, signo_vital s, medida m
Where
p.signo_vital = s.signo_vital and s.medida = m.medida and p.cita = @cita@