So having two signatures like the following is valid: CREATE OR REPLACE schema_name.function_name(param_a TEXT). Depending on what type is passed from the client, Postgres will choose the right function. One of them is the REPLACE () method that can be used to replace the substring from the original string to some other substring that you wish to. PostgreSQL provides us with many string manipulating functions. There is no inherent problem with having different parameter types in a function signature with the same arity. When we manipulate strings or work with strings in PostgreSQL, we require many functions to perform operations. DROP FUNCTION IF EXISTS schema_name.function_name(VARCHAR) ĬREATE OR REPLACE FUNCTION schema_name.function_name(param_a VARCHAR, param_b INTEGER) The tactic I take in my repo is to call DROP on the old function signature right before the new function definition.

So, if you want to get rid of a function that has the same name but a different signature than the one you're trying to CREATE OR REPLACE, you need to use DROP FUNCTION IF EXISTS schema_name.function_name(param_a VARCHAR). postgresql replace string-manipulation Share Improve this question Follow edited at 0:53 Erwin Brandstetter 163k 22 406 551 asked at 14:39 Landon Statis 141 1 3 Add a comment 2 Answers Sorted by: 3 Do the space-to-underscore replace () first, and your existing expression will do the rest. However, you're correct that Postgres will allow for overloaded functions. To search and replace all occurrences of a string with a new one, you use the REPLACE () function. Next, specify the datatype of the returned value after the returns keyword. PostgreSQL REPLACE function Sometimes, you want to search and replace a string in a column with a new one such as replacing outdated phone numbers, broken URLs, and spelling mistakes. A function can have zero or many parameters. Then, specify the function parameter list surrounded by parentheses after the function name. You can use CREATE OR REPLACE schema_name.function_name(param_a VARCHAR, param_b TEXT). If you want to replace the existing function, you can use the or replace keywords.

Postgresql replace