Yonatan Ben-Nes <[EMAIL PROTECTED]> writes: > I can't figure out how I can update the box column using the values at > the nleft & nright columns.
Use the provided constructor functions: regression=# select box(point(1,2),point(3,4)); box ------------- (3,4),(1,2) (1 row) As a general rule, converting something to text and back is not the way to convert data from one type to another; if it's not a really outlandish conversion, there'll be a function or cast to help. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend