Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1CLmax71270 for ; Mon, 12 Feb 2001 16:48:36 -0500 (EST) (envelope-from pgsql-interfaces-owner@postgresql.org) Received: from lion-around.at.yiff.net (lion-around.at.yiff.net [209.54.21.199]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1CG55x22177 for ; Mon, 12 Feb 2001 11:05:05 -0500 (EST) (envelope-from chris@netmonger.net) Received: (from chris@localhost) by lion-around.at.yiff.net (8.11.0/8.11.0) id f1CG4N099244; Mon, 12 Feb 2001 11:04:23 -0500 (EST) (envelope-from chris@netmonger.net) X-Authentication-Warning: lion-around.at.yiff.net: chris set sender to chris@netmonger.net using -f Date: Mon, 12 Feb 2001 11:04:23 -0500 From: Christopher Masto To: Tom Lane Cc: pgsql-interfaces@postgresql.org Subject: Re: An strftime function, and function name question Message-ID: <20010212110423.A99218@netmonger.net> References: <20010207110038.A28372@netmonger.net> <18468.981992306@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <18468.981992306@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Mon, Feb 12, 2001 at 10:38:26AM -0500 X-Archive-Number: 200102/101 X-Sequence-Number: 1058 On Mon, Feb 12, 2001 at 10:38:26AM -0500, Tom Lane wrote: > Christopher Masto writes: > > It would be nice if there were something like: > > > CREATE FUNCTION strftime(int4, varchar) RETURNS varchar AS > > '/usr/local/pgsql/lib/strftime.so' LANGUAGE 'c' > > USING C FUNCTION 'c_strftime'; > > > I.e. some way to say "here's the name of the function in the library". > > See the CREATE FUNCTION reference page, > http://www.postgresql.org/users-lounge/docs/7.0/postgres/sql-createfunction.htm > concerning link symbols that are different from the SQL name of the > function. Thank you. That was exactly what I was looking for.. I don't know how I missed it. I must have been reading the wrong manual. -- Christopher Masto Senior Network Monkey NetMonger Communications chris@netmonger.net info@netmonger.net http://www.netmonger.net Free yourself, free your machine, free the daemon -- http://www.freebsd.org/