Re: [SQL] Fwd: conditional rule not applied

2010-01-07 Thread Seb
On Thu, 07 Jan 2010 16:31:29 +0100, Leo Mannhart wrote: [...] > I can give a 'first cut' solution. But I strongly discourage from > doing this in a real world application as chances are big, that you'll > forget something to implement correctly (nullable fields come to mind > immediately as an

Re: [SQL] Fwd: conditional rule not applied

2010-01-07 Thread Leo Mannhart
Seb wrote: > Hi, > > Apologies for posting this from postgresql.general, but this failed to > get any follow-ups in that NG. Hopefully someone here can shed some > light on this. [snip] I can give a 'first cut' solution. But I strongly discourage from doing this in a real world application as c

Re: [SQL] Fwd: conditional rule not applied

2010-01-06 Thread Seb
On Wed, 6 Jan 2010 13:01:02 -0800, Richard Broersma wrote: > On Wed, Jan 6, 2010 at 12:40 PM, Seb wrote: >> I'm trying to create a rule to be applied on update to a view that >> consists of two joined tables.  Table 'shoes' below is left-joined >> with table 'shoelaces' in the view 'footwear'.  

Re: [SQL] Fwd: conditional rule not applied

2010-01-06 Thread Richard Broersma
On Wed, Jan 6, 2010 at 12:40 PM, Seb wrote: > I'm trying to create a rule to be applied on update to a view that > consists of two joined tables.  Table 'shoes' below is left-joined with > table 'shoelaces' in the view 'footwear'.  I'd like to create a simple > update rule on the view, only if th

[SQL] Fwd: conditional rule not applied

2010-01-06 Thread Seb
Hi, Apologies for posting this from postgresql.general, but this failed to get any follow-ups in that NG. Hopefully someone here can shed some light on this. --- Begin Message --- Topics: conditional rule not applied Re: conditional rule not applied Re: conditional rule not applied