Postgres Pro
Downloads
Home   >   mailing lists

make_interval ?? - Mailing list pgsql-hackers

From Pavel Stehule
Subject make_interval ??
Date
Msg-id CAFj8pRAfXSA86NFMHff5UCzLmbR_GTGMh0efNaem7oBdWpqcNw@mail.gmail.com
Whole thread Raw
List pgsql-hackers
Tree view
Hello

we have defined interface date, time, timestamp constructors.

There is a question if we would to have some similar for interval type?

As different from time, timestamp there we can use a zero as defaults.

So constructor should to look like:

CREATE OR REPLACE FUNCTION make_interval(years int DEFAULT 0, months int DEFAULT 0, ...)

and usage:

SELECT make_interval(years := 2)
SELECT make_interval(days := 14)

Is there a interest for this (or similar) function?

Regards

Pavel

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Logging WAL when updating hintbit
Next
From: Haribabu kommi
Date:
Subject: Re: New option for pg_basebackup, to specify a different directory for pg_xlog