Re: Error trigger

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
>