From: Josh Berkus <josh@agliodbs.com>
To: Yudie <yudie@axiontech.com>
To: pgsql-sql@postgresql.org
Subject: Re: Format Function
Date: Mon, 17 Feb 2003 12:56:59 -0800
Message-ID: <200302171256.59403.josh@agliodbs.com> (raw)
In-Reply-To: <009c01c2d6c6$fb985b90$8401a8c0@yudie>
References: <009c01c2d6c6$fb985b90$8401a8c0@yudie>
Yudie,
> Is there any default function for formating string in postgre sql?
> for instance:
> Format('123ABCDE', '####-###-###') => '12-3AB-CDE'
>
> The closest function I know is the to_char() function but it only works for
numbers
No, there isn't. You could write one, though. For example, you could write:
(7.3 syntax)
CREATE FUNCTION yudie_format(text) RETURNS text AS
'SELECT SUBSTR($1, 1, 4) || ''-'' || SUBSTR($1,5,3) || ''-'' ||
SUBSTR($1,9,4);
' LANGUAGE SQL IMMUTABLE STRICT;
As a simple formatting function.
For that matter, it would be the work of a weekend for someone to write a
function in PL/Perl which would take a format mask and apply it to any text
string.
--
-Josh Berkus
Aglio Database Solutions
San Francisco
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: josh@agliodbs.com, yudie@axiontech.com
Subject: Re: Format Function
In-Reply-To: <200302171256.59403.josh@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox