X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C94B7D1E0F1 for ; Fri, 20 Feb 2004 14:01:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 74592-06 for ; Fri, 20 Feb 2004 10:01:24 -0400 (AST) Received: from tomts31-srv.bellnexxia.net (tomts31.bellnexxia.net [209.226.175.105]) by svr1.postgresql.org (Postfix) with ESMTP id 975B9D1B456 for ; Fri, 20 Feb 2004 10:01:19 -0400 (AST) Received: from taz.novacolor.ca ([67.68.227.114]) by tomts31-srv.bellnexxia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040220140122.ZSIQ23238.tomts31-srv.bellnexxia.net@taz.novacolor.ca> for ; Fri, 20 Feb 2004 09:01:22 -0500 From: Mark Tabash Organization: Novacolor Inc. To: pgsql-sql@postgresql.org Subject: create function atof? Date: Fri, 20 Feb 2004 09:01:21 -0500 User-Agent: KMail/1.5 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200402200901.21616.mark.tabash@novacolor.ca> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/316 X-Sequence-Number: 17006 Hello, Is it possible to create a database function that mimics the C function atof? I'm guessing it should look something like this: create function atof(varchar) returns float as '??????' language ???? returns null on null input; Thanks, Mark