[postgis-users] Question: How to Select all Points inside a specific polygon

[Reinhold Stahlmann]

Hello,

how can I built an (OGC-conform) SQL-Query with PostGis
to select all Points of a given Point-Dataset who have their 
Geometry within a specific Polygon-Geometry chosen by a label-Field 
of the Polygon?

For example: All PostGIS-Users.name (Point-Geometry) within "Sweden"
(Polygon-Geometry)

SELECT PostGIS-Users.name
>From PostGIS-Users
WHERE Within(PostGIS-Users.geometry,(Countries.name = "Sweden").geometry) =
true
(something like this above)


Thanks for any hint

Reinhold Stahlmann