Обсуждение: Strange Behavior when calling a C function by a plpgsql stored prcedure

In some plpgsql method, I call some C function with a optional parameters.<br /><br /> This is the signature of my
function:<br /><br /><i>extern "C" My_Mem_Macro_Parser_Integer myMethod( int nbFields, int toto = -1)<br /> {<br />
blablabla.....<br /> return integer;<br /> }<br /></i><br /><br /> When I call this function with the second
parameters,there's no problems.<br /><br /> But if I call without toto :<br /> plpgsql:<br /><br /><i>CREATE FUNCTION
CallMymethodWithoutToto(     INTEGER        -- [IN] nb Field<br /> )<br /> RETURNS INTEGER AS '<br />     
'path2MyLib/MyLib.so','myMethod'<br /> LANGUAGE 'C';</i><br /><br /> Appear a strange Behavior :<br /> I'm explain,<br
/>in myC function, I switch the value of toto, try to find "-1".<br /> But I NEVER have "-1".<br /><br /> I this case I
alwayshave "8" in toto integer !!!!!!<br /><br /><br /><br /><pre class="moz-signature" cols="$mailwrapcol">--  
Alban Médici
R&D Software Engineer
tel: +33 (0)2 31 46 35 80 (+005)
--------------------------------
<a class="moz-txt-link-freetext" href="http://www.netcentrex.net">http://www.netcentrex.net</a>
<a class="moz-txt-link-abbreviated" href="mailto:amedici@fr.netcentrex.net">amedici@fr.netcentrex.net</a></pre>

Alban Médici <amedici@fr.netcentrex.net> writes:
> extern "C" My_Mem_Macro_Parser_Integer myMethod( int nbFields, int toto
> = -1)

Default parameters are a C++-ism that doesn't exist in C, and certainly
is entirely iso-8859-1 to CREATE FUNCTION.  You'll have to make two
distinct functions if you want to have two calling styles.
        regards, tom lane

Default parameters are filled in by the C++ compiler.  You must provide
them when calling from a non-C++ program.

-----Original Message-----
From: Alban M=E9dici [mailto:amedici@fr.netcentrex.net]
Sent: Friday, May 03, 2002 10:57 AM
To: plpgsql
Subject: [BUGS] Strange Behavior when calling a C function by a plpgsql
stored prcedure


In some plpgsql method, I call some C function with a optional
parameters.

This is the signature of my function :

extern "C" My_Mem_Macro_Parser_Integer myMethod( int nbFields, int toto
=3D -1)
{
blablabla .....
return integer;
}


When I call this function with the second parameters, there's no
problems.

But if I call without toto :
plpgsql:

CREATE FUNCTION CallMymethodWithoutToto (     INTEGER        -- [IN] nb
Field
)
RETURNS INTEGER AS '
     'path2MyLib/MyLib.so', 'myMethod'
LANGUAGE 'C';

Appear a strange Behavior :
I'm explain,
in myC function, I switch the value of toto, try to find "-1".
But I NEVER have "-1".

I this case I always have "8" in toto integer !!!!!!




--=20
Alban M=E9dici
R&D Software Engineer
tel: +33 (0)2 31 46 35 80 (+005)
--------------------------------
http://www.netcentrex.net
amedici@fr.netcentrex.net