Thank you very much, i understand now :)
Paul
On Tue, Apr 12, 2011 at 4:42 PM, Kevin Grittner wrote:
> "Paul" wrote:
>
> > update cart set status = 1 where userid = (select userid from
> > users where email = 'exam...@example.com');
> >
> > As you can see, the subquery is broken (users table d
"Paul" wrote:
> update cart set status = 1 where userid = (select userid from
> users where email = 'exam...@example.com');
>
> As you can see, the subquery is broken (users table doesn't have
> the column userid).
By standard, if the identifier isn't defined within the most local
scope, each
The following bug has been logged online:
Bug reference: 5972
Logged by: Paul
Email address: paul.co...@punct.ro
PostgreSQL version: 9.0.3
Operating system: CentOS 5.5
Description:Update with subquery: erroneous results for foreign key
field
Details:
Hello.
We foun
