Received: from MAIL.hrz.uni-siegen.de (maila.hrz.uni-siegen.de [141.99.11.1]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA82580 for ; Fri, 4 Jun 1999 13:21:50 -0400 (EDT) (envelope-from martin@unix-ag.org) Message-Id: <199906041721.NAA82580@hub.org> Received: from ga52124b (ga52124.ga.wohnheim.uni-siegen.de [141.99.25.155]) by MAIL.hrz.uni-siegen.de with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2448.0) id MDZ6RG7R; Fri, 4 Jun 1999 19:21:48 +0200 X-Sender: martin@vmax.unix-ag.org X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0.1 Date: Fri, 04 Jun 1999 19:22:21 +0200 To: =?iso-8859-1?Q?Jos=E9?= Soares From: Martin Leja Subject: Re: [SQL] Howto convert floats to text? Cc: pgsql-sql@postgresql.org In-Reply-To: <3757CBD7.66FBE889@sferacarta.com> References: <199906041045.GAA67778@hub.org> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 14:51 04.06.99 +0200, you wrote: >Use this PL/pgSQL script to create text(float), varchar(float), char(float): >create function text(float) returns text as >'begin > return $1; >end; >' language 'plpgsql'; Thanks for the tip, but if i try the above, i get: ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'. Recognized languages are sql, C, internal and the created procedural languages. what is pl/pgsql? I using postgres 6.3.2 (slink/stable debian package), do i hve to upgrade to a higer version, or is this plpgsql thing to be installed separately? -- Regards, martin@unix-ag.org