Problem while creating a Left function in PostgreSQL

Question

I am trying to create a Left function in PostgreSQL as under

CREATE OR REPLACE FUNCTION LEFT(text, integer) RETURNS text 
    AS  'SELECT SUBSTR($1,$2);'
    LANGUAGE SQL IMMUTABLE;

It got compiled fine. Now when I am invoking it as under

select LEFT(',a,b,c',2)

I am getting the output as ,a

when the expected output is a,b,c

If I run SELECT SUBSTR(',a,b,c' , 2) it works as expected .

Please help me out in identifying the mistake

Thanks

DavidEG · Accepted Answer · 2011-09-22 09:19:48Z

3

LEFT function already exists in pg_catalog. So try a different function name or run

SELECT public.LEFT(',a,b,c' , 2)

answered Sep 22, 2011 at 9:19

DavidEG

5,9673 gold badges33 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1