From: | Jaime Casanova <systemguards(at)gmail(dot)com> |
---|---|
To: | Rodrigo Barahona <rbarahona(at)maestra(dot)cl> |
Cc: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | Re: ayuda con otro procedimiento |
Date: | 2005-11-22 20:15:14 |
Message-ID: | c2d9e70e0511221215x6380207ane1c2dc6a87c7c186@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
> $sql ="SELECT insmovbodega($movimiento, $numero_documento,
> $tipo_documento,";
>
> $sql.=" $rutproveedor, $idfactura, '$fechaproveedor',
> $numero_orden, '$fechaproveedor',";
>
> $sql.=" $formapago, $estado)";
>
> echo $sql;
>
>
>
[snip]
>
> SELECT insmovbodega(1, 783, 1, 90990220, 1, '22/11/2005', 36, '22/11/2005',
> 2, 1)
> Warning: pg_query(): Query failed: ERROR: function insmovbodega(integer,
> integer, integer, integer, integer, "unknown", integer, "unknown", integer,
> integer) does not exist HINT: No function matches the given name and
> argument types. You may need to add explicit type casts. in …. on line 9
>
prueba con
$sql ="SELECT insmovbodega($movimiento, $numero_documento,
$tipo_documento,";
$sql.=" $rutproveedor, $idfactura, '$fechaproveedor'::date,
$numero_orden, '$fechaproveedor'::date,";
$sql.=" $formapago, $estado)";
o timestamp si es el caso
--
Atentamente,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
From | Date | Subject | |
---|---|---|---|
Next Message | Jaime Casanova | 2005-11-22 20:17:48 | Re: Ultimo Id |
Previous Message | Mario Gonzalez | 2005-11-22 20:13:12 | Re: Ultimo Id |