Postgres Pro
Downloads
Home   >   mailing lists

Re: Problems with using function input paramaters - Mailing list pgsql-general

From David G. Johnston
Subject Re: Problems with using function input paramaters
Date
Msg-id CAKFQuwaEENXNMJy9fbxN8VjAkSrRqgMWMPFma1agLevm0bZ5_Q@mail.gmail.com
Whole thread Raw
In response to Problems with using function input paramaters  (stan <stanb@panix.com>)
Responses Re: Problems with using function input paramaters  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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

Content within a literal (i.e., between single quotes) is always treated as literal content.

David J.

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Aggregate functions on groups
Next
From: Tom Lane
Date:
Subject: Re: Problems with using function input paramaters