Home > mailing lists

Re: Is it possible to use keywords (date units) in a function definition? - Mailing list pgsql-general

From	David G. Johnston
Subject	Re: Is it possible to use keywords (date units) in a function definition?
Date	June 9, 2020 01:10:42
Msg-id	CAKFQuwYwjDZLTY1JkkTL-4VtmBdK23-FZzVs7woweP0h+FSDmQ@mail.gmail.com Whole thread Raw
In response to	Is it possible to use keywords (date units) in a function definition? (Alistair Johnson <aewj@mit.edu>)
Responses	Re: Is it possible to use keywords (date units) in a functiondefinition? (Adrian Klaver <adrian.klaver@aklaver.com>)
List	pgsql-general

On Mon, Jun 8, 2020 at 2:57 PM Alistair Johnson <aewj@mit.edu> wrote:

RETURN EXTRACT(datepart FROM end - start);
Any ideas? Is this even possible?

Use the "date_part" function.

David J.

From: David Rowley
Date: 09 June 2020, 00:25:12
Subject: Re: When to use PARTITION BY HASH?

From: Ron
Date: 09 June 2020, 01:31:26
Subject: Re: Concurrenctly running CREATE TEMP TABLE IF NOT EXISTS [...] AS[...]