Re: [SQL] Order of execution

2013-05-06 Thread Jasen Betts
On 2013-05-06, JORGE MALDONADO wrote: > --089e013d1eb83325e504dc01710d > Content-Type: text/plain; charset=ISO-8859-1 > > I have an UPDATE query which performs several opertions in one table. > > UPDATE table01 SET > field1 = (query1 may contain any field), > field2 = (query1 may contain any field

[SQL] Order of execution

2013-05-05 Thread JORGE MALDONADO
I have an UPDATE query which performs several opertions in one table. UPDATE table01 SET field1 = (query1 may contain any field), field2 = (query1 may contain any field), field3 = (query1 may contain any field) WHERE (condition) query1, query2 and query3 perform a logic to determine which records

Re: [SQL] Order of execution of rules

2004-07-12 Thread Stef
Hilary Forbes mentioned : => Can I guarantee that if I have more than one Rule on a table they will be executed in a given order? I know triggers are done alphabetically but is the same true of rules? http://www.postgresql.org/docs/7.4/static/sql-createrule.html#AEN37748 pgpgCnrDhs4Og.pgp Desc

[SQL] Order of execution of rules

2004-07-12 Thread Hilary Forbes
Can I guarantee that if I have more than one Rule on a table they will be executed in a given order? I know triggers are done alphabetically but is the same true of rules? Many thanks Hilary Hilary Forbes The DMR Information and Technology Group (www.dmr.co.uk) Direct tel 01689 889950 Fax 01689