RE: version 1 C-Language Functions
От | Gowey, Geoffrey |
---|---|
Тема | RE: version 1 C-Language Functions |
Дата | |
Msg-id | E15F4B031E17D5118B18009027F67927DAC8@SERVER обсуждение исходный текст |
Ответ на | version 1 C-Language Functions ("Gowey, Geoffrey" <ggowey@rxhope.com>) |
Ответы |
Re: version 1 C-Language Functions
|
Список | pgsql-general |
Those functions demonstrate copying text input. I am not. I'm trying to use a parameter entered as part of a select statement that will generated. I need PG_GETARG_CSTRING(x) for this task, not PG_GETARG_TEST. The way the program will work is it will sandwitch together the select statement into a single var (w/ the param in the middle) using strcat and then feed it to SPI for execution. No example that I have run across illustrates how to convert a param entered to be used w/ regular c functions (in this case strcat). Geoff -----Original Message----- From: Francesco Casadei [mailto:f_casadei@libero.it] Sent: Sunday, August 26, 2001 11:41 AM To: Gowey, Geoffrey Cc: 'Tom Lane'; 'pgsql-general@postgresql.org' Subject: Re: [GENERAL] version 1 C-Language Functions On Sat, Aug 25, 2001 at 08:04:37PM -0400, Gowey, Geoffrey wrote: > What would the correct syntax be in order to do what I want to? I need to > enter in a variable length email address as the parameter to my planned > function. The param will then become part of a select statement to get > records (which I currently plan to accomplish by using strcat to join the > beginning of the select plus the param plus the closing '. Also where is > some good documentation on V1 command usage and examples? > > Geoff > > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us] > Sent: Saturday, August 25, 2001 7:29 PM > To: Gowey, Geoffrey > Cc: 'pgsql-general@postgresql.org' > Subject: Re: [GENERAL] version 1 C-Language Functions > > > "Gowey, Geoffrey" <ggowey@rxhope.com> writes: > > Unfortunately, this function fails. What am i doing wrong? > > "text *" is not "char *". The equivalent V0 code would fail just the > same way. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://www.postgresql.org/search.mpl > > end of the original message Read the "Programmer's Guide", part II "Server Programming", section 13.4.3 "Version-1 Calling Conventions for C-Language Functions". Look at the example functions copytext and concat_text. Francesco Casadei
В списке pgsql-general по дате отправления: