Thank you for your reply.
In my opinion, that is ugly to the point of uselessness. I think I would rather just use simple integer arithmetic.
Itwill be easier for others to understand.
RobR
-----Original Message-----
From: Merlin Moncure [mailto:mmoncure@gmail.com]
Sent: Thursday, October 17, 2013 5:58 PM
To: Rob Richardson
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] How do I create a box from fields in a table?
you have to construct the string. this is somewhat baroque by modern postgres standards but should work:
select tran_car_identification, format('((%s, 1), (2, 3))', location)::box from transfer_car;
merlin