When grilled further on (Mon, 09 Feb 2004 13:49:17 +),
Mark Gibson <[EMAIL PROTECTED]> confessed:
> I probably didn't make this clear enough:
>
Nah. After re-reading your e-mail, I say what I missed the first time. 'Bout 1
hour before my normal thinking time...
Cheers,
Rob
--
20:20:54
Tom Lane wrote:
Mark Gibson <[EMAIL PROTECTED]> writes:
CREATE RULE bag_rel AS ON INSERT TO bag_test
WHERE
EXISTS (SELECT 1 FROM bag_test WHERE item = NEW.item)
DO INSTEAD
UPDATE bag_test SET qty = qty + NEW.qty WHERE item = NEW.item;
This can't work because an ON INSERT r
Richard Sydney-Smith wrote:
Mark,
love the idea, guess I should have read it somewhere but haven't. Obvious
and beautiful. Please let me know if you or someone else solves the initial
double value.
I used to use functions for this kind of thing,
and was thinking that what SQL really needed was
Mark Gibson <[EMAIL PROTECTED]> writes:
> Alternatively, for the relative option (increase 'apple' by 12), replace
> the 'bag_abs' rule with:
> CREATE RULE bag_rel AS ON INSERT TO bag_test
> WHERE
> EXISTS (SELECT 1 FROM bag_test WHERE item = NEW.item)
> DO INSTEAD
> UPDATE
Mark,
love the idea, guess I should have read it somewhere but haven't. Obvious
and beautiful. Please let me know if you or someone else solves the initial
double value.
Got me thinking of all the places I cold have used this instead of coding
select/insert/update/delete.
Also have you worked a s
Robert Creager wrote:
When grilled further on (Mon, 09 Feb 2004 12:42:10 +),
Mark Gibson <[EMAIL PROTECTED]> confessed:
CREATE RULE bag_abs AS ON INSERT TO bag_test
WHERE
EXISTS (SELECT 1 FROM bag_test WHERE item = NEW.item)
DO INSTEAD
UPDATE bag_test SET qty = NEW.qty WHER
