At 15:28 27/10/00 +0900, Ken Smith wrote:
>
>Which behavior is the correct?
>
To quote from the stanard:
"Each is effectively evaluated for the current
row before any of the current row's object rows is updated"
So I'd say MySQL is wrong.
-
> THE TEST
> Run 'psql', then enter the following except for the select statement
> output.
>
> ---BEGIN---
> create table test (name char, a int, b int);
> insert into test values ('x', 1, 2);
> select * from test;
> update test set a=3,b=a where name='x';
> insert into test values ('y', 1, 2);
Ken Smith <[EMAIL PROTECTED]> writes:
> create table test (name char, a int, b int);
> insert into test values ('x', 1, 2);
> update test set a=3,b=a where name='x';
> select * from test;
> name | a | b
> --+---+---
> x| 3 | 1
This is correct ...
> I am used to MySQL so I expected the
