OR problems

From: tony <tony(at)animaproductions(dot)com>
To: postgres list <pgsql-general(at)postgresql(dot)org>
Subject: OR problems
Date: 2002-03-22 16:47:08
Message-ID: 1016815628.8711.109.camel@vaio
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Serkan Bektaş 2002-03-22 16:50:32 Re: pg_hba.conf errors
Previous Message pgsql-gen Newsgroup (@Basebeans.com) 2002-03-22 16:40:02 cannot login into postgresql server