Re: Function is giving execution error from inside the procedure

[M Sarwar <sarwarmd02@xxxxxxxxxxx>]

Hi David,

You are right. 

That is confirming that I messed up the characters in the code.

Thank you,

Sarwar

---

From: David G. Johnston <david.g.johnston@xxxxxxxxx>
Sent: Friday, February 2, 2024 10:30 AM
To: M Sarwar <sarwarmd02@xxxxxxxxxxx>
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx <pgsql-admin@xxxxxxxxxxxxxxxxxxxx>
Subject: Re: Function is giving execution error from inside the procedure

 

On Fri, Feb 2, 2024 at 8:04 AM M Sarwar <sarwarmd02@xxxxxxxxxxx> wrote:

 

Error:  ERROR: function brim(character varying, unknown) does not exist LINE 2: SET WAFER_ID = BRIM(SERIAL_ID, '/')

I suspect you wanted the btrim function, not the brim function.

David J.