C-language stored function and float4 type - Mailing list pgsql-general

From whiplash
Subject C-language stored function and float4 type
Date
Msg-id 52508872.7020301@bss.org.ua
Whole thread Raw
Responses Re: C-language stored function and float4 type  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: C-language stored function and float4 type  (sachin kotwal <kotsachin@gmail.com>)
List pgsql-general
Hello! I have C-language stored function like this:

#include <postgres.h>
#include <fmgr.h>

#ifdef PG_MODULE_MAGIC
     PG_MODULE_MAGIC;
#endif

PG_FUNCTION_INFO_V1(testfunc);

Datum testfunc(PG_FUNCTION_ARGS)
{
     float4 x = PG_GETARG_FLOAT4(0);
     float4 y = PG_GETARG_FLOAT4(1);

     PG_RETURN_FLOAT4(x + y);
}

CREATE FUNCTION testfunc ( x real, y real )
RETURNS real AS
'testfunc'
LANGUAGE C STRICT;

If i use this function (SELECT testfunc ( 0.1, 0.2 )) I get result with
type "double precision". I tried used float4 but the result was the
same. What is wrong?


pgsql-general by date:

Previous
From: Patrick Dung
Date:
Subject: Re: Major upgrade of PostgreSQL and MySQL
Next
From: 高健
Date:
Subject: Why there are no max_wal_receivers