Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9OK5oP27443 for ; Wed, 24 Oct 2001 16:05:50 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f9OJwNf84884 for pgsql-sql@postgresql.org; Wed, 24 Oct 2001 15:58:23 -0400 (EDT) (envelope-from news) From: suzuyam1102001@yahoo.com (Suyam) X-Newsgroups: comp.databases.postgresql.sql Subject: Question regarding Function & Return table Date: 24 Oct 2001 12:58:21 -0700 Organization: http://groups.google.com/ Lines: 43 Message-ID: <17e20f7a.0110241158.41dcf208@posting.google.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: groups-abuse@google.com To: pgsql-sql@postgresql.org X-Archive-Number: 200110/352 X-Sequence-Number: 5305 All, I am a beginner to learn Pl/ SQL. How can I return either " Return Pl/SQL table" or "Return VARCHAR2" simultaneously? The result is dependable on Count(Last_name) condition. Thanks, The below is incomplete because I cannot understand the above question. =========================================================== create or replace function New_Rental( P_last_name S_member.LAST_NAME%TYPE, P_member_id S_member.Member_id%TYPE, P_first_name S_member.FIRST_NAME%TYPE, P_phone S_member.Phone%TYPE, P_VALID_DATE In OUT Date) Return VARCHAR2 Is V_msg :='Expected due date is'||P_VALID_DATE; Begin If Count(Last_name)=1 then Select VALID_DATE INTO P_VALID_DATE from S_member Where Last_Name:= P_Last_name; return 'Expected due date is'||P_VALID_DATE; ElSIF Count(Last_name)> 1 then Select VALID_DATE INTO P_VALID_DATE from S_member Where Last_name:=P_last_name And Member_id:= P_member_id; return 'Expected due date is'||P_VALID_DATE||'Person's record as follows:'||P_last_name,P_first_name, P_phone, P_member_id ; Else Count(Last_name)=0 return 'This person needs to be registered as a member' End If; End New_Rental; ======================================================================