вт, 26 нояб. 2024 г. в 14:34, Tim McLaughlin <t...@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
