Postgres Pro
Downloads
Home   >   mailing lists

Re: reduce number of multiple values to be inserted - Mailing list pgsql-general

From tango ward
Subject Re: reduce number of multiple values to be inserted
Date
Msg-id CAA6wQL+fbVqRbL7os9EyHHU395DrGEwPDdA9hGsYHpZMbsTk0A@mail.gmail.com
Whole thread Raw
In response to Re: reduce number of multiple values to be inserted  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
On Wed, May 30, 2018 at 8:21 AM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Tuesday, May 29, 2018, tango ward <tangoward15@gmail.com> wrote:
I will repeat the same process for 13 villages so that will be 117 of values. I would like to know if there's a way to reduce the script? This has to be done strictly via script.


VALUES and CROSS JOIN might help but you haven't explained the pattern well enough, if there is one, to know for sure.  Frankly, you'll probably spend more time figuring out the elegant way than just copy-paste-change so unless you need to leverage this elsewhere I'd say just brute-force it.

David J.


Can you elaborate the idea on brute-forcing this Sir?


Thanks,
J

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: reduce number of multiple values to be inserted
Next
From: Rob Sargent
Date:
Subject: Re: reduce number of multiple values to be inserted