Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
What do you get with the following two type castings: SELECT coalesce(column_name::integer, 255); ?SELECT coalesce(column_name, ‘255’::text)::integer; ? “integer” might actually be “smallint” if you’re only going to 255. --Stephen From: Chamath Sajeewa <csgsajeewa@gmail.com> Sent: Monday, July 27, 2020 10:51To: pgsql-novice@lists.postgresql.orgSubject: Pgsql error in coalesce Hi,There is table with int4 column. When select query is executed as "select coalesce(column_name, 255), query is failing with below error."COALESCE types text and integer cannot be mached".Any idea?Thank You!!
What do you get with the following two type castings:
SELECT coalesce(column_name::integer, 255); ?
SELECT coalesce(column_name, ‘255’::text)::integer; ?
“integer” might actually be “smallint” if you’re only going to 255.
--Stephen
From: Chamath Sajeewa <csgsajeewa@gmail.com> Sent: Monday, July 27, 2020 10:51To: pgsql-novice@lists.postgresql.orgSubject: Pgsql error in coalesce
Hi,
There is table with int4 column. When select query is executed as "select coalesce(column_name, 255), query is failing with below error.
"COALESCE types text and integer cannot be mached".
Any idea?
Thank You!!
В списке pgsql-novice по дате отправления: