Re: [GENERAL] Update Query Problem

2008-10-10 Thread A. Kretschmer
am Fri, dem 10.10.2008, um 12:38:24 +0100 mailte Jeng Yu folgendes: > Hi People! > > I'm doing an application and I've chosen postgresql > for the backend db. I need to use SQL update command > like this in my application: > > update mytable set x='20' where id='someid' order by > id limit 1;

[GENERAL] Update Query Problem

2008-10-10 Thread Jeng Yu
Hi People! I'm doing an application and I've chosen postgresql for the backend db. I need to use SQL update command like this in my application: update mytable set x='20' where id='someid' order by id limit 1; In other words, I want to update just one row of the table if there are more than one