Re: [GENERAL] UPDATE/DELETE with ORDER BY and LIMIT

2010-09-28 Thread Bartlomiej Korupczynski
On Sat, 25 Sep 2010 12:32:55 +0200 Alban Hertroys wrote: > On 24 Sep 2010, at 21:20, Bartłomiej Korupczyński wrote: > > > Hi guys, > > > > I've found some posts from 2007 about UPDATE/DELETE ... LIMIT N syntax > > and I'd like to raise it again. Current PostgreSQL of UPDATE/DELETE > > implement

[GENERAL] How to handle results with column names clash

2010-09-28 Thread Bartlomiej Korupczynski
Hi, I'm curious how do you handle results from multiple tables with repeated column names. For example: # CREATE TABLE c1 (id integer PRIMARY KEY, address inet); # CREATE TABLE c2 (id integer PRIMARY KEY, address text); # SELECT * FROM c1 JOIN c2 USING (id); id | address | address +