Re: insert within pl/pgsql procedures: NOVICE question ?

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Jeff Anto <antojf2001(at)yahoo(dot)fr>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: insert within pl/pgsql procedures: NOVICE question ?
Date: 2002-02-13 22:25:10
Message-ID: 20020213142228.H10228-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Antonio Gennarini 2002-02-13 22:40:01 Can't upgrade from 7.0 to 7.1. Script failure.
Previous Message Tom Lane 2002-02-13 22:21:37 Re: insert within pl/pgsql procedures: NOVICE question ?