X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D3863D1E12D for ; Thu, 19 Feb 2004 15:10:08 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 84341-06 for ; Thu, 19 Feb 2004 11:10:11 -0400 (AST) Received: from ind-iport-1.cisco.com (ind-iport-1-sec.cisco.com [64.104.129.9]) by svr1.postgresql.org (Postfix) with ESMTP id 923DFD1E14B for ; Thu, 19 Feb 2004 11:10:00 -0400 (AST) Received: from india-core-1.cisco.com (64.104.129.221) by ind-iport-1.cisco.com with ESMTP; 20 Feb 2004 02:14:00 +0530 Received: from cisco.com (charminar.cisco.com [192.135.240.11]) by india-core-1.cisco.com (8.12.10/8.12.6) with ESMTP id i1JF9tWT012090; Thu, 19 Feb 2004 07:09:56 -0800 (PST) Received: from sbiswasw2k01 (dhcp-10-77-21-42.cisco.com [10.77.21.42]) by cisco.com (8.8.8-Cisco List Logging/8.8.8) with ESMTP id UAA21306; Thu, 19 Feb 2004 20:38:07 +0530 (IST) From: "Sumita Biswas" To: "'scott.marlowe'" Cc: "'Stephan Szabo'" , Subject: Re: Function Date: Thu, 19 Feb 2004 20:40:00 +0530 Message-ID: <00bd01c3f6fa$72fff5e0$2a154d0a@apac.cisco.com> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.4024 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4927.1200 Importance: Normal In-Reply-To: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/318 X-Sequence-Number: 17008 Is this the right place to get PostgreSQL 7.3.4 from: ftp://ftp10.us.postgresql.org/pub/postgresql/source/v7.3.4/postgresql-7. 3.4.tar.gz Regards, Sumita -----Original Message----- From: scott.marlowe [mailto:scott.marlowe@ihs.com] Sent: Wednesday, February 18, 2004 4:17 AM To: Sumita Biswas (sbiswas) Cc: 'Stephan Szabo'; pgsql-sql@postgresql.org Subject: Re: [SQL] Function On Mon, 16 Feb 2004, Sumita Biswas (sbiswas) wrote: > Thanks for the answer. > I have one more issue. How do I test a function that I wrote? I was > able to create a function called Proc_ConferenceSummary(). In SQL > Server I used to run it through query analyzer by writing the > following command: exec Proc_ConferenceSummary > '12/1/2003','1/23/2004',1,1,0,5001 > > But I don't know how to do it in Postgresql. select functioname(arg1,arg2,arg3);