SEO

#1 (**permalink**) 04-09-2008, 11:22 PM

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,thestr) values (x.s);

- end

I can do it in a formal declaration of a procedure, and then execute the
procedure. But is there a less formal way?

Thanks

-dave

#2 (**permalink**) 04-09-2008, 11:22 PM

On 3/21/08, Gauthier, Dave <dave.gauthier@intel.com> 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 make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

begin-end blocks in psql