dynamic queries - Mailing list 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