Re: Duplicate key insert question

From: Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp>
To: Maksim Likharev <mlikharev(at)aurigin(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Duplicate key insert question
Date: 2003-07-02 00:47:15
Message-ID: 3F022B93.8050003@mega-bucks.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Maksim Likharev wrote:
>
> Do search using IF EXISTS SELECT ... or LEFT OUTER JOIN ... WHERE ... IS
> NULL.
> works pretty fast.

Sorry, I don't understand. Works pretty fast for what?

Is that a way of finding if a value exists? or a way of doing the insertion?

Thanks,

Jean-Christian Imbeault

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dann Corbit 2003-07-02 00:47:40 Re: Duplicate key insert question
Previous Message Chris Albertson 2003-07-02 00:45:54 Re: ERROR: language "c" is not trusted