How to convert a double value to a numeric datum type in pgsql?

Поиск
Список
Период
Сортировка
От Felix.徐
Тема How to convert a double value to a numeric datum type in pgsql?
Дата
Msg-id CAPmhLM3gYve69WmbTXQQvSnSyKvfXhCN7y1jsR91GUVuOvzcUA@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to convert a double value to a numeric datum type in pgsql?  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-general
Hi all,
I'm talking about the source code of pgsql and I want to know how the typing system works in pgsql.
A few functions can help us do the type conversion, for example:

Int32GetDatum -- convert a integer to a datum
Float8GetDatum -- convert double to a datum
cstring_to_text -- convert a string to a text
...

but there are a lot of types in pgsql,how to choose the corresponding function? or is there a more automatic way to do the type conversion(raw chars to a datum, suppose I have the corresponding Form_pg_type instance)?

I ask this question because I don't know how to convert a double value to a numeric datum(the field's type is numeric(10,2)), pg_type shows that numeric's typlen is -1 whose length is variable thus Float8GetDatum is not working..




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Why does PostgreSQL ftruncate before unlink?
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: How to continue streaming replication after this error?