Strange Behavior when calling a C function by a plpgsql stored prcedure

Lists: pgsql-bugs
From: Alban Médici <amedici(at)fr(dot)netcentrex(dot)net>
To: plpgsql <pgsql-bugs(at)postgresql(dot)org>
Subject: Strange Behavior when calling a C function by a plpgsql stored prcedure
Date: 2002-05-03 14:57:07
Message-ID: 3CD2A543.5030408@fr.netcentrex.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

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
= -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 !!!!!!

--
Alban Médici
R&D Software Engineer
tel: +33 (0)2 31 46 35 80 (+005)
--------------------------------
http://www.netcentrex.net
amedici(at)fr(dot)netcentrex(dot)net

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alban Médici <amedici(at)fr(dot)netcentrex(dot)net>
Cc: plpgsql <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Strange Behavior when calling a C function by a plpgsql stored prcedure
Date: 2002-05-03 15:29:55
Message-ID: 7503.1020439795@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

Alban =?ISO-8859-1?Q?M=E9dici?= <amedici(at)fr(dot)netcentrex(dot)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 unknown to CREATE FUNCTION. You'll have to make two
distinct functions if you want to have two calling styles.

regards, tom lane