Pavel Stehule wrote:
> why we need DO statement? Why not just $$ $$. Only string literal
> cannot be statement too, so DO is unnecessary.
>
> it can look like:
>
> $$
> FOR r IN SELECT ....
> END LOOP;
> $$;
>
> ???
>
>
Well, it's arguably somewhat un-SQL-ish. Every command in SQL is
introduced by a keyword verb.
I'm also not sure I want to be trying to execute any arbitrary string
that accidentally gets placed there because someone forgot to put a
keyword or accidentally deleted it.
But I'm not too dogmatic on the subject. What do others think?
cheers
andrew