[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: Problems with using function input paramaters
From:       Tom Lane <tgl () sss ! pgh ! pa ! us>
Date:       2019-08-31 15:13:30
Message-ID: 23260.1567264410 () sss ! pgh ! pa ! us
[Download RAW message or body]

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sat, Aug 31, 2019 at 7:05 AM stan <stanb@panix.com> wrote:
>> CURRENT_DATE) - interval '  $1
>> month - 1
>> ' day as date)

> ($1 || ' month')::interval  -- should work

FWIW, I tend to prefer doing it with interval arithmetic, like this:

$1 * '1 month'::interval - '1 day'::interval

It's faster (not enormously so, but measurably) thanks to not having
to construct and then parse a text string.  To my mind it's easier
to reason about, too, and a bit safer.

			regards, tom lane


[prev in list] [next in list] [prev in thread] [next in thread]