Gustavo escribió:
> SELECT * FROM servicio.recurso r WHERE E'C:\\\\Documents and
> Settings\\\\Gustav\\\\Escritorio\\\\TallerUML\\\\12-09\\\)
> Entrega2\\\\Software Architecture Document.doc' ~ '^'||r.full_path
>
> Respuesta:
>
> ERROR: operator does not exist: boolean || character varying
Agrega parentesis para asegurarte del orden de evaluacion:
SELECT * FROM servicio.recurso r WHERE E'C:\\\\Documents and
Settings\\\\Gustav\\\\Escritorio\\\\TallerUML\\\\12-09\\\)
Entrega2\\\\Software Architecture Document.doc' ~ ('^'||r.full_path)
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.