Trying to update a box data type column - Mailing list pgsql-general

Hi all,

I got the following table:

CREATE TABLE treecategory (
nleft INT4 NOT NULL,
nright INT4 NOT NULL,
box BOX NOT NULL
);

I can't figure out how I can update the box column using the values at
the nleft & nright columns.

For example if I try:
UPDATE treecategory SET box =
'('||"nleft"||','||"nright"||'),('||"nleft"||','||"nright"||')';
ERROR:  column "box" is of type box but expression is of type text
HINT:  You will need to rewrite or cast the expression.

And if I try to cast type text to box I get:
ERROR:  cannot cast type text to box

How can I solve this problem?

Thanks in advance,
    Ben-Nes Yonatan
    http://www.epoch.co.il