Re: change JSON serialization for BIGINT?

Поиск
Список
Период
Сортировка
От Victor Yegorov
Тема Re: change JSON serialization for BIGINT?
Дата
Msg-id CAGnEbohqVqmA6gJgKmHqANMYHNtyAxv-3U3izEUVfoKoMZp-FA@mail.gmail.com
обсуждение исходный текст
Ответ на change JSON serialization for BIGINT?  (Tim McLaughlin <tim@gotab.io>)
Ответы Re: change JSON serialization for BIGINT?
Список pgsql-general
вт, 26 нояб. 2024 г. в 14:34, Tim McLaughlin <tim@gotab.io>:
Is there a way to have Postgres serialize BIGINT as a string rather than number in JSON?  By default it does this:


select row_to_json(row(500::bigint));
 row_to_json 
-------------
 {"f1":500}

But I want it to do this (note that "500" is quoted):

select row_to_json(row(500::bigint));
 row_to_json 
-------------
 {"f1":"500"}

Will this work?

select row_to_json(row(500::text));

--
Victor Yegorov

В списке pgsql-general по дате отправления: