From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Begin / End blocks |
Date: | 2002-05-14 18:52:27 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB04C73A2F@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
Running Postgres 7.1.3 on RedHat Linux 2.4.7-rel 10.
I'm trying to learn how to use the BEGIN / END
blocks. My goal is to test the count
of a table and do such and such from there.
[pseudo code]
begin
if
select sum (*) from table < 1500
then
select into new_table * from table
else
return ''f'';
end if;
end
[/code]
questions:
* Do I have to make this a function?
* Is there a way to assign the value of
the count (or, sum of records in table)
to a variable and test for -that- ?
* I'm looking at the postgresql.org site
for examples, but all of the BEGIN / END
blocks are within creating a function - I'm
not sure I want to create one ...
* I'm sure the code above is wrong
(especially with the if statement) -
where can I find better code (groups.
google.com isn't working well, either).
Thanks!
-X
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Adler | 2002-05-14 19:09:00 | tool for comparing databases (?) |
Previous Message | Leland F. Jackson, CPA | 2002-05-14 18:14:44 | Re: Using COPY |