From: | Alvaro Herrera <alvherre(at)surnet(dot)cl> |
---|---|
To: | Mario Soto Cordones <msotocl(at)gmail(dot)com> |
Cc: | "pgsql-es-ayuda(at)postgresql(dot)org" <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: text2ltree |
Date: | 2005-05-24 20:18:02 |
Message-ID: | 20050524201802.GA10674@surnet.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
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)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2005-05-24 20:23:44 | Re: Llamadas a funciones en C desde postgres |
Previous Message | Roberto Cesar Najera | 2005-05-24 20:13:56 | Re: Programa de Distribucion |