I am trying to create a fan page for my band and in the 'about' section I can't find where to add band members in a list. I can see that I have done it in the past and other bands have it but I can't find it. What can I do? Thankyou
Thought if we can all compile a list of all the albums by all ex and current members in one place.
Hi, the question is so simple, but I'm really struggling with the query.
Basically I want to take data that looks just like a band timeline, i.e.
https://upload.wikimedia.org/wikipedia/en/timeline/9320b689072521623f5ab8b9c88a14eb.png
where table of members has columns name and timespan,
and I would like a query that returns an array of names (i.e. the band) for each point in time
Im starting off by trying a window-function where the window wants to be "all rows that contain the lower-end of 'current-row's timespan"
However I'm getting confused by the filter matching everything, when it appears it shouldnt,
my table
testy=> select * from test;
name | timespan
-----------------+----------
James Hetfield | [1,8)
David Mustaine | [1,2)
Ron McGovney | [1,2)
Lars Ulrich | [1,8)
Cliff Burton | [2,4)
jason Newsted | [4,6)
Robert Trujillo | [6,8)
Kirk Hammet | [2,8)
my current query
testy=> select t.timespan, array_agg(split_part(name, ' ', 2))
FILTER(WHERE timespan @> lower(t.timespan))
OVER() as lower_names
FROM test t
;
timespan | lower_names
----------+--------------------------------------------------------------------
[1,8) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[1,2) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[1,2) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[1,8) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[2,4) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[4,6) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[6,8) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
[2,8) | {Hetfield,Mustaine,McGovney,Ulrich,Burton,Newsted,Trujillo,Hammet}
(8 rows)
I also tried with the timespan duration check as a PARTITION BY, and the query is still valid, but again it includes every column.
test creation sql:
CREATE TABLE public.test (
name text,
timespan int4range
);
INSERT INTO test(name, timespan) VALUES ('James Hetfield', '[1,8)'),
('David Mustaine', '[1,2)'),
('Ron McGovney', '[1,2)'),
('Lars Ulrich', '[1,8)'),
('Cliff Burton', '[2,4)'),
('jason Newsted', '[Seriously, check out this lineup.
June 14th, 2020, at 12pm ET/9am PT
"An all day live streaming charity event hosted by Will Putney. Featuring a collective of artists, record labels, producers, and managers. Join us as we catch up with artists and discuss a wide range of topics in an open forum with Q&As and giveaways."
Watch on soundrink.live.
Thom - Lift: "we've been trying to reach you, Thom"
Ed - Weird Fishes: "EEEEEEEEEEEEEDDDDD"
Jonny - 2+2=5: "that's a nice way to start Jonny"
Colin - Yes I Am: "I resent you Colin, I resent your voice"
Phil - Lotus Flower: "just to Phil your fast ballooning head"
Pretty interesting.
I'm a tour guide and I like talking about Riot Fest when we are near Grant Park. I know that is where Lolla is at, but when were stuck in traffic on Lake Shore Drive (which hardly ever happens*), I like to say, "There's a festival I like more," and proceed to talk about Riot Fest.
*sarcasm
Like how Stevie's Silver Springs was written about Lindsay, and Christine's Songbird was about John, and Lindsay's Go Your Own Way was about Stevie ect.??
Iβm wondering how easy it is to find people to play music with in Chicago. There arenβt a lot of musicians where I live now, and Iβd like to be somewhere where there are more musicians to work with. Thanks!
The bassist and the singers especially have me absolutely charmed. But all the articles and his website just list the dates and brag about his "12-piece ensemble" without listing a single name. :(
Sorry for reposting, I didn't tag my post correctly
I feel like with many of the major bands throughout history, there is almost always one or sometimes two driving creative forces behind the music, and some of the other members take a backseat to them. Pink floyd with Waters and Gilmour, the Beatles with lennon and mccartney, the Beach Boys with Brian Wilson. I feel like this is the case with many popular bands and I'm curious if there are any bands where this isn't the case, where all the members are equally represented in the music they are making. And if I'm wrong about any of the bands I listed, please let me know.
This is my first time posting here, so if it's not fully thought out or it's not clear what I'm trying to say, please let me know.
It seems like the band cycled through a few members could we get a list of all the member and when they where in the band?
