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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers