--- Remo Laubacher <[EMAIL PROTECTED]> escreveu:
>
> Saturday, February 4, 2006, 6:57:43 PM, you wrote:
>
> mfnp> Hello npgsql-general!
>
> mfnp> I have a problem with Postgres functions and IN/OUT Parameters. I have
> mfnp> the following function:
>
> mfnp> create function test(IN main_id integer, OUT new_id integer, OUT info
> mfnp> varchar) ....
>
> mfnp> .. and I want to get the return values in npgsql.
>
> mfnp> Postgres creates this function as having:
> mfnp> Argument data types: integer
> mfnp> and
> mfnp> Result data type: record
>
Can you try calling it like that:
NpgsqlCommand cmd1 = new NpgsqlCommand("test",_conn);
Npgsql will check if function returns record and put the proper sintax for
calling function.
Also, do you have the exactly error postgresql returns?
I hope it helps.
--
Regards,
Francisco Figueiredo Jr.
_______________________________________________________
Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora!
http://br.acesso.yahoo.com
_______________________________________________
Npgsql-general mailing list
Npgsql-general@gborg.postgresql.org
http://gborg.postgresql.org/mailman/listinfo/npgsql-general
