当在PostgreSQL查询中列长度>100时,我希望能够换行,以下是我的代码:
SELECT message, CASE WHEN length(message) > 100
THEN message||'\n' end as res FROM msg.list_trx
但是我的查询无法工作。
当在PostgreSQL查询中列长度>100时,我希望能够换行,以下是我的代码:
SELECT message, CASE WHEN length(message) > 100
THEN message||'\n' end as res FROM msg.list_trx
e
(对于类C的特殊字符是必需的):SELECT message, CASE WHEN length(message) > 100
THEN message||e'\n' end as res FROM msg.list_trx
create table messages (id int, message text);
insert into messages values
(1, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt'),
(2, 'Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque');
select id, regexp_replace(message, '(.{30})', e'\\1\n', 'g')
from messages
id | regexp_replace
----+--------------------------------
1 | Lorem ipsum dolor sit amet, co+
| nsectetur adipiscing elit, sed+
| do eiusmod tempor incididunt
2 | Sed ut perspiciatis unde omnis+
| iste natus error sit voluptat+
| em accusantium doloremque
(2 rows)