[GENERAL] What is a DO block for?

2013-05-23 Thread Rob Richardson
Greetings! Another post on this list suggested using a DO block if the user's Postgres version is 9.0 or later. The documentation for the DO block says what it is, but not what it is for. The only benefit I could see for it is allowing the use of locally defined variables. I'm sure there's

Re: [GENERAL] What is a DO block for?

2013-05-23 Thread Chris Travers
On Thu, May 23, 2013 at 5:58 AM, Rob Richardson rdrichard...@rad-con.comwrote: Greetings! Another post on this list suggested using a DO block if the user's Postgres version is 9.0 or later. The documentation for the DO block says what it is, but not what it is for. The only benefit I

Re: [GENERAL] What is a DO block for?

2013-05-23 Thread salah jubeh
Richardson rdrichard...@rad-con.com Cc: pgsql-general@postgresql.org pgsql-general@postgresql.org Sent: Thursday, May 23, 2013 3:04 PM Subject: Re: [GENERAL] What is a DO block for? On Thu, May 23, 2013 at 5:58 AM, Rob Richardson rdrichard...@rad-con.com wrote: Greetings! Another post

Re: [GENERAL] What is a DO block for?

2013-05-23 Thread Joshua D. Drake
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 documentation for the DO block says what it is, but not what it is for. The only benefit I could see for it is allowing the