Hello,
I've been having some problems with this SELECT clause.
SELECT DISTINCT ON (nom, prenom) nom, prenom, sexe, titre, type,
structure.adresse, structure.boitepostal, structure.codepostal,
structure.ville
FROM individu, structure, fonction
WHERE type = 'CT' OR type = 'CA'
The DISTINCT ON bit puts the query into a flat tailspin. Why?
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html