How I create or update postgresql sequence with variable

Question

I'm tring to create or update postgresql sequence with variable

If I put exact value when I create or update sequence, It works

like create sequence test minvalue 5 maxvalue 10 start 5;

but If I create some function which set min and maxvalue of sequence like

CREATE OR REPLACE FUNCTION test(bigint, bigint)
RETURNS void AS
$BODY$
BEGIN
    create sequence test minvalue $1 maxvalue $2 start $1;
END;
$BODY$
    LANGUAGE plpgsql VOLATILE
    COST 100;

It makes errors

I'm searching to find the way to put the variable when I create sequence

who knows the way? please help.

I just want to create sequence range

Denis de Bernardy · Accepted Answer · 2013-10-21 08:27:18Z

5

You might need to use dynamic SQL, for that kind if statement.

http://www.postgresql.org/docs/current/static/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

Don't forget to quote_ident() and quote_literal() as needed.

answered Oct 21, 2013 at 8:27

Denis de Bernardy

79.1k14 gold badges138 silver badges158 bronze badges

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

Collectives™ on Stack Overflow

How I create or update postgresql sequence with variable

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