Re: [GENERAL] Problem merging two rows into same primary key

2005-05-25 Thread Andrus
"Patrik Kudo" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hi and thanks for your reply! > > Martijn van Oosterhout wrote: >>>Now to the problem. We want to merge rows with id = 2 and id = 4 into id >>>= 1 in the asdf table with the qwert table beeing updated to reflect the >>>ch

Re: [GENERAL] Problem merging two rows into same primary key

2005-05-24 Thread Patrik Kudo
Hi and thanks for your reply! Martijn van Oosterhout wrote: Now to the problem. We want to merge rows with id = 2 and id = 4 into id = 1 in the asdf table with the qwert table beeing updated to reflect the change. The desired result would yeild: Why doesn't: update quert set data = 1 where d

Re: [GENERAL] Problem merging two rows into same primary key

2005-05-23 Thread Martijn van Oosterhout
On Mon, May 23, 2005 at 04:40:12PM +0200, Patrik Kudo wrote: > Hi! > > I've got a problem I can't seem to find an answer to. The problem is > simplified by this example: > > 1. We have two tables: > > create table asdf (id serial primary key, > data text); > create table qwert (id serial, > data