Re: insert within pl/pgsql procedures: NOVICE question ? - Mailing list pgsql-general

On Wed, 13 Feb 2002, [iso-8859-1] Jeff Anto wrote:

> Hi list,
>
> tedious experience:
> am I wrong or the optionnal syntax
> INSERT INTO foo(foo_col1) VALUES ('blahblah');
> dosen't work within a PLPGSQL-written function ?

It should, barring that you need to escape ' characters
inside plpgsql function declarations.