On 10.06.2024 09:25, Kyotaro Horiguchi wrote:
I guess that in English, when written as "'Login' = 'yes/no'", it can
be easily understood. However, in Japanese, "'ログイン' = 'はい/いいえ'"
looks somewhat awkward and is a bit difficult to understand at a
glance. "'ログイン' = '可/不可'" (equivalent to "Login is
'can/cannot'") sounds more natural in Japanese, but it was rejected
upthread, and I also don't like 'can/cannot'. To give further
candidates, "allowed/not allowed" or "granted/denied" can be
mentioned, and they would be easier to translate, at least to
Japanese. However, is there a higher likelihood that 'granted/denied'
will be misunderstood as referring to database permissions?
Thank you for looking into this, translationis important.
What do you think about the following options?
1. Try to find a more appropriate name for the column.
Maybe "Can login?" is better suited for yes/no and Japanese translation?
2. Show the value only for true, for example "Granted" as you suggested.
Do not show the "false" value at all. This will be consistent
with the "Attributes" column, which shows only enabled values.
I would prefer the first option and look for the best name for the column.
The second option can also be implemented if we сhoose a value for 'true'.
BTW, I went through all the \d* commands and looked at how columns with
logical values are displayed. There are two approaches: yes/no and t/f.
yes/no
\dAc "Default?"
\dc "Default?"
\dC "Implicit?"
\dO "Deterministic?"
t/f
\dL "Trusted", "Internal language"
\dRp "All tables", "Inserts" "Updates" "Deletes" "Truncates" "Via root"
\dRs "Enabled", "Binary", "Disable on error", "Password required", "Run as owner?",
"Failover"
Likewise, "'Valid until' = 'infinity'" (equivalent to "'有効期限' = '
無限'") also sounds awkward. Maybe that's the same in English. I guess
that 'unbounded' or 'indefinite' sounds better, and their Japanese
translation '無期限' also sounds natural. However, I'm not sure we
want to go to that extent in transforming the table.
'infinity' is the value in the table as any other dates.
As far as I understand, it is not translatable.
So you'll see '有効期限' = 'infinity'.
Butthis can be implemented usingthe followingexpression: case when
rolvaliduntil = 'infinity' or rolvaliduntil is null then
'unbounded' -- translatable value
else
rolvaliduntil::pg_catalog.text
end
Or we can hide 'infinity':
case when rolvaliduntil = 'infinity' then
null
else
rolvaliduntil
end
This is a little bit better, but I don't like both. Wewill notbe ableto
distinguishbetween nullandinfinity values inthe table. After all, I
think 'infinity' is a rare case for "Valid until". Whatis the reasonto
set'Validuntil'='infinity'ifthe passwordisunlimitedbydefault? Therefore,
my opinion here is to leave "infinity" as is, but I am open to better
alternatives.
--
Pavel Luzanov
Postgres Professional:https://postgrespro.com
