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
Rob Richardson rdrichard...@rad-con.com writes:
In my opinion, that is ugly to the point of uselessness.
Indeed :-(
For some reason, there's no constructor function to make a box from four
floats. But there is a box constructor that takes two points, as well
as a point constructor that takes
On Fri, Oct 18, 2013 at 10:05 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Rob Richardson rdrichard...@rad-con.com writes:
In my opinion, that is ugly to the point of uselessness.
Indeed :-(
For some reason, there's no constructor function to make a box from four
floats. But there is a box
On Fri, 18 Oct 2013 17:05:07 +0200
Tom Lane t...@sss.pgh.pa.us wrote:
For some reason, there's no constructor function to make a box from
four floats. But there is a box constructor that takes two points,
as well as a point constructor that takes two floats; so you could do
something like
D'Arcy J.M. Cain da...@druid.net writes:
... In fact, this seems to work already if
quotes are added:
box('(0, 1), (2, 3)')
Well, that's just another spelling for a box literal, which is exactly
what the OP *doesn't* want, since he's trying to construct a box value
from non-constant
I need to determine whether a given pair of coordinates is inside a given
rectangle. According to the documentation, PostgreSQL provides the box and
point types and a contains operator that will be perfect for this. However,
the example provided in the documentation only shows the creation of
On Thu, Oct 17, 2013 at 4:04 PM, Rob Richardson
rdrichard...@rad-con.com wrote:
I need to determine whether a given pair of coordinates is inside a given
rectangle. According to the documentation, PostgreSQL provides the box and
point types and a contains operator that will be perfect for