Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6EADE2E45D8 for ; Tue, 5 Feb 2008 15:46:48 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 73854-02-7 for ; Tue, 5 Feb 2008 15:46:37 -0400 (AST) Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.226]) by postgresql.org (Postfix) with ESMTP id 5FACF2E4506 for ; Tue, 5 Feb 2008 15:46:33 -0400 (AST) Received: by wr-out-0506.google.com with SMTP id 71so2425125wri.5 for ; Tue, 05 Feb 2008 11:46:32 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=m13cUlWDQA6Yu9GF8pQuyk1G4GDVB8L92kDam7+c/mQ=; b=FYF10RY35yuCyK0CrMttAtmUeZ226joE9PZifYKGw43xv/Pf9/PJdmZuMZFIgOTuDOESWj6LNSLieqhxmxhe5Gkm84G8+W3gw2WjHe1/YaSS5sD+445tKIrx/NguY5o0X+qzx0ZFeGAK+uhHZL5EdiizzxjffxcJriMlhTHINKU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=m+iW8Yv8q7HPgYayvsvVMR+Xcg7O0a1KyVRPYzknAI1l5H7LCx8bAUoRxKA4v2nm1cgUFLclf7DWe6DlQ+kO7jMsEjpPPZERMlo/FXQ6ILl3jKYw3tmpWcLFNQbai1XoqI0A0+Un5x4eniDvkk01EHPZ3BtRk8oiW7c3BtMY33A= Received: by 10.115.108.1 with SMTP id k1mr1539417wam.141.1202240790623; Tue, 05 Feb 2008 11:46:30 -0800 (PST) Received: by 10.114.74.9 with HTTP; Tue, 5 Feb 2008 11:46:30 -0800 (PST) Message-ID: Date: Tue, 5 Feb 2008 14:46:30 -0500 From: "Jaime Casanova" To: "Li, Jingfa" Subject: Re: Cast in PG 8.3 Cc: "Franklin Haut" , pgsql-sql@postgresql.org In-Reply-To: <0A89F5E49BE1BD418D5113AD3BB51B41025BB17D@RHV-EXM-01.corp.ebay.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47A8B788.6010304@gmail.com> <0A89F5E49BE1BD418D5113AD3BB51B41025BB17D@RHV-EXM-01.corp.ebay.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/21 X-Sequence-Number: 30112 On Feb 5, 2008 2:39 PM, Li, Jingfa wrote: > check the typo -- "ilike" > that's not a typo, it's "case insensitive LIKE" -- regards, Jaime Casanova "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning." Richard Cook