Search Postgresql Archives

Trying to update a box data type column

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux