2010/1/27 Vincenzo Romano <vincenzo.romano@xxxxxxxxxxx>: > 2010/1/27 Pavel Stehule <pavel.stehule@xxxxxxxxx>: >> Hello >> >> I add sprintf function. Now I think, we can add new contrib module >> (string functions) with both function - format and sprintf. These >> functions are relative different, so they can exists separately. >> Format is simpler and faster. Sprintf is more powerful but slower. >> >> postgres=# select pst.format('now is %', current_time); >> format >> --------------------------- >> now is 16:34:26.203728+01 >> (1 row) >> >> postgres=# select pst.sprintf('now is %s', current_time); >> sprintf >> -------------------------- >> now is 16:34:45.24919+01 >> >> Regards >> Pavel Stehule > > Yeah! > > But why still on separate schema? > I'd rather put them all in the public one, so you don't need the "pst." anymore. > Just like (most of) all other contrib mudules ... if you like, you can set a search_path it is cleaner than put all to public schema. I prefer ADA modul.function notation - it is more readable for me. Regards Pavel Stehule > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general