Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1CFcsx15911 for ; Mon, 12 Feb 2001 10:38:54 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f1CFcQ918471; Mon, 12 Feb 2001 10:38:26 -0500 (EST) To: Christopher Masto cc: pgsql-interfaces@postgresql.org Subject: Re: An strftime function, and function name question In-reply-to: <20010207110038.A28372@netmonger.net> References: <20010207110038.A28372@netmonger.net> Comments: In-reply-to Christopher Masto message dated "Wed, 07 Feb 2001 11:00:38 -0500" Date: Mon, 12 Feb 2001 10:38:26 -0500 Message-ID: <18468.981992306@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200102/96 X-Sequence-Number: 1052 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. If you're using something older than 7.0, time to upgrade ... regards, tom lane