Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: John-Paul Stewart Newsgroups: comp.databases.postgresql Subject: Re: Table with a variable number of elements in a column Date: Sat, 27 Apr 2019 19:26:48 -0400 Lines: 22 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Trace: individual.net U2GVF+jf6Lv3hV3LuDo6xw4nCDE4LXQJOvGcMU9YKcbbhtjAfB Cancel-Lock: sha1:DisHTfi0QS8wHuB2dMEGJVNGmI4= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 In-Reply-To: Content-Language: en-CA Xref: csiph.com comp.databases.postgresql:868 On 2019-04-27 6:40 p.m., Bill Gunshannon wrote: > > Yeah, I went upstairs to watch the golf and think about it and > it hit me.  I was looking at it all wrong.  I know the feeling. It's all too easy to get fixated on one idea and then "not see the forest for the trees". I've been there, done that far more times than I'd care to admit. You really don't want to know how badly I mis-used Postgres' arrays in the past to achieve the result you initially described before I learned about this stuff. > Thank you very much for kicking me in the head to knock this stuff > loose so it could float back up to the surface. I'm sure there are plenty of topics where I'll need the kick in the head. And more where no amount of kicking will help me. That's what I like about these newsgroups: they're a great place to get a second opinion. Good luck! Your album archive project sounds like more fun than anything I'm working on.