Converts numberical numbers to their full English form: unix.stackexchange.com/questions/413441/converting-numbers-into-full-written-words
For example:gives:
number 123456789123456789123456879123456789123456789123456879one hundred twenty-three sexdecillion.
four hundred fifty-six quindecillion.
seven hundred eighty-nine quattuordecillion.
one hundred twenty-three tredecillion.
four hundred fifty-six duodecillion.
seven hundred eighty-nine undecillion.
one hundred twenty-three decillion.
four hundred fifty-six nonillion.
eight hundred seventy-nine octillion.
one hundred twenty-three septillion.
four hundred fifty-six sextillion.
seven hundred eighty-nine quintillion.
one hundred twenty-three quadrillion.
four hundred fifty-six trillion.
seven hundred eighty-nine billion.
one hundred twenty-three million.
four hundred fifty-six thousand.
eight hundred seventy-nine.Many of the games are disabled by default on Ubuntu. But we can enable some games and build from source with:
apt-get source bsdgames
cd bsdgames-*
sed -ri '/^bsd_games_cfg_no_build_dirs=/s/ number / /' config.params
./configure
make -jHere we enabled the game number, so now we can:which gives:
number/number 123one hundred twenty-three.We can also "install" it locally with:which puts the games locally under:which you can add to your
make installdebian/bsdgames/usr/games/numberPATH environment variable.There are infinitely many conjectures asking if such types of primes also form infinite families.
Usually the answer is yes, but no one was able to prove it yet.
National Institute of Advanced Industrial Science and Technology Updated 2025-04-18 +Created 2024-12-13
Homepage: www.mysteryofmatter.net
Particularly tasteful is their choice of native speaker actors who speak their native language for less important narration, and English with an accent for more important moments, in particular when talking solo to the camera.
The Mystery of Matter episode 1
. Source. The Mystery of Matter episode 2
. Source. Covers:The Mystery of Matter episode 3
. Source. This one is good: stackoverflow.com/questions/36533429/generate-random-string-in-postgresql/44200391#44200391 as it also describes how to generate multiple values.
with symbols(characters) as (VALUES ('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'))
select string_agg(substr(characters, (random() * (length(characters) - 1) + 1)::INTEGER, 1), '')
from symbols
join generate_series(1,8) as word(chr_idx) on 1 = 1 -- word length
join generate_series(1,10000) as words(idx) on 1 = 1 -- # of words
group by idx;Then you can insert it into a row with:
create table tmp(s text);
insert into tmp(s)
select s from
(
with symbols(characters) as (VALUES ('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789'))
select string_agg(substr(characters, (random() * (length(characters) - 1) + 1)::INTEGER, 1), '') as asdf
from symbols
join generate_series(1,8) as word(chr_idx) on 1 = 1 -- word length
join generate_series(1,10000) as words(idx) on 1 = 1 -- # of words
group by idx
) as sub(s);A more convenient approach is likely to define the function:
CREATE OR REPLACE FUNCTION random_string(int) RETURNS TEXT as $$
select
string_agg(substr(characters, (random() * length(characters) + 1)::integer, 1), '') as random_word
from (values('ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789 --')) as symbols(characters)
join generate_series(1, $1) on 1 = 1
$$ language sql;And then:
create table tmp(s text, t text);
insert into tmp(s) select random_string(10) from generate_series(10);- output one column per line: stackoverflow.com/questions/9604723/alternate-output-format-for-psql-showing-one-column-per-line-with-column-name
- PostgreSQL does not automatically index foreign keys! stackoverflow.com/questions/970562/postgres-and-indexes-on-foreign-keys-and-primary-keys
There are unlisted articles, also show them or only show them.