| From: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Shaan Repswal <shaun(dot)reapswaal(at)gmail(dot)com>, <psycopg(at)postgresql(dot)org> |
| Subject: | Re: Facing error trying to pull out data from column |
| Date: | 2016-06-06 21:29:08 |
| Message-ID: | b6797a6d-9786-8374-0c86-160ec72c03de@BlueTreble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
On 6/4/16 9:30 PM, Adrian Klaver wrote:
>> And I want to print and cycle through all of the LTRS/ML (quantity
>> columns) for every product name that I have. How do I go about that?
Another suggestion: build your column list once, and run ONE query, not
hundreds or thousands. You'll get MUCH better performance.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532) mobile: 512-569-9461
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Philipp H. v. Loewenfeld | 2016-06-26 19:19:15 | possible SQL injection problem in ZPsycopgDA |
| Previous Message | Adrian Klaver | 2016-06-05 02:30:19 | Re: Facing error trying to pull out data from column |