somebody could explain this?
От | Cristian Prieto |
---|---|
Тема | somebody could explain this? |
Дата | |
Msg-id | 008901c5e15b$2a0b14d0$6500a8c0@gt.ClickDiario.local обсуждение исходный текст |
Ответы |
Re: somebody could explain this?
Re: somebody could explain this? Re: somebody could explain this? Re: somebody could explain this? |
Список | pgsql-hackers |
Hello, I'm using PostgreSQL 8.0.4 in Fedora Core 3, right now I'm learning a little about the postgresql internals and the way some kind of SPs could be written in c language; I found something really weird and I cannot explain to me this behavior: #include "postgres.h" #include "fmgr.h" PG_FUNCTION_INFO_V1(test); Datum repeat_item(PG_FUNCTION_ARGS) {int num_times;num_times = PG_GETARG_FLOAT8(0) * 100;PG_RETURN_INT32(num_times); } Inside psql this happens: # Create or replace function test(float) returns integer as 'test.so' language 'c' stable; select test(0.1); Returns 10 Select test(0.11); Returns 11 Select test(0.12) Returns 11 Select test(0.13) Returns 13 Select test(0.14) Returns 14 Select test(0.15) Returns 14 What Is happening here?
В списке pgsql-hackers по дате отправления: