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

From whiplash
Subject Re: C-language stored function and float4 type
Date
Msg-id 525E6DF1.9000404@bss.org.ua
Whole thread Raw
In response to Re: C-language stored function and float4 type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Sorry, I created an overloaded function and forgot about it.
> whiplash <whiplash@bss.org.ua> writes:
>> Hello! I have C-language stored function like this:
>> 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".
> What's your basis for asserting that?  The function is clearly defined
> to return float4.
>
>             regards, tom lane
>



pgsql-general by date:

Previous
From: ginkgo36
Date:
Subject: Help function to sort string
Next
From: Kaveh Mousavi Zamani
Date:
Subject: Missing record in binary replica 9.3.0