PostgreSQL script error

Question

I am getting this error. Why?

CREATE OR REPLACE FUNCTION factuurRegel()
RETURNS TRIGGER AS 
$$

BEGIN
INSERT INTO Factuur(factuurnr, factuurdatum, bestelnr)
VALUES ((default to_char(CURRENT_DATE ,'yyyy') || '-' || new.bestelnr), CURRENT_DATE, new.bestelnr);
RETURN NEW;
END;
$$
LANGUAGE plpgsql;

Error:

    ERROR:  syntax error at or near "default"
LINE 7: VALUES ((default to_char(CURRENT_DATE ,'yyyy') || '-' || new...
                 ^
********** Error **********

ERROR: syntax error at or near "default"
SQL state: 42601
Character: 137

Erwin Brandstetter · Accepted Answer · 2013-12-09 20:44:51Z

2

I'm not a postgresql guy, but I'm 99% sure you can't put default inside VALUES() and also include a value there. I think you want this:

CREATE OR REPLACE FUNCTION factuurRegel()
RETURNS TRIGGER AS 
$$

BEGIN
INSERT INTO Factuur(factuurnr, factuurdatum, bestelnr)
VALUES ((to_char(CURRENT_DATE ,'yyyy') || '-' || new.bestelnr), CURRENT_DATE, new.bestelnr);
RETURN NEW;
END;
$$
LANGUAGE plpgsql;

See here for more info - you can include DEFAULT as a value or provide a value, but not both.

edited Dec 9, 2013 at 20:44

Erwin Brandstetter

668k159 gold badges1.2k silver badges1.3k bronze badges

answered Dec 9, 2013 at 19:50

elixenide

44.9k16 gold badges79 silver badges103 bronze badges

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

3 Comments

MOTIVECODEX Over a year ago

Worked thanks, will accept soon. I am also not into postgresql. Straight from hell if you ask me. But we have to use this for our project at the moment.

elixenide Over a year ago

@ErwinBrandstetter: that's what I thought at first, too. Scroll right; there are three total.

Erwin Brandstetter Over a year ago

@EdCottrell: Ah, I see now, sorry. Took the liberty to remove some white space and removed my misguided comment. Well, and fixed the link to point to the current manual. 8.2 is rather outdated.

Collectives™ on Stack Overflow

PostgreSQL script error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related