Setting default text parameter to a PostgreSQL function causes "column doesn't exist" error

Question

I'm trying to create a function with two text parameters, second one should have a default value "en" (it is a localisation parameter).

CREATE FUNCTION nav.getpathtext_new(path text, locale text DEFAULT "en") RETURNS json AS
$BODY$DECLARE
-- function code here ...
RETURN array_to_json(_toJson);

END$BODY$
LANGUAGE plpgsql VOLATILE NOT LEAKPROOF;

And I'm getting error:

ERROR: column "en" does not exist

LINE 1: ...getpathtext_new(path text, locale text DEFAULT "en") RETU..
                            ^

PostgreSQL version is 9.4. What am I doing wrong?

Oh, silly mistake. Thanks! Could you please post this suggestion as an answer? — Alexandr Lazarev
– Alexandr Lazarev, Commented Feb 22, 2016 at 20:41

Doon · Accepted Answer · 2016-02-22 21:32:29Z

7

You need to use single quotes ' to specify text values so

CREATE FUNCTION nav.getpathtext_new(path text, locale text DEFAULT "en") RETURNS json AS

becomes

CREATE FUNCTION nav.getpathtext_new(path text, locale text DEFAULT 'en') RETURNS json AS

answered Feb 22, 2016 at 21:32

Doon

20.3k3 gold badges42 silver badges44 bronze badges

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

Collectives™ on Stack Overflow

Setting default text parameter to a PostgreSQL function causes "column doesn't exist" error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related