deciding on one of multiple results returned - Mailing list pgsql-sql

From Wes James
Subject deciding on one of multiple results returned
Date
Msg-id CAFjCMHvbeLHRCMZJYd_ZXAEf1c_XdEsRwUth7x+LKzWCTPi0pw@mail.gmail.com
Whole thread Raw
Responses Re: deciding on one of multiple results returned  ("David Johnston" <polobo@yahoo.com>)
Re: deciding on one of multiple results returned  (Seth Gordon <sethg@ropine.com>)
List pgsql-sql
If a query returns, say the following results:<br /><br />id   value<br />0      a<br />0      b<br />0      c<br
/>1     a<br />1      b<br /><br /><br /><br />How do I just choose a preferred element say value 'a' over any other
elementsreturned, that is the value returned is from a subquery to a larger query?<br /><br />Thanks.<br /> 

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Load UTF8@psql into latin1@mysql through JDBC
Next
From: "David Johnston"
Date:
Subject: Re: deciding on one of multiple results returned