Home > mailing lists

Format Function - Mailing list pgsql-sql

From	Yudie
Subject	Format Function
Date	February 17, 2003 18:47:18
Msg-id	009c01c2d6c6$fb985b90$8401a8c0@yudie Whole thread Raw
Responses	Re: Format Function
List	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

From: Stephan Szabo
Date: 17 February 2003, 18:18:21
Subject: Re: Returning multiple rows from plpgsql function

From: Josh Berkus
Date: 17 February 2003, 18:58:36
Subject: Re: Format Function