Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Rod Taylor <rbt(at)zort(dot)ca>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Larry Rosenman <ler(at)lerctr(dot)org>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Date: 2002-08-28 14:38:58
Message-ID: 200208281438.g7SEcw515550@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Rod Taylor wrote:
> > Doesn't the need for a note explaining that we're supporting the old
> > syntax say to you that the documentation also needs to say we support
> > the old syntax? I can see the bug reports now saying "this is clearly
> > not what it says in the docs"...
>
>
> Yes, both should be documented. But mark the non-preferred version as
> depreciated and disappearing soon (whether it does or not is another
> story) but discourage people from using it.

That SELECT syntax is already too confusing. I don't want to add an
additional documentation specification that provides no value to users.
One of the PostgreSQL goals is to not throw every single option at users
but to make logical decisions on tuning values and features to limit the
complexity shown to the user.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Henshall, Stuart - WCP 2002-08-28 14:40:47 Re: tell Bugtraq about 7.2.2
Previous Message Marc G. Fournier 2002-08-28 14:35:31 Re: tell Bugtraq about 7.2.2

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-08-28 14:41:16 Re: [SQL] LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1?
Previous Message Ligia Pimentel 2002-08-28 14:38:41 Re: Problems with version 7.1, could they be fixed in 7.2?