Re: What is a DO block for?

On 05/23/2013 05:58 AM, Rob Richardson wrote:
>
> Greetings!
>
> Another post on this list suggested using a DO block if the user's Postgres version is 9.0 or later.  The
documentationfor the DO block says what it is, but not what it is for.  The only benefit I could see for it is allowing
theuse of locally defined variables.  I'm sure there's more to it than that.  What justifies the existence of the DO
block?
>
> The message that mentioned the DO block is quoted below as an example.

In database processing without having to create a function that is stored.

JD
--
Command Prompt, Inc. - http://www.commandprompt.com/  509-416-6579
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC, @cmdpromptinc
For my dreams of your image that blossoms
    a rose in the deeps of my heart. - W.B. Yeats