Format Function

From: "Yudie" <yudie(at)axiontech(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Format Function
Date: 2003-02-17 20:56:01
Message-ID: 009c01c2d6c6$fb985b90$8401a8c0@yudie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
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

please advise

Thanks
Yude

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2003-02-17 20:56:59 Re: Format Function
Previous Message Stephan Szabo 2003-02-17 20:18:20 Re: Returning multiple rows from plpgsql function