Re: [SQL] Format Function

2003-02-17 Thread Yudie
IF; i := i - 1; END LOOP; return strtemp; END ' language 'PLPGSQL' - Original Message - From: "Josh Berkus" <[EMAIL PROTECTED]> To: "Yudie" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 2:56 PM Subject: R

Re: [SQL] Format Function

2003-02-17 Thread Josh Berkus
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, y