Re: proposal: simple date constructor from numeric values

2013/7/1 Peter Eisentraut <peter_e(at)gmx(dot)net>:
> On 7/1/13 3:47 AM, Pavel Stehule wrote:
>> and it is a part of our ToDo: "Add function to allow the creation of
>> timestamps using parameters"
>>
>> so we can have a functions with signatures
>
> I would just name them date(...), time(...), etc.
>

+1

>> CREATE OR REPLACE FUNCTION construct_date(year int, month int DEFAULT
>> 1, day int DEFAULT 1) RETURNS date;
>
> I would not use default values for this one.
>

I have no problem with it

>> CREATE OR REPLACE FUNCTION construct_time(hour int DEFAULT 0, mi int
>> DEFAULT 0, sec int DEFAULT 0, ms float DEFAULT 0.0);
>
> If we are using integer datetime storage, we shouldn't use floats to
> construct them.
>

so possible signature signature should be

CREATE FUNCTION time(hour int, mi int, sec int, used int) ??

and

CREATE FUNCTION timetz(hour int, mi int, sec int, isec int, tz int)

??

Regards

Pavel