| From: | wsheldah(at)lexmark(dot)com |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | box function implemented? |
| Date: | 2003-04-30 22:04:03 |
| Message-ID: | OF13E19A23.DC520254-ON85256D18.0078B4F9@lexmark.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I think I found a glitch either in the box function or in the docs for
postgresql 7.3.2. The online docs say that the box function can find the
intersection box between two boxes. I created a table that looks like this:
CREATE TABLE boxtest (id serial primary key, b1 box, b2 box);
and inserted a row with boxes for b1 and b2. All seemed great. But when I
try:
SELECT box(b1, b2) from boxtest;
I get this error:
Function box(box, box) does not exist
Followed by a couple more lines suggesting I use typecasts. But the docs at
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=functions-geometry.html
give exactly that prototype for the box function.
Having said all that, I have to say that postgresql's geometry functions
are fantastic. I just came up with my first need for them, and it looks
like they're going to really save me from writing a chunk of code and speed
things up. Thanks!
Wes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dragan Matic | 2003-04-30 22:26:33 | why don't string function work in WHERE clause? |
| Previous Message | Joshua Drake | 2003-04-30 21:39:48 | Re: Upgrade to RedHat 9.0 broke PostgreSQL |