Re: Variadic polymorpic functions - Mailing list pgsql-general

From Pavel Stehule
Subject Re: Variadic polymorpic functions
Date
Msg-id 162867791001270752o29a09277veb2ab437fb1196ce@mail.gmail.com
Whole thread Raw
In response to Re: Variadic polymorpic functions  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: Variadic polymorpic functions  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
2010/1/27 Vincenzo Romano <vincenzo.romano@notorand.it>:
> 2010/1/27 Pavel Stehule <pavel.stehule@gmail.com>:
>> 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



>

pgsql-general by date:

Previous
From: Vincenzo Romano
Date:
Subject: Re: Variadic polymorpic functions
Next
From: "Aycock, Jeff R."
Date:
Subject: syntax error during function call