pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16116: function lpad(integer, integer, integer) does not exist
2+ messages / 2 participants
[nested] [flat]

* BUG #16116: function lpad(integer, integer, integer) does not exist
@ 2019-11-15 06:14 PG Bug reporting form <noreply@postgresql.org>
  2019-11-15 06:36 ` Re: BUG #16116: function lpad(integer, integer, integer) does not exist Pavel Stehule <pavel.stehule@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2019-11-15 06:14 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: vjingle143@gmail.com

The following bug has been logged on the website:

Bug reference:      16116
Logged by:          vijay ingle
Email address:      vjingle143@gmail.com
PostgreSQL version: 11.4
Operating system:   Linux
Description:        

Hi,
We are getting an error function lpad does not exists.
I had created one project on community version (PostgreSQL 11.4 on
x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
4.8.5-36), 64-bit) which is successfully running , all procedures and
functions run successfully. 
Now i had created one more project having same version on same server also
and migrated all source code of my existing project including (tables, seq,
index, procedure, functions) means created replica of existing project but
whenever i tired to run my procedure then getting an error.



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16116: function lpad(integer, integer, integer) does not exist
  2019-11-15 06:14 BUG #16116: function lpad(integer, integer, integer) does not exist PG Bug reporting form <noreply@postgresql.org>
@ 2019-11-15 06:36 ` Pavel Stehule <pavel.stehule@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Pavel Stehule @ 2019-11-15 06:36 UTC (permalink / raw)
  To: vjingle143@gmail.com, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

Hi

pá 15. 11. 2019 v 7:15 odesílatel PG Bug reporting form <
noreply@postgresql.org> napsal:

> The following bug has been logged on the website:
>
> Bug reference:      16116
> Logged by:          vijay ingle
> Email address:      vjingle143@gmail.com
> PostgreSQL version: 11.4
> Operating system:   Linux
> Description:
>
> Hi,
> We are getting an error function lpad does not exists.
> I had created one project on community version (PostgreSQL 11.4 on
> x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat
> 4.8.5-36), 64-bit) which is successfully running , all procedures and
> functions run successfully.
> Now i had created one more project having same version on same server also
> and migrated all source code of my existing project including (tables, seq,
> index, procedure, functions) means created replica of existing project but
> whenever i tired to run my procedure then getting an error.
>
>
What I know, the lpad function newer exists for int type. So if it exists
somewhere, probably it is user function, or there was allowed implicit
casting from int to text

If you want to use buildin function, you should to use explicit casts (or
install orafce extension, that supports it)

postgres=# select lpad(10::text, 10, 0::text);
┌────────────┐
│    lpad    │
╞════════════╡
│ 0000000010 │
└────────────┘
(1 row)

Regards

Pavel

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2019-11-15 06:36 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-11-15 06:14 BUG #16116: function lpad(integer, integer, integer) does not exist PG Bug reporting form <noreply@postgresql.org>
2019-11-15 06:36 ` Pavel Stehule <pavel.stehule@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox