X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id CA0F3D1C4E1 for ; Sat, 9 Aug 2003 20:22:02 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 04753-01 for ; Sat, 9 Aug 2003 17:20:33 -0300 (ADT) Received: from gebeat.local (unknown [212.223.2.210]) by svr1.postgresql.org (Postfix) with SMTP id 0C21CD1C4BA for ; Sat, 9 Aug 2003 17:21:36 -0300 (ADT) Received: (qmail 30233 invoked from network); 9 Aug 2003 20:16:14 -0000 Received: from unknown (HELO server) (info@unixserver.info@217.229.66.178) by gebeat.ecore.net with SMTP; 9 Aug 2003 20:16:14 -0000 Message-ID: <01b101c35eb3$6e75b2b0$3214a8c0@server> From: "Bernd Hoffmann" To: Subject: functions with plpgsql Date: Sat, 9 Aug 2003 22:18:38 +0200 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 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=1.0 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: * X-Archive-Number: 200308/32 X-Sequence-Number: 2209 Hi, I have some problems by using functions with plpgsql. For example: tbl: CREATE TABLE "logs" ( "id" int4 DEFAULT nextval('"logs_id_seq"'::text) NOT NULL, "session" varchar NOT NULL, "addr" inet NOT NULL, "host" varchar NOT NULL, "agent" varchar NOT NULL, "datum" timestamptz DEFAULT now(), "referer" varchar, CONSTRAINT "logs_pkey" PRIMARY KEY ("id") ); function: CREATE FUNCTION "next_id"(character varying) RETURNS integer AS ' DECLARE tabelle ALIAS FOR $1; BEGIN SELECT MAX(id)+1 FROM tabelle; END; ' LANGUAGE 'plpgsql' query: SELECT next_id(logs); error: PostgreSQL meldet: ERROR: parser: parse error at or near "$1" Can anybody help me? MfG Bernd Hoffmann unixserver.info 96123 Litzendorf Tel: +499505/8050485 Fax: +499505/8050486 info@unixserver.info