Re: Example code Re: Singleton SELECT inside cursor loop - Mailing list pgsql-general

From Ron
Subject Re: Example code Re: Singleton SELECT inside cursor loop
Date
Msg-id f8f50eb5-28d2-25d9-aa0a-eed150f17aad@gmail.com
Whole thread Raw
In response to Re: Example code Re: Singleton SELECT inside cursor loop  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List pgsql-general
On 10/1/22 07:20, Peter J. Holzer wrote:
> On 2022-10-01 02:22:22 -0500, Ron wrote:
>> I extracted the singleton into a function, and that helped me isolate the
>> problem.
> I don't know what a singleton select is (duckduckgo tells me it has
> something to do with DB2 and/or COBOL, or maybe it's a whisky), but:

A query which returns one row.  Typically SELECT COUNT/MAX/etc without a 
GROUP BY clause.

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Names of run-time configuration parameters (was: Limiting the operations that client-side code can perform upon its database backend's artifacts)
Next
From: Ron
Date:
Subject: Re: Example code Re: Singleton SELECT inside cursor loop