Re: Function is giving execution error from inside the procedure

From: M Sarwar <sarwarmd02(at)outlook(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Function is giving execution error from inside the procedure
Date: 2024-02-02 15:53:06
Message-ID: DM4PR19MB5978BA709B3A7ED851634B32D3422@DM4PR19MB5978.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)g(dot)johnston(at)gmail(dot)com>
Sent: Friday, February 2, 2024 10:30 AM
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Function is giving execution error from inside the procedure

On Fri, Feb 2, 2024 at 8:04 AM M Sarwar <sarwarmd02(at)outlook(dot)com<mailto:sarwarmd02(at)outlook(dot)com>> 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2024-02-02 17:15:42 Re: Enhancement Request
Previous Message David G. Johnston 2024-02-02 15:30:08 Re: Function is giving execution error from inside the procedure