X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B8CBB52932 for ; Thu, 9 Jun 2005 10:35:33 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83182-05 for ; Thu, 9 Jun 2005 13:35:25 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201]) by svr1.postgresql.org (Postfix) with ESMTP id 6C9625280A for ; Thu, 9 Jun 2005 10:35:24 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 68so130058wra for ; Thu, 09 Jun 2005 06:35:29 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=Bq7ILTxWk7HQbUEe+vRag5scmcqtUKfUk9ydO2EZg9OeeDsI7vT9EvpCfN5LDZ/AmVGFLaOVckndeoZa5dLAHv2+oUmbnrTYpOMGjTtOt0DrEs0djJmCnYMN0LysmM/0PMV0CkijqOuuq2fR83aeKx6nKLzDaHNKA84YYmZhUEU= Received: by 10.54.94.3 with SMTP id r3mr370931wrb; Thu, 09 Jun 2005 06:35:29 -0700 (PDT) Received: by 10.54.2.45 with HTTP; Thu, 9 Jun 2005 06:35:29 -0700 (PDT) Message-ID: <4a0cafe2050609063557b4dcce@mail.gmail.com> Date: Thu, 9 Jun 2005 08:35:29 -0500 From: Josh Close Reply-To: Josh Close To: POSTGRES-PERFORMANCE Subject: Re: [Npgsql-general] index out of range In-Reply-To: <20050608204401.18205.qmail@web60713.mail.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <4a0cafe20506080631124b3162@mail.gmail.com> <20050608204401.18205.qmail@web60713.mail.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.117 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200506/211 X-Sequence-Number: 12848 On 6/8/05, Francisco Figueiredo Jr. wrote: >=20 > --- Josh Close escreveu: >=20 > > Well, that would make total sense. I was kinda curious how the data > > provider differentianted between :a and casting like now()::text. > > >=20 > Hi Josh! >=20 > Npgsql uses the info found in NpgsqlCommand.Parameters collection. We do = check > if a parameter in Parameters collection isn't found in query string. The = other > way around isn't done yet. So, you can safely put something like: :a::tex= t and > it will send the text 5::text for example. >=20 > I hope it helps. Yes, that does help. Thanks. -Josh