Re: Filtering a bunch of records to one after a selection has returned a bunch of them - Mailing list pgsql-general

From Nevermind
Subject Re: Filtering a bunch of records to one after a selection has returned a bunch of them
Date
Msg-id 20020103164626.A32772@nevermind.kiev.ua
Whole thread Raw
In response to Filtering a bunch of records to one after a selection has returned a bunch of them  (jfc100@btopenworld.com (Joe))
List 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

pgsql-general by date:

Previous
From: jfc100@btopenworld.com (Joe)
Date:
Subject: Filtering a bunch of records to one after a selection has returned a bunch of them
Next
From: "Dave VanAuken"
Date:
Subject: update after select doesn't update...