Re: [GENERAL] Guarenteeing ordering constraints

2007-02-22 Thread Joris Dobbelsteen
>-Original Message- >From: Tom Lane [mailto:[EMAIL PROTECTED] >Sent: donderdag 22 februari 2007 17:16 >To: Joris Dobbelsteen >Cc: pgsql-general@postgresql.org >Subject: Re: [GENERAL] Guarenteeing ordering constraints > >"Joris Dobbelsteen" <[EMA

Re: [GENERAL] Guarenteeing ordering constraints

2007-02-22 Thread Tom Lane
"Joris Dobbelsteen" <[EMAIL PROTECTED]> writes: > I have some trouble guarenteeing that an ordering constraint is enforced > on the database. On the table ordering (see below) I want to enforce > that for every tuple t, all tuples u where u.position < t.position this > implies u.cumvalue <= t.cumva

Re: [GENERAL] Guarenteeing ordering constraints

2007-02-22 Thread Joris Dobbelsteen
Even this can be violated. Just create another table and change the first select statement of the transactions to get data from that table. Is there any way to actually enforce such ordering constraints under postgresql? - Joris >-Original Message- >From: [EMAIL PROTECTED] >[mailto:[EMA