[GENERAL] update with subquery - unexpected results

2006-02-05 Thread Niederland
I am using postgres 8.1.2 on a windows computer. My postgres.config has: add_missing_from = off In the following example, the first update sets value for v1 in table t1 to 4 for all rows. Just for my sanity, I checked the null condition in the second update, and this does not update any of the row

Re: [GENERAL] update with subquery - unexpected results

2006-02-05 Thread Andrew - Supernews
On 2006-02-05, Niederland <[EMAIL PROTECTED]> wrote: > I am using postgres 8.1.2 on a windows computer. > My postgres.config has: > add_missing_from = off > > In the following example, the first update sets value for v1 in table > t1 to 4 for all rows. > Just for my sanity, I checked the null condi