I forgot to say that what gets
inserted into the index table
is not what I want.
On Tue, Aug 14, 2001 at 11:25:27AM -0400, newsreader@mediaone.net wrote:
> Hello
>
> I am hacking the full text indexing
> c trigger found in contrib to suit my need.
> (I am a C idiot having never written any
> program in it)
>
> Anyhow I have gotten all I want except
> this last feature: to use a column other
> than oid.
>
> I have the following added
>
> char *id;
> ..
> colnum=SPI_fnumber(tupdesc,args[2]);
> id=SPI_getvalue(rettuple,tupdesc,colnum);
>
>
>
> I have also verified that id contains the column
> I want by doing
> elog(ERROR,id);
> and it does
>
> Now the original author uses
> Datum values[2];
> to insert the data and he has
> values[0] = PointerGetDatum(data);
> before he does
> ret = SPI_execp(*(plan->splan), values, NULL, 0);
>
> So I tried something
> values[1]=PointerGetDatum(id);
> as well as other variations without that
> function.
>
> Thanks in advance for any help
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
