At 8:10 AM -0500 10/5/99, Ben-Nes Michael wrote:
>Is there a mail where i can sent this topic to the developers ?
They're already well aware of it, don't worry.
>Mean while ill settle with perl.
That's one of the usual solutions. You're in good company.
>Martin Ramsch wrote:
>> On Tue, 1999-10-05 13:43:13 +0200, Ben-Nes Michael wrote:
>> > Hi I wanted to do :
>> > UPDATE products SET Weight = '0.5' FROM products, rank WHERE
>> > products.code = rank.code AND category = 'bell';
>> > And got answered that its impossible and all I can do is first do a
>> > select then update the results.
>> > This is a good solution only when i mange few items, but when i get back
>> > hundreds of items its not enough.
>> Why is it 'not enough' -- does it not work for you?
>> But I agree, that it would be very good to extend the UPDATE syntax to
>> allow for joins, too!
Paul DuBois, paul@stripped