2009/9/10 Tom Lane <[email protected]>: > Pavel Stehule <[email protected]> writes: >> I don't afraid about crashing. Simply I have not idea what sql >> sprintf's behave in case: > >> SELECT sprintf('some %s', 10) > > That one I don't think is hard --- coerce the input type to text and > print the string. > >> SELECT sprintf('some %d', 10::mycustomtype) > > For the formats that presume an integer or float input in C, perhaps > we could coerce to numeric (failing if that fails) and then print > appropriately. Or maybe int or float8 would be more appropriate > conversion targets.
it's possible - so format tags doesn't mean data type, but it means "try to drow it as type" - etc invisible explicit casting. It could work, but it doesn't look like SQL. regards Pavel Stehule > > regards, tom lane > -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
