Re: Unanswered questions about Postgre

From: Tim Kientzle <kientzle(at)acm(dot)org>
To: PostgreSQL general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Unanswered questions about Postgre
Date: 2000-12-12 01:10:22
Message-ID: 3A357AFE.FC02497D@acm.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Of course, people really shouldn't be inserting
> objects which already exist, ...

On the contrary, the best way to test if
something already exists is to just try the
INSERT and let the database tell you if
it's already there. Both faster and more
reliable than doing SELECT then INSERT.

- Tim

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-12-12 01:43:54 Re: Unanswered questions about Postgre
Previous Message Peter Eisentraut 2000-12-11 23:24:28 Re: Unanswered questions about Postgre