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: | Raw Message | Whole Thread | 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) |