Thread: 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
Attachment
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