Re: Error of text2ltree

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Vu Hong Thuan <thuanvh(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error of text2ltree
Date: 2010-05-29 14:46:59
Message-ID: 19086.1275144419@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Vu Hong Thuan <thuanvh(at)gmail(dot)com> writes:
> I can't use text2ltree. Any suggestion? Thanks.
> SELECT text2ltree('abc'). It's okay. But, got error if:

> SELECT text2ltree(to_char(243, '09999999'))

> ******** Error ******

> ERROR: syntax error at position 0 SQL state: 42601

I think ltree doesn't allow spaces in the input.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message erobles 2010-05-29 15:39:09 Re: there is a way to deactivate type validation on 8.3.1????
Previous Message Ashesh Vashi 2010-05-29 14:10:20 Re: [GENERAL] hi，for help!