On Sun, Aug 27, 2006 at 00:19:59 -0700, Richard Broersma Jr <[EMAIL PROTECTED]> wrote: > Sorry if my question is a little off topic. > > I am reading my new "SQL for Smarties" book side by side with the PostgreSQL > 8.1 manual. I > noticed that this particular feature is not included in PostgreSQL. Some of > the achieve threads > mostly discuss that this feature is currently not supported. My understanding > is that Assertions > place constraints upon data spanning multiple related tables. > > Is the Assertion feature slated to be added in the future? (Perhaps rolled > up in a more > generalized "TO-DO" item?) > > Would this feature add functionality that can not be achieved by other means? > (i.e. alternative > schema definitions or triggers?) Or does it merely provide a redundant means > to constrain data, > and thereby not warrant addition into the features of PostgreSQL?
You can accomplish what assertions do using triggers. I think the issue is generating triggers for general assertions that don't totally suck performancewise. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
