Home > mailing lists

OR problems - Mailing list pgsql-general

From	tony
Subject	OR problems
Date	March 22, 2002 14:47:13
Msg-id	1016815628.8711.109.camel@vaio Whole thread Raw
List	pgsql-general

Tree view

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

pgsql-general by date:

From: pgsql-gen Newsgroup (@Basebeans.com)
Date: 22 March 2002, 14:40:13
Subject: cannot login into postgresql server

From: Serkan Bektaş
Date: 22 March 2002, 14:56:23
Subject: Re: pg_hba.conf errors

OR problems - Mailing list pgsql-general

Previous

Next