> Hi all,
>
> I have to call a function implemented in Pl/Pgsql into a PostgreSQL
> database i try the syntax:
>
> set agg_query [pg_exec $db_elenco "Update campione_out set
> ultimo_accesso=$ora where prefisso=$pre and telefono=$tel"];
>
> where ora,pre e tel is variable set before the call.
>
Inserting the excape char will not work like you want it to
> I also try to insert the escape char '\':
>
> set agg_query [pg_exec $db_elenco "Update campione_out set
> ultimo_accesso=\$ora where prefisso=\$pre and telefono=\tel"];
>
> but it doesn't work!!
>
> Has anybody any suggest?
use:
pg_result $agg_query -status, and
pg_result $add_query -error to get error msgs
Note: You must escape characters like the backslash or apostropy in your
strings
ora
pre
tel
_______________________________________________
vtcl-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/vtcl-user
