Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Christopher Browne
[EMAIL PROTECTED] (Andrew Sullivan) wrote: > On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote: >> >> Do *any* databases implement SQL standard Assertions? > > Somebody must've had an implementation, or it'd never have made it > into the spec ;-) Supposedly, RDB had this feature... O

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Andrew Sullivan
On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote: > > Do *any* databases implement SQL standard Assertions? Somebody must've had an implementation, or it'd never have made it into the spec ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting o

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Gregory Stark
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Well, it's on the SQL standard, so we should look forward to > implementing (some form of) it some day. Do *any* databases implement SQL standard Assertions? -- greg ---(end of broadcast)--- TIP 5: do

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-28 Thread Alvaro Herrera
Andrew Sullivan wrote: > On Sun, Aug 27, 2006 at 07:39:49AM -0700, Richard Broersma Jr wrote: > > > Ah, I see. So the points is that checking the integrity between > > two complete data sets can become a preformace killer. > > Not necessarily. More exactly, building a support system that can >

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-28 Thread Andrew Sullivan
On Sun, Aug 27, 2006 at 07:39:49AM -0700, Richard Broersma Jr wrote: > Ah, I see. So the points is that checking the integrity between > two complete data sets can become a preformace killer. Not necessarily. More exactly, building a support system that can check such integrity in a completely

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-27 Thread Richard Broersma Jr
> You can accomplish what assertions do using triggers. > I think the issue is generating triggers for general assertions that don't > totally suck performancewise. Ah, I see. So the points is that checking the integrity between two complete data sets can become a preformace killer. Thanks for

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-27 Thread Bruno Wolff III
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 Postgr

[SQL] Create Assertion -- Question from a newbie

2006-08-27 Thread Richard Broersma Jr
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