Обсуждение: add (minimal) UPDATE regression test

This patch adds a new regression test for the UPDATE command. Right
now all that is tested is Rod Taylor's recent addition to allow
this syntax:

    UPDATE ... SET <col> = DEFAULT;

If anyone else would like to add more UPDATE tests, go ahead --
I just wanted to write a test for the above functionality, and
couldn't see an existing test that it would be appropriate
to add to.

(Bruce, this patch adds 2 new files, src/test/regress/sql/update.sql
and src/test/regress/expected/update.out)

-Neil

Your patch has been added to the PostgreSQL unapplied patches list at:

    http://momjian.postgresql.org/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------


Neil Conway wrote:
> This patch adds a new regression test for the UPDATE command. Right
> now all that is tested is Rod Taylor's recent addition to allow
> this syntax:
>
>     UPDATE ... SET <col> = DEFAULT;
>
> If anyone else would like to add more UPDATE tests, go ahead --
> I just wanted to write a test for the above functionality, and
> couldn't see an existing test that it would be appropriate
> to add to.
>
> (Bruce, this patch adds 2 new files, src/test/regress/sql/update.sql
> and src/test/regress/expected/update.out)
>
> -Neil
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

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

Patch applied.  Thanks.

---------------------------------------------------------------------------


Neil Conway wrote:
> This patch adds a new regression test for the UPDATE command. Right
> now all that is tested is Rod Taylor's recent addition to allow
> this syntax:
>
>     UPDATE ... SET <col> = DEFAULT;
>
> If anyone else would like to add more UPDATE tests, go ahead --
> I just wanted to write a test for the above functionality, and
> couldn't see an existing test that it would be appropriate
> to add to.
>
> (Bruce, this patch adds 2 new files, src/test/regress/sql/update.sql
> and src/test/regress/expected/update.out)
>
> -Neil
>

[ Attachment, skipping... ]

>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org

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