Create the gist index on table containing points using the following syntax:
CREATE INDEX ON USING GIST ();
After the index is created use the criteria st_contains(polygon,point) in the
where clause of select statement:
Select * from where st_contains(polygon, point) ;
Regards,
Kedar
trings to pass in.
--
Thanks & Regards
Kedar Parikh
Netcore Solutions Pvt. Ltd.
Tel: +91 (22) 6662 8135
Mob: +91 9819634734
Email: ke...@netcore.co.in
Web: www.netcore.co.in
es('B',20);
INSERT INTO temp values('B',20);
select * from temp;
text | id
--+
A| 10
A| 10
B| 20
B| 20
B| 20
select text,id, count(1) from temp group by 1,2;
text | id | count
--++---
A| 10 | 2
B| 20 | 3
and
