Error trigger

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: Raw Message | Whole Thread | 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/

Responses

Browse pgsql-general by date

  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