Re: problem with calling c functions - Mailing list pgsql-general

oops, got a little trigger-happy with the send button.

Question: Why isn't 12 printed after the second SELECT statement?

Thanks,

R.

On Thu, 21 Sep 2000, Richard Harvey Chapman wrote:

> I'll just show an example:
>
> I have:
>
> int myfunc (text *a, text* b)
> {
>  return(12);
> }
>
> in psql:
>
> test=# CREATE FUNCTION myfunc(text, text)
> test-# RETURNS integer
> test-# AS
> '/home/hchapman/src/nms/wwp_database/c-functions/call_dynamic.so'
> test-# LANGUAGE 'C';
> CREATE
> test=# SELECT myfunc('aa','ss') as result;
>  result
> --------
>      12
> (1 row)
>
> test=# SELECT myfunc('aa',NULL) as result;
>  result
> --------
>
> (1 row)
>
> test=#
>