Re: [Npgsql-general] index out of range - Mailing list pgsql-performance

From Josh Close
Subject Re: [Npgsql-general] index out of range
Date
Msg-id 4a0cafe2050609063557b4dcce@mail.gmail.com
Whole thread Raw
List pgsql-performance
On 6/8/05, Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br> wrote:
>
> --- Josh Close <narshe@gmail.com> escreveu:
>
> > Well, that would make total sense. I was kinda curious how the data
> > provider differentianted  between :a and casting like now()::text.
> >
>
> Hi Josh!
>
> 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::text and
> it will send the text 5::text for example.
>
> I hope it helps.

Yes, that does help. Thanks.

-Josh

pgsql-performance by date:

Previous
From: Richard Huxton
Date:
Subject: Re: postgresql.conf runtime statistics default
Next
From: Jona
Date:
Subject: Re: Query plan changes after pg_dump / pg_restore