Re: text2ltree

On Tue, May 24, 2005 at 02:27:03PM -0400, Mario Soto Cordones wrote:

> el query es:
>
> select text2ltree('''' || serie || '''') from temporal
>
> el error es ERROR: syntax error at position 0 near "'"
>
> de la unica forma que funciona es
>
>
> select text2ltree('serie') from temporal;
>
> porque el cree que voy a convertir la palabra 'serie', pero yo quiero
> convertir el valor del campo serie

Hum, probaste con

select text2ltree(serie) from temporal;

--
Alvaro Herrera (<alvherre[a]surnet.cl>)
"Industry suffers from the managerial dogma that for the sake of stability
and continuity, the company should be independent of the competence of
individual employees." (E. Dijkstra)