How to CREATE FUNCTION into PostgreSQL

Поиск
Список
Период
Сортировка
От Marcos Cruz
Тема How to CREATE FUNCTION into PostgreSQL
Дата
Msg-id 200403161332.51200.Marcos.Cruz@cenpra.gov.br
обсуждение исходный текст
Ответы Re: How to CREATE FUNCTION into PostgreSQL
Список pgsql-general
Hi,

I need to create a function to convert a string with a portuguese float-point
representation ( thousand sep = dot, decimal point = comma) to a float8.

When I execute the SQL:
SELECT replace(replace ('1.234.567,08', '.', ''), ',' , '.')::float8 AS test;

the result was the number 1234567.08, which may insert
as a float8 field of a table

When I issue the SQL:
CREATE FUNCTION to_double(text) RETURNS float8 AS
'SELECT (replace(replace(text, '.' , '') , ',' , '.')::float8 AS RESULT
LANGUAGE SQL

it generates an error and function isn't created.

Someone can help me?

Thaks in advance,
Marcos


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

Предыдущее
От: Andreas
Дата:
Сообщение: Re: Postmaster won't run as service on Cygwin
Следующее
От: Tom Lane
Дата:
Сообщение: Re: compilation on solaris2.8