[GRASSLIST:4475] Re: d.what.r.pg and OUTER JOINS in PostgreSQL

[Stephan Holl]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

At Thu, 12 Sep 2002 12:35:44 +0200 andres javier garcia garcia wrote:

Hello Javier,

> This query 
> needs OUTER JOINS, and I've made it, but there is some error, because 
> wherever I click in the raster map, all the data in the queryed tables
> are shown, not only the corresponding to the zone of concern.
perhaps you should use something like
SELECT DISTINCT <zone-of-concern-id> .....
so that only the related zone-of-concern will be fetched.

hth
 Stephan
- -- 
- --------------------------------------
Stephan Holl
GnuPG Key-ID: 11946A09
ICQ# 117277975 
- --------------------------------------
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)

iD8DBQE9gHQ7Eg9SKhGUagkRAk0MAJ9/RGQdvTWBtYD7oqJNSaPe7rhoTwCfQTdL
wwXPC2LabE2gQqSQbSXC+Cc=
=qq54
-----END PGP SIGNATURE-----