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. It will be easier for others to understand. RobR -----Original Message----- From: Merlin Moncure [mailto:mmoncure@xxxxxxxxx] Sent: Thursday, October 17, 2013 5:58 PM To: Rob Richardson Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
