dynamic queries
От | Uros |
---|---|
Тема | dynamic queries |
Дата | |
Msg-id | 515506940.20040127161048@sir-mag.com обсуждение исходный текст |
Ответ на | Re: Newbie to Postgres - Urgent query (Ritu Khetan <ritu@netcore.co.in>) |
Список | pgsql-general |
Hello! I want to execute some dynamic query from for loop in plpgsql But i don't know how to add vaules like boolean or integer. With text type works. Here is my query. As you can see I tried with ::text but with no luck. EXECUTE ''UPDATE directory_entry set "caption" = '' || quote_literal(tmp.caption) || '', "description" = '' || quote_literal(tmp.description) || '', "keywords" = '' || quote_literal(tmp.keywords) || '', "url" = '' || quote_literal(tmp.url) || '', "is_company" = '' || tmp.is_company::text || '', "is_novelty" = '' || tmp.is_novelty::text || '', "expire" = '' || tmp.expire::text || '', "modified" = ''''now'''' where id_entry='' || tmp.id_entry; tia Uros
В списке pgsql-general по дате отправления: