Re: to_hex() for negative inputs

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: to_hex() for negative inputs
Дата
Msg-id ac4df0fb-5b57-4c18-30c1-c24d42e562b6@enterprisedb.com
обсуждение исходный текст
Ответ на to_hex() for negative inputs  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Ответы Re: to_hex() for negative inputs  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
On 24.01.23 14:10, Dean Rasheed wrote:
> I also think it might be useful for it to gain a couple of boolean options:
> 
> 1). An option to output a signed value (defaulting to false, to
> preserve the current two's complement output).

I find the existing behavior so strange, I would rather give up and 
invent a whole new function family with correct behavior, which could 
then also support octal and binary, and perhaps any base.  This could be 
something generally named, like "convert" or "format".

> 2). An option to output the base prefix "0x" (which comes after the
> sign, making it inconvenient for the user to add themselves).

This could also be handled with a "format"-like function.




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

Предыдущее
От: Nathan Bossart
Дата:
Сообщение: Re: pgsql: Rename contrib module basic_archive to basic_wal_module
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql: Rename contrib module basic_archive to basic_wal_module