apply limit to sum function - Mailing list pgsql-novice

From e-letter
Subject apply limit to sum function
Date
Msg-id CAET1fe7eu-Es13-Zn1oEV+nZVaQGZFa=v9w8t2JT-TditcfWRg@mail.gmail.com
Whole thread Raw
Responses Re: apply limit to sum function
List pgsql-novice
Readers,

 Is it possible to apply the 'sum' function, but limit the value and
 then show the tuples of the result? For example, the table has:

 text1, 10
 text2, 12,
 text3, 23

 Instead of applying the 'sum' function to all values, the request is
 to be able to select those values that result in a sum of a target
 value (e.g. < 22) and then return the tuples.

pgsql-novice by date:

Previous
From: Bartosz Dmytrak
Date:
Subject: Re: Returning generated id after a transaction.
Next
From: Steve Crawford
Date:
Subject: Re: apply limit to sum function