2013/7/1 Peter Eisentraut <pete...@gmx.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
