User avatar
Jeder neocat_floof_googly_woozy neocat_flag_agender 🔜 eth0 @jeder@miau.jeder.pl
2y
anyway
how the fuck do you get a root domain from a string in sql
4
0
0
0
User avatar
猫猫 verifiedsabakan antifa disability_flag @puniko@mk.absturztau.be
2y
@jeder regexp magic maybe?
1
0
0
0
User avatar
Jeder neocat_floof_googly_woozy neocat_flag_agender 🔜 eth0 @jeder@miau.jeder.pl
2y
@puniko i am useless at that
1
0
1
0
User avatar
Jeder neocat_floof_googly_woozy neocat_flag_agender 🔜 eth0 @jeder@miau.jeder.pl
2y
@puniko I'd expect something more akin to, idk, a .split() or some shit
1
0
0
0
User avatar
猫猫 verifiedsabakan antifa disability_flag @puniko@mk.absturztau.be
2y
@jeder well then split_part might be what you are looking for. you can pass a negative index to it, so it goes from the end of the string
split_part ( string text, delimiter text, n integer ) → text
www.postgresql.org/docs/16/functions-string.html
1
0
0
0
User avatar
Jeder neocat_floof_googly_woozy neocat_flag_agender 🔜 eth0 @jeder@miau.jeder.pl
2y
@puniko i definitely have like
a what I'd need to do because I just got reminded of existence of co.uk

but yeah
my sql is Bad
This note is quoting brain.d.on-t.work/notes/9xydrmp608xvbsgc
:neocat_googly_woozy@mk.absturztau.be:1
1
0
0
1
User avatar
猫猫 verifiedsabakan antifa disability_flag @puniko@mk.absturztau.be
2y
@jeder ye, domains be mess as well
0
0
0
0