On 6/8/05, Francisco Figueiredo Jr. <[EMAIL PROTECTED]> wrote:
>
> --- Josh Close <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
