data definition within plpgsql
От
hamann.w@t-online.de
Тема
data definition within plpgsql
Дата
Msg-id
wolfgang-1190128111756.A0227604@noten19.local
Список
Дерево обсуждения
data definition within plpgsql hamann.w@t-online.de
Re: data definition within plpgsql Laurenz Albe <laurenz.albe@cybertec.at>
Re: data definition within plpgsql Pavel Stehule <pavel.stehule@gmail.com>
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. What is the proper way of doing that? Best regards Wolfgang Hamann
В списке pgsql-general по дате отправления