On Fri, Apr 27, 2007 at 09:18:59 -0600,
> The problem with this is that <def> has some duplicate entries, seve-
> ral occurrences of a row that has precisely the same column values as
> some other row in <def>, so I'm getting duplicate rows in table
> This solves my problem, but it seems to take an enormous amount of
> time to execute. Is this the best way to remove duplicate entries, or
> is there some other way?
You could try left joining abc with a subselect of abc obtained using IN.
In response to
pgsql-novice by date
|Next:||From: Fei Liu||Date: 2007-04-27 20:03:19|
|Subject: database design question, new to postgresql|
|Previous:||From: kvnsmnsn||Date: 2007-04-27 16:10:38|
|Subject: including limited lines depending on input parameter|