Thanks for the info. I will make sure to direct these types of questions
to the 'general' list in the future.
Thanks again for your help!!!
Merlin Moncure wrote:
On Tue, Mar 11, 2008 at 1:26 PM, Joshua <[EMAIL PROTECTED]> wrote:
Hello,
I have a series of SQL Update statements. I would like to write a
function which runs all of the SQL Update statements one at a time, in
order from top to bottom. Can somebody share the basic syntax that I
would need to write the aforementioned function?
please ask future questions of this nature on the general list. the
hackers list is reserved for things pertaining to postgresql
development.
anywyays, the answer is easy:
sql (imo preferred for this case):
create function do_stuff returns void as
$$
update foo set bar = 1 where foo_id = 2;
[repeat as necessary]
$$ language sql;
plpgsql:
create function do_stuff returns void as
$$
begin
update foo set bar = 1 where foo_id = 2;
[repeat as necessary]
end;
$$ language plpgsql;
merlin
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
