You are missing an ON. You can fix by moving your where into the ON
SELECT sec_catch.secondary
FROM sec_catch INNER JOIN prim_catch ON st_within(sec_catch.the_geom,
prim_catch.the_geom)
I tend to spell out the type of JOIN too because I can never remember
what is the default join behavior in
On Fri, 2007-12-07 at 14:35 +0100, LuVar wrote:
Hi. I have table with points. The points reprezents my ride on bike...
table of points:
id| possition | time| trip | speed
---
0 | point| datetime | null|
Hi. I have table with points. The points reprezents my ride on bike...
table of points:
id| possition | time| trip | speed
---
0 | point| datetime | null| 12.33 km/h
The possition I insert somethink like this:
Hi again,
I managed to get this Function to compile and actually work. What I changed
were the values in the expand to pass to the functions give_source() and
give_target().
I have made a quick OpenLayers + Mapserver script so as to test the outcome
and unfortunately this function is
Kevin,
Thanks for the followup - I guess I knew the ST_ functions wrapped the
spatial queries and wasn't thinking straight - however I never did the
actual tests to see that I've probably been slowing myself down where
keep my old habits and include the in there. Interesting. Thanks!
Correct. This JOIN query is the same thing that I posted yesterday, but
using a WHERE clause instead.
Josh,
A quick note on your comment about gist indexes. I totally agree with
you that you need the operator, but now in postgis, most of the st_*
methods are simple wrappers of previous