Thread: Re: [Npgsql-general] index out of range

Re: [Npgsql-general] index out of range

From
Josh Close
Date:
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