Re: Enhancement Request

Поиск
Список
Период
Сортировка
От M Sarwar
Тема Re: Enhancement Request
Дата
Msg-id DM4PR19MB5978ACC9AC9216F5A2AFAC3AD3422@DM4PR19MB5978.namprd19.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Enhancement Request  (Ron Johnson <ronljohnsonjr@gmail.com>)
Ответы Re: Enhancement Request
Список pgsql-admin
Дерево обсуждения
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@gmail.com>
Sent: Wednesday, January 31, 2024 8:31 PM
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Enhancement Request
 
On Wed, Jan 31, 2024 at 3:55 PM M Sarwar <sarwarmd02@outlook.com> 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?

В списке pgsql-admin по дате отправления: