| From: | Christine Penner <chris(at)fp2(dot)ca> |
|---|---|
| To: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | function problems |
| Date: | 2010-11-16 21:27:34 |
| Message-ID: | 19740413173256.E54EB0C1F4E7F4C9@edtnaa20.telusplanet.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I am trying to write a postgres function and I'm getting errors when
the parameter sub is empty (it wont ever be null) and meetCode has a number.
This is the function code:
create or replace function SubjectDisplay(IN subj varchar,IN meetCode
numeric,IN meetTrWP integer,OUT Display varchar)
returns varchar as
$BODY$
Declare
meetType varchar;
BEGIN
IF subj='' Then
if meetCode=0 Then
if meetTrWp=0 Then
Select S_MEETING_TITLE as Display from System Limit 1;
Return;
elseif meetTrWp=1 Then
Select S_TRAINING_TITLE as Display from System Limit 1;
Return;
else
Select S_WP_TITLE as Display from System Limit 1;
Return;
end if;
else
--This is where I run into problems. I get an error when I run it.
Query has no destination for result data
Select MT_DESCRIPTION as meetType from MEETING_TYPE Where MT_CODE=meetCode;
Display := meetType
Return;
end if;
else
Display := subj
Return;
end if;
Return;
END;
$BODY$
LANGUAGE plpgsql IMMUTABLE
COST 100;
Christine Penner
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2010-11-16 21:54:53 | Re: function problems |
| Previous Message | Nicklas Avén | 2010-11-16 21:23:18 | Re: Counting boolean values (how many true, how many false) |