Re: [SQL] Proper case function

2010-01-06 Thread John Summerfield
Michael Gould wrote: Gary, Based on what I read it wouldn't handle cases where the result should be MacDonald from macdonald. There are other cases such as the sentence below I've looked at rationalising names in this manner before, and found that, depending on the individual, both Macdonal

[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

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

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'.