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:mmonc...@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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general