X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 202E6475F5F for ; Wed, 2 Apr 2003 23:34:31 -0500 (EST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id A42C8474E44 for ; Wed, 2 Apr 2003 23:33:51 -0500 (EST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h334Xn2L025619; Wed, 2 Apr 2003 23:33:49 -0500 (EST) To: "Marc G. Fournier" Cc: pgsql-sql@postgresql.org Subject: Re: simple trigger question ... In-reply-to: <20030403002922.Y71125@hub.org> References: <20030402223933.M71125@hub.org> <25296.1049341477@sss.pgh.pa.us> <20030403000605.U71125@hub.org> <25512.1049343373@sss.pgh.pa.us> <20030403002922.Y71125@hub.org> Comments: In-reply-to "Marc G. Fournier" message dated "Thu, 03 Apr 2003 00:31:20 -0400" Date: Wed, 02 Apr 2003 23:33:49 -0500 Message-ID: <25618.1049344429@sss.pgh.pa.us> From: Tom Lane X-Spam-Status: No, hits=-32.3 required=5.0 tests=BAYES_00,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/29 X-Sequence-Number: 12730 "Marc G. Fournier" writes: > Okay, so I do have to create the FUNCTION first, I can't do it without? Check. > Can a TRIGGER pass an arg to the FUNCTION? Yes, but only simple constant strings. (In this context, it might make sense for the CREATE TRIGGER command to tell the function the name of the specific sequence to increment.) regards, tom lane