2009/8/15 Andrew Dunstan <and...@dunslane.net>: > > > 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.
sure - this is not SQL statement. I thing so most SQL-ish is T-SQL style. You have integrated procedural statements. so the best is directly: FOR .... LOOP END LOOP; but it's far future :) > > 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
