Thread: sprintf

I need something like that

SELECT sprintf('String with pattens: %d, %s',13,'abc');

and return:

'String with pattens: 13, abc';

Thanks.

Hello,


2011/1/13 tbazadaykin <tbazadaykin@yandex.ru>:
> I need something like that
>
> SELECT sprintf('String with pattens: %d, %s',13,'abc');
>

function sprintf is available from pltoolbox library

http://pgfoundry.org/frs/?group_id=1000457

Regards

Pavel Stehule

> and return:
>
> 'String with pattens: 13, abc';
>
> Thanks.
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>