Re: GRANT ON ALL IN schema - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: GRANT ON ALL IN schema
Date
Msg-id 4A86B5D5.6060807@dunslane.net
Whole thread Raw
In response to Re: GRANT ON ALL IN schema  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: GRANT ON ALL IN schema  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: GRANT ON ALL IN schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: GRANT ON ALL IN schema  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers

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



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: GRANT ON ALL IN schema
Next
From: Pavel Stehule
Date:
Subject: Re: GRANT ON ALL IN schema