On Aug 28, 2007, at 3:10 , Richard Huxton wrote:
> Ow Mun Heng wrote:
>> less typing per insert/update statement so it'll be where a.pkey =
>> b.pkey instead of a.key1 = b.key1 and a.key2 = b.key2
>> and ... up to key5
>
> I'd still leave it alone, but it's your database.
And you can use the row comparison syntax;
WHERE (a.key1, a.key2, a.key3, a.key4, a.key5) = (b.key1, b.key2,
b.key3, b.key4, b.key5)
which I find very convenient as it makes the composite key much
clearer than ANDed equalities.
Michael Glaesemann
grzm seespotcode net