Doing multiple steps at once - Mailing list pgsql-general

From Detlef Jockheck
Subject Doing multiple steps at once
Date
Msg-id 200303021249.h22CnvA16421@krakatau.jockheck.de
Whole thread Raw
Responses Re: Doing multiple steps at once  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

Basis: I have two tables (a & b).
1st: I create/clear a temporary table c
2nd: doing a "insert into c select something from a"
3rd: doing a "insert into c select something from b"
4th: calculate a result with "select something from c group by column"
5th: go back to 1st after some checks/corrections in a.

Is it possible to do the four steps (1-4) at once (with a function, procedure
or so?)

ciao
Detlef

--
# Dipl. Ing. (FH) Detlef Jockheck
# E-mail: detlef@jockheck.de
# -------------------------------

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Listing schemas
Next
From: Lincoln Yeoh
Date:
Subject: Re: automatic creation of oid