Re: How to use views&rules to dynamically choose which table to update - Mailing list pgsql-general

From Ashley Moran
Subject Re: How to use views&rules to dynamically choose which table to update
Date
Msg-id 18D2384E-0814-498D-B800-4517444B436C@ashleymoran.me.uk
Whole thread Raw
In response to Re: How to use views&rules to dynamically choose which  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
On Apr 01, 2006, at 12:57 am, Stephan Szabo wrote:

> What should it do if you try to insert something that is neither
> french
> nor english? I think an unconditional instead nothing rule might work
> to supplement the two conditional ones if doing nothing is okay, but I
> haven't tried.


Wahey!  The empty unconditional insert fixed it.  I never cease to be
amazed with the stuff postgres can do when it's properly trained.

If the data is not english or french, (or in the real case, a car,
van or bike etc) it's garbage and can be discarded, so I'm happy with
this.  It will only used for internal testing anyway.

Thank you both for your time reading my very cryptic question :)

Ashley

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: How to use views&rules to dynamically choose which
Next
From: "chris smith"
Date:
Subject: Re: about partitioning