HI,
thanks, thanks Carla, your solution is OK :-) (i`m using PostgreSQL
8.2, so Pavel is right).
Ivan
On 21 July 2011 18:28, Carla wrote:
> Hmm, I'm using PostgreSQL 8.4 and it worked.
> Try to use the function ltree2text instead of ::text.
> select * from comments where article_id = 2 order by
2011/7/21 Carla :
> Hmm, I'm using PostgreSQL 8.4 and it worked.
> Try to use the function ltree2text instead of ::text.
> select * from comments where article_id = 2 order by
> cast(string_to_array(ltree2text(path),'.') as integer[]);
>
this does not work in older versions
you can use http://www
Hmm, I'm using PostgreSQL 8.4 and it worked.
Try to use the function ltree2text instead of ::text.
select * from comments where article_id = 2 order by
cast(string_to_array(ltree2text(path),'.') as integer[]);
2011/7/21 Ivan Polak
> hi, thank you, but there is error:
>
> ERROR: cannot cast type
hi, thank you, but there is error:
ERROR: cannot cast type ltree to text
LINE 1: ... article_id = 2 order by string_to_array(path::text,'.'):...
Ivan
On 21 July 2011 17:25, Carla wrote:
> Try it:
> select * from comments where article_id = 2 order by
> string_to_array(path::text,'.')::integer[
Try it:
select * from comments where article_id = 2 order by
string_to_array(path::text,'.')::integer[];
2011/7/21 Ivan Polak
> Hi, thank you for your answer, please can You send me complete select
> command how to convert ltree column to integer[] and use it to order
> by.
>
> thanks
>
> Ivan
>
Hi, thank you for your answer, please can You send me complete select
command how to convert ltree column to integer[] and use it to order
by.
thanks
Ivan
2011/7/21 pasman pasmański :
> Hi.
>
> You should convert path to integer[].
>
> 2011/7/20, Ivan Polak :
>> Hi,
>>
>> in postgreSQL (with LTR
Hi.
You should convert path to integer[].
2011/7/20, Ivan Polak :
> Hi,
>
> in postgreSQL (with LTREE extension) database I have the following
> table "comments":
>
> id BIGINT /* id */
> article_id BIGINT /*article-id */
> parent_id BIGINT
> comment TEXT
> path LTREE
> level INTEGER /* level */
Hi,
in postgreSQL (with LTREE extension) database I have the following
table "comments":
id BIGINT /* id */
article_id BIGINT /*article-id */
parent_id BIGINT
comment TEXT
path LTREE
level INTEGER /* level */
with the following rows:
id article_id comment parent_id path level
1 1 1 1
2 1 b
