Re: Is there any chance to get some kind of a result set sifting mechanism in Postgres?

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: aa <ghevge@gmail.com>
Cc: Wolfgang Wilhelm <wolfgang20121964@yahoo.de>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2024-05-13T18:22:06Z
Lists: pgsql-hackers
aa <ghevge@gmail.com> writes:
> If you call the action of "sifting" ordering, then yes. If you don't call
> it ordering, then no.
> In essence, is the output of a filtering mechanism, done in a single result
> set pass. And this pass should be the same pass in charge of collecting the
> result set in the first place.

Sounds a lot like a WHERE clause to me.

			regards, tom lane