Re: If it Exists... Update. If it DNE... insert.

Tables have rows and not records -- big difference. The stadnard SQl for this would be like this:

 BEGIN ATOMIC
 UPDATE Foo

    SET a = COALESCE((SELECT a

                        FROM Bar)
                       WHERE Foo.keycol = Bar.keycol), Foo.a),
        b = COALESCE((SELECT b
                        FROM Bar)
                       WHERE Foo.keycol = Bar.keycol), Foo.b),
        ...
 WHERE EXISTS(SELECT *
                FROM Bar)
               WHERE Foo.keycol = Bar.keycol); 

    FROM Bar
   WHERE Foo.keycol = Bar.keycol;
 END; The predicates in the statements will be as fast as the same predicates in a 4GL. Received on Thu Jul 12 2001 - 20:31:14 CEST