Re: [SQL] Correct implementation of 1:n relationship with n>0?

2013-05-06 Thread Achilleas Mantzios
On Ôñé 30 Áðñ 2013 20:25:42 Wolfgang Keller wrote: > > (there is nothing wrong in getting your hands dirty with pl/pgsql btw) > > The point is that I would have expected that problem to be solved > within the past four decades since relational databases have been > invented. Or at least in the pas

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