Re: Bug or syntax error in my update query with a FROM statement ? - Mailing list pgsql-general

From ARP
Subject Re: Bug or syntax error in my update query with a FROM statement ?
Date
Msg-id 03b501c1eba4$48461180$0100a8c0@arp.homelinux.org
Whole thread Raw
In response to Bug or syntax error in my update query with a FROM statement ?  ("ARP" <arnaud.mlist1@free.fr>)
List pgsql-general
Thanks a lot, that's very clear for me now !
Arnaud

>It's useful to think of the behavior of UPDATE as exactly like a
>SELECT, except that rather than reporting the selected rows to you,
>it changes them per the SET target list.  Had you written
>
>select utilisateur.* from utilisateur, utilisateur a, ancien b
>where a.util_id=b.util_id and b.anc_deces is not null and
>      (a.login<>'*' or a.password<>'*');
>
>the error would be moderately obvious, no?



pgsql-general by date:

Previous
From: Benjamin Franks
Date:
Subject: group by with multiple selects having different where conditions
Next
From: tony
Date:
Subject: Re: how does NOT work?