Postgres Pro
Downloads
Home   >   mailing lists

Re: Duplicate key insert question - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject Re: Duplicate key insert question
Date
Msg-id 3F022B93.8050003@mega-bucks.co.jp
Whole thread Raw
In response to Re: Duplicate key insert question  ("Maksim Likharev" <mlikharev@aurigin.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: postgresql.org is unreliable
Next
From: Alvaro Herrera
Date:
Subject: Re: Duplicate key insert question