Received: from fargo.cisco.com (fargo.cisco.com [171.70.170.202]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6S30Qf55045 for ; Fri, 27 Jul 2001 23:00:26 -0400 (EDT) (envelope-from john@networkproductions.net) Received: from JOAKESW2K (sj-dial-1-96.cisco.com [171.68.179.97]) by fargo.cisco.com (8.8.6 (PHNE_17190)/CISCO.SERVER.1.2) with SMTP id UAA16077 for ; Fri, 27 Jul 2001 20:00:21 -0700 (PDT) Message-ID: <002f01c11711$714d78b0$61b344ab@cisco.com> From: "John Oakes" To: Subject: Why does this plpgslq always return 1? Date: Fri, 27 Jul 2001 20:00:21 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200107/366 X-Sequence-Number: 4180 Can anyone tell me why this always return 1? Thanks! CREATE FUNCTION passrate(date, date, text) RETURNS float AS ' DECLARE begindate ALIAS FOR $1; enddate ALIAS FOR $2; passfail ALIAS FOR $3; ret float; countp float; counttotal float; BEGIN SELECT INTO countp COUNT(*) FROM benchmark WHERE passfail = passfail; SELECT INTO counttotal COUNT(*) FROM benchmark; ret := countp / counttotal; RETURN ret; END;' LANGUAGE 'plpgsql'; John