Re: Filtering a bunch of records to one after a selection has returned a bunch of them

From: Nevermind <never(at)nevermind(dot)kiev(dot)ua>
To: Joe <jfc100(at)btopenworld(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Filtering a bunch of records to one after a selection has returned a bunch of them
Date: 2002-01-03 14:46:26
Message-ID: 20020103164626.A32772@nevermind.kiev.ua
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello, Joe!

On Thu, Dec 27, 2001 at 07:01:16AM -0800, you wrote:

> I am trying to establish whether or not it is possible - and how to
> implement the solution - to execute an sql statement and restricting
> the results to a single match even though there may be more than a
> single record which matches the criteria.
>
> e.g. select min(counter) from my_table butonlyone;
select min(counter) from my_table limit 1;

--
NEVE-RIPE

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave VanAuken 2002-01-03 14:54:35 update after select doesn't update...
Previous Message Jules Alberts 2002-01-03 12:05:43 Re: tool for synchronizing databases