Robins and Martijn,
Thanks for the help. My main objective here was to be able to perform both
an update and an insert in one call (wanted to reduce database roundtrips,
and speed up my program), and I am using the view solely to allow me to do
this.What both of you have pointed out is th
At 07:20 AM 4/15/2008, you wrote:
Date: Mon, 14 Apr 2008 09:41:41 -0400
From: Emi Lu <[EMAIL PROTECTED]>
To: pgsql-sql@postgresql.org
Subject: export CSV file through Java JDBC
Message-ID: <[EMAIL PROTECTED]>
Good morning,
Running the following command from command line is ok, but cannot
expor
Hi,
how can I find double entries in varchar columns where the content is
not 100% identical because of a spelling error or the person considered
it "looked nicer" that way?
I'd like to identify and then merge records of e.g. 'google', 'gogle',
'guugle'
Then I want to match abbrevations
Andreas <[EMAIL PROTECTED]> writes:
> I'd like to identify and then merge records of e.g. 'google', 'gogle',
> 'guugle'
> Then I want to match abbrevations like 'A-Company Ltd.', 'a company
> ltd.', 'A-Company Limited'
> Is there a way to do this?
> It would be OK just to list candidats up
Andreas wrote:
> Hi,
>
> how can I find double entries in varchar columns where the content is
> not 100% identical because of a spelling error or the person considered
> it "looked nicer" that way?
When doing some near-duplicate elimination as part of converting a
legacy data set to PostgreSQL I
Hi,
In a recent linux magazine article (http://www.linux-mag.com/id/5679)
there was a mentioning of Full-Text Search Integration. Which I know
nothing about, but sounded interesting to me. You might want to
check it out.
Regards,
Tena Sakai
[EMAIL PROTECTED]
-Original Message-
From:
On Wed, 16 Apr 2008, Andreas <[EMAIL PROTECTED]> writes:
> how can I find double entries in varchar columns where the content is
> not 100% identical because of a spelling error or the person
> considered it "looked nicer" that way?
>
> I'd like to identify and then merge records of e.g. 'google'
