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