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