Skip site navigation (1) Skip section navigation (2)

Error of text2ltree

From: Vu Hong Thuan <thuanvh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Error of text2ltree
Date: 2010-05-29 05:02:07
Message-ID: AANLkTinFmEuZJQVHmHXG8gBS3D2j9U7UB7-IJX-7bC6m@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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

Responses

pgsql-general by date

Next:From: Anderson dos Santos DondaDate: 2010-05-29 05:04:03
Subject: Anderson dos Santos Donda wants to stay in touch on LinkedIn
Previous:From: Luis Daniel Lucio QuirozDate: 2010-05-29 03:15:37
Subject: Re: sintax error in script

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group