Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 7C2CB9FBCB7 for ; Thu, 5 Apr 2007 19:47:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 01335-05 for ; Thu, 5 Apr 2007 19:47:11 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web90609.mail.mud.yahoo.com (web90609.mail.mud.yahoo.com [216.252.100.192]) by postgresql.org (Postfix) with SMTP id 1DDC59FBB91 for ; Thu, 5 Apr 2007 19:47:11 -0300 (ADT) Received: (qmail 47983 invoked by uid 60001); 5 Apr 2007 22:47:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Pg1A/WWl71dd7+fOmoQ4+FjZmBTgijeVOXNm+RRNPm7pgs8XRLIPYg8spUBFLtd2k8FGoXqTD0T2KOo/ln/yn18FemWub0Wz4yy5BwDj0lwBL2u68AO4T7to3QrmTG+zkCaenCf3cjRIokb5bR0JIPsFxMQit1ZJRyDQT/8xiPE=; X-YMail-OSG: dCmLV9IVM1l1dCkl8nywwYJeJOzHIXcYcNa9BkHwpTn57c.68m71Rsd0V8MYiP6a_6a3sXVmpLA9QouPFfIzkhaqyHpihz68yKxg0WLiF2uKcK_jaiH1KK34juDUtQ-- Received: from [88.85.65.133] by web90609.mail.mud.yahoo.com via HTTP; Thu, 05 Apr 2007 15:47:09 PDT Date: Thu, 5 Apr 2007 15:47:09 -0700 (PDT) From: Roger Tannous Subject: Re: Insert only if not found To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <817519.46561.qm@web90609.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.756 tagged_above=0 required=5 tests=BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447 X-Spam-Level: X-Archive-Number: 200704/83 X-Sequence-Number: 28083 It's also desirable that you use TRIM along with UPPER or LOWER. Roger. ____________________________________________________________________________________ Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html