X-Original-To: pgsql-php@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E8C85475EA4 for ; Thu, 27 Feb 2003 14:01:42 -0500 (EST) Received: from postgresql.org ([64.49.215.8]) by localhost (postgresql.org [64.49.215.8:10024]) (amavisd-new) with SMTP id 00891-05 for ; Thu, 27 Feb 2003 14:01:32 -0500 (EST) Received: from halo.ispgateway.de (halo.ispgateway.de [62.67.200.127]) by postgresql.org (Postfix) with SMTP id 07591476048 for ; Thu, 27 Feb 2003 13:30:22 -0500 (EST) Received: (qmail 10548 invoked from network); 27 Feb 2003 18:30:20 -0000 Received: from unknown (HELO lucky) (951075@[217.225.70.116]) (envelope-sender ) by halo.ispgateway.de (qmail-ldap-1.03) with SMTP for ; 27 Feb 2003 18:30:20 -0000 From: "Markus Post" To: Subject: PL/PGSQL Date: Thu, 27 Feb 2003 19:29:57 +0100 Organization: PureMatic Message-ID: <000101c2de8e$3b595df0$8100a8c0@lucky> 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.2616 Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200302/58 X-Sequence-Number: 1909 Hello together! I have a little question, because I found the answer nowhere in the Net. How I can call a stored pl/pgsql-function from my SQL-Client. In an SQL-statement I call it like "select MYFUNCTION(blah, blah) from ...". I need it without the SQL-Statement. In Oracle I would be: BEGIN MYFUNCTION(...); END; How can I do this with PG? Greets, Markus