SELECT
string_agg(chr(num), '') OVER (ROWS BETWEEN 0 PRECEDING AND 2 FOLLOWING)
FROM generate_series(65, 90) num
LIMIT 24;
string_agg
------------
ABC
BCD
CDE
DEF
EFG
FGH
GHI
HIJ
IJK
JKL
KLM
LMN
MNO
NOP
OPQ
PQR
QRS
RST
STU
TUV
UVW
VWX
WXY
XYZ
(24 rows)
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme
List of users who liked
23