Postgres Pro
Downloads
Home   >   mailing lists

Re: Function is giving execution error from inside the procedure - Mailing list pgsql-admin

From M Sarwar
Subject Re: Function is giving execution error from inside the procedure
Date
Msg-id DM4PR19MB5978BA709B3A7ED851634B32D3422@DM4PR19MB5978.namprd19.prod.outlook.com
Whole thread Raw
In response to Re: Function is giving execution error from inside the procedure  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com>
Sent: Friday, February 2, 2024 10:30 AM
To: M Sarwar <sarwarmd02@outlook.com>
Cc: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Function is giving execution error from inside the procedure
 
On Fri, Feb 2, 2024 at 8:04 AM M Sarwar <sarwarmd02@outlook.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.

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Function is giving execution error from inside the procedure
Next
From: Ron Johnson
Date:
Subject: Re: Enhancement Request