Re: [GENERAL] begin-end blocks in psql

2008-03-21 Thread Rodrigo E. De León Plicet
On 3/21/08, Gauthier, Dave <[EMAIL PROTECTED]> wrote: > I can do it in a formal declaration of a procedure, and then execute the > procedure. But is there a less formal way? No. There are no anonymous blocks in PostgreSQL. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

[GENERAL] begin-end blocks in psql

2008-03-21 Thread Gauthier, Dave
How do you do a simple begin-end statement block inside of a psql session? For Example, I want to... - begin - declare a variable x to be an integer. Set it = 5 - declare s to be a varchar(8). Set it to "foo" - insert into mytable (theint,th