[postgis-users] Need help on basic concepts, I just need really simple calculations

[Aaron Lewis]

Hi,

I've been searching online for days. Trying to understand why SRID is
required. So I picked some random value.

Now I'm need to retrieve POINTs within a circle range, e.g a circle at
(146.0, 138.19) with radius of 100 meters:

SELECT * FROM users
WHERE ST_DWithin (users.location, st_setsrid(st_makepoint (146.0,
138.19), 2600), 100);

It's very simple, but the result seems wrong. I have a record contains
a POINT(55 43) that matches this query.

Anyone know what's wrong with it?

-- 
Best Regards,
Aaron Lewis - PGP: 0x13714D33 - http://pgp.mit.edu/
Finger Print:   9F67 391B B770 8FF6 99DC  D92D 87F6 2602 1371 4D33