| From: | "Edwin Quijada" <listas_quijada(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Error trigger |
| Date: | 2003-09-16 17:16:45 |
| Message-ID: | BAY1-F37ElNuqnCPPY800023da5@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I have a trigger when I executed I get this error:
WARNING: Error occurred while executing PL/pgSQL function
actualizar_pagos_comisiones
WARNING: line 19 at select into variables
ERROR: Unable to identify an operator '=' for types 'character' and
'character varying'
You will have to retype this query using an explicit cast
who varchar;
who:=cast($1 as varchar) || $2;
The line 19 is this
SELECT INTO registro * from t_pagos_comisiones where f_wholetipoagnivel =
who and f_fecha = $4;
*-------------------------------------------------------*
*-Edwin Quijada
*-Developer DataBase
*-JQ Microsistemas
*-809-747-2787
* " Si deseas lograr cosas excepcionales debes de hacer cosas fuera de lo
comun"
*-------------------------------------------------------*
_________________________________________________________________
¿Estás buscando un auto nuevo? http://www.yupimsn.com/autos/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edwin Quijada | 2003-09-16 17:32:09 | char o varchar |
| Previous Message | Nigel J. Andrews | 2003-09-16 17:08:09 | Re: after postgres upgrade - ERROR: current transaction |