Re: PL/C functions - Mailing list pgsql-general

From Dennis Gearon
Subject Re: PL/C functions
Date
Msg-id 3F395F65.4040508@cvc.net
Whole thread Raw
In response to Re: PL/C functions  (Joe Conway <mail@joeconway.com>)
Responses Re: PL/C functions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
One final note on this topic, (for me), if I write a C function that changes one of the LOCALES:

    1/ Will it change the LOCALE at all?
    2/ Does it change it for the whole program, affecting other, asynchronous
        execution within any of the modules of the dbase?

Joe Conway wrote:

> Tom Lane wrote:
>
>> 1. There is no provision for a single pg_proc entry to have a variable
>> number of arguments.
>>
>> 2. You can make multiple pg_proc entries referencing the same C
>> function.  The C function can find out how many arguments it was
>> actually passed (use PG_NARGS()).
>>
>> So you could make several different pg_proc entries and get the desired
>> effect, at some tedium.
>>
>> Joe Conway has posted a few examples using this approach, IIRC.
>>
>
> See contrib/dblink in 7.4beta -- there are several functions using this
> method, e.g. dblink_connect().
>
> Joe
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>


pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: PL/C functions
Next
From: Dennis Gearon
Date:
Subject: Re: Simple DBI question