Thread: Error trigger

Error trigger

From
"Edwin Quijada"
Date:
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/


Re: Error trigger

From
Pavel Stehule
Date:
On Tue, 16 Sep 2003, Edwin Quijada wrote:

You need for all non varchar items in select cast to varchar. Try
CAST(column AS VARCHAR) or column::VARCHAR;

regards

Pavel



> 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/
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>