Re: Escaping in C-language functions

Joe Conway wrote:
>
> Andreas Scherbaum wrote:
> > Hello,
> >
> > i have a C-language function and need to escape some strings returned
> > from SPI_getvalue to insert into another query string.
> > Is there a proper way to do the escaping or should i use
> > my own functions for that?
> > Or i'm totally wrong and there's a better way to get the values
> > from a row and insert it into another table?

> If you are using 7.2, see section 1.3.2. (Escaping strings for inclusion
> in SQL queries) at:
> http://www.us.postgresql.org/users-lounge/docs/7.2/postgres/libpq-exec.html
>
> If you are using < 7.2, you'll have to create your own function. See
> fe-exec.c in current sources for the 7.2 function.

I'm inside a C-language function (on the server side), not inside a
application written in C.


Best regards

--
                                  Andreas 'ads' Scherbaum