Re: Example code Re: Singleton SELECT inside cursor loop

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Example code Re: Singleton SELECT inside cursor loop
Date: 2022-10-01 17:13:34
Message-ID: f8f50eb5-28d2-25d9-aa0a-eed150f17aad@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

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