Re: Enhancement Request

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hi Ron,

I appreciate asking this question.   For me, it is a complex question and it is an evolving idea.

When we use LIMIT clause in the SQL, SQL may be used in with / without ORDER of ASC / DESC,  UUID, Pseudo columns, ROWNUM, etc clauses.  When we use ORDER by,  LIMIT may be ok to DELETE but in the ROWNUM, other pseudo columns presence impact is hard to foresee.

In the DELETE statement, there may be WHERE conditions.  It is likely to complicate. If it is a simple DELETE statement with just LIMIT clause, it is hard to foresee and likely to complicate. Without a ORDER BY clause in the SQL, LIMIT will complicate the scenario.

 You may collect the opinion from few others and make a decision on this.

Thanks,

Sarwar

---

From: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Sent: Wednesday, January 31, 2024 8:31 PM
To: pgsql-admin@xxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxx>
Subject: Re: Enhancement Request

 

On Wed, Jan 31, 2024 at 3:55 PM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

If they allow DELETE FROM-LIMT to work, it is going to harm  the general interest of the database.

In my opinion, that should not be implemented.

Why would it harm the general interest of the database? 

What even does "the general interest of the database" mean?