haman...@t-online.de wrote:
> I tried this code (to be inserted within a larger psql script)
>
> do $_$
> declare
> next int;
> begin
> select max(id) + 1 into next from items;
> execute 'create temp sequence tmp_ids start $1' using next;
> end
> $_$ language plpgsql;
>
>
Hi
po 28. 1. 2019 v 11:18 odesÃlatel napsal:
>
>
> Hi,
>
> I tried this code (to be inserted within a larger psql script)
>
> do $_$
> declare
> next int;
> begin
> select max(id) + 1 into next from items;
> execute 'create temp sequence tmp_ids start $1' using next;
>
t
Hi,
I tried this code (to be inserted within a larger psql script)
do $_$
declare
next int;
begin
select max(id) + 1 into next from items;
execute 'create temp sequence tmp_ids start $1' using next;
end
$_$ language plpgsql;
but that reports a syntax error near $1.
Wha
