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