iakio #6999(2008/08/06 09:49 GMT) [ SQL ] Rating2/2=1.00
PostgreSQL 8.3以降です
1 2 3
SELECT array_to_string(ARRAY( SELECT upper(substr(s, 1, 1)) || substr(s, 2) FROM (SELECT regexp_split_to_table('LL day and night', E'\\s')) r(s)), ' ');
Rating2/2=1.00-0+
[ reply ]
iakio
#6999()
[
SQL
]
Rating2/2=1.00
PostgreSQL 8.3以降です
Rating2/2=1.00-0+
[ reply ]