inhouseuk wonders if nikki_ is getting the today is birthday artists using a method similar to this
2006-02-01 03257, 2006
inhouseuk
select gid, name from (select gid, name, begindate, (extract(DOY from begindate::TIMESTAMP) = extract(DOY from TIMESTAMP 'NOW')) as is_birthday from artist where split_part(begindate,'-',2) != '00' and split_part(begindate,'-',3) != '00') AS t where is_birthday;
2006-02-01 03229, 2006
inhouseuk
it was fun because the date fields in the tables are char(10) and they can contain invalid true timestamp values
2006-02-01 03217, 2006
Muz
Fuck
2006-02-01 03220, 2006
Muz goes to bed
2006-02-01 03228, 2006
nechto13
good night muz
2006-02-01 03233, 2006
Muz
G'night
2006-02-01 03237, 2006
Muz is twitchy lol
2006-02-01 03240, 2006
inhouseuk
night Muz
2006-02-01 03250, 2006
Muz
Night in
2006-02-01 03252, 2006
Muz
house
2006-02-01 03217, 2006
ruaok
yep, inhouseuk... our partial dates can be a pain in the ass
2006-02-01 03229, 2006
ruaok
got a new trivia page to look at yet? :0)
2006-02-01 03237, 2006
inhouseuk
ruaok: give me a *little* while :)
2006-02-01 03258, 2006
nechto13
just to check that i've been doing the right thing all along. at least half of the artists that i added to ISO have russian sounding names, but i did not yield to temptation to put their names in cyrillic, since they could be from any one of the republics of former soviet union
2006-02-01 03202, 2006
inhouseuk
which might not be cyrillic such as in georgia :)
2006-02-01 03247, 2006
nechto13
right, that's why i didn't to do it. for some reason i put russian names for belarusian artists too, which sort of buffles me
2006-02-01 03251, 2006
inhouseuk
cool! it would have been Eva Cassidy's birthday tomorrow
2006-02-01 03230, 2006
nechto13
inhouseuk, do you eliminate groups out of result set or not?
2006-02-01 03219, 2006
inhouseuk
I'm not extracting all the columns out of the table anyway
2006-02-01 03249, 2006
inhouseuk
oh you mean group artists?
2006-02-01 03256, 2006
nechto13
right
2006-02-01 03240, 2006
inhouseuk
yes, I've now included an extra where clause 'type = 1' which only returns persons
2006-02-01 03212, 2006
inhouseuk
it wasn't in the code I pasted earlier
2006-02-01 03255, 2006
nechto13 noticed
2006-02-01 03236, 2006
nechto13
i see, what about type unknown artists? they could be aliases for people? :)
2006-02-01 03201, 2006
inhouseuk
yes, they are currently being excluded
2006-02-01 03212, 2006
nechto13
*performance names
2006-02-01 03215, 2006
nechto13
why?
2006-02-01 03248, 2006
nechto13
cause it's hard to tell if it's a person or not?
2006-02-01 03254, 2006
inhouseuk
yup
2006-02-01 03200, 2006
inhouseuk
for today there is 20 rows checking for type = 1 and 25 rows without
2006-02-01 03225, 2006
inhouseuk
but normally if there is a begindate set, the person/group will be as well
2006-02-01 03223, 2006
inhouseuk
4 of the 25 rows are groups
2006-02-01 03234, 2006
nechto13
i doubted that MB used different date fields for people's birthdays and group's founding dates
2006-02-01 03223, 2006
inhouseuk
correct, the same field is used
2006-02-01 03240, 2006
nechto13
i don't think i know any music fans who are so hardcore that they celebrate the founding dates of their favorite groups though
the fact of the matter is i have plenty of stuff on my to do list and ISO wasn't on it. get n00bs to do it :P i have 32 volumes of visotsky in my queue
2006-02-01 03250, 2006
nikki_
yalaforge: maybe it should consistently stick to either UUID or MBID
2006-02-01 03222, 2006
yalaforge
nikki_: oh, right. I'm still not sure what the official term is. syntactically it's the ascii representation of a UUID
2006-02-01 03234, 2006
yalaforge
but we call it UUID, MBID and sometimes GID
2006-02-01 03259, 2006
yalaforge would like to pick one, but is not sure which
2006-02-01 03255, 2006
nikki_ always uses MBID, but isn't sure what everyone else thinks
2006-02-01 03206, 2006
yalaforge
I prefer that one, too
2006-02-01 03221, 2006
yalaforge
it should be irrelevant for users that it's a UUID, right?
2006-02-01 03240, 2006
nikki_
I assume so
2006-02-01 03205, 2006
yalaforge
ok, I'll change it. thanks!
2006-02-01 03227, 2006
yalaforge
done
2006-02-01 03232, 2006
nikki_
I like it more than UUID because a MBID is a UUID with some meaning in MB, you can't just shove any old UUID in and expect results :)
2006-02-01 03252, 2006
yalaforge
yeah, right. and there are different versions of UUIDs, too
2006-02-01 03209, 2006
yalaforge
(different ways to calculate them, which is irrelevant to users)
2006-02-01 03202, 2006
maloleche has quit
2006-02-01 03249, 2006
nikki_
hmm! it's apparently -0.3C outside, so presumably not much more in my bathroom
2006-02-01 03205, 2006
nikki_
I should just turn off the fridge and keep things in my bathroom.
2006-02-01 03246, 2006
nikki_
I gave up on trying to warm it up and just left the window open
2006-02-01 03254, 2006
nikki_
it's freezing in there now, but at least it smells nice
2006-02-01 03239, 2006
nikki_
it was freezing in there before, so it's no different.
2006-02-01 03202, 2006
nikki_ sighs and leaves
2006-02-01 03209, 2006
yalaforge
bye nikki!
2006-02-01 03229, 2006
nechto13 nudges yllona
2006-02-01 03236, 2006
yllona
yes?
2006-02-01 03259, 2006
nechto13
there are only 2 piano players left, which are called guest performers
2006-02-01 03217, 2006
nechto13
other then them there are stage managers, libririans, and so on
2006-02-01 03228, 2006
nechto13
do you want them in there?
2006-02-01 03214, 2006
yllona
once again, they would be "guests" for specific liver performers and/or recordings, so it's a non-issue unless you have the albums (or bootlegs)
