Re: PL/SQL question

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: "Froggy / Froggy Corp(dot)" <froggy(at)froggycorp(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/SQL question
Date: 2004-04-21 17:25:43
Message-ID: 20040421102501.T59113@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Wed, 21 Apr 2004, Froggy / Froggy Corp. wrote:

> In fact the problem seems to come from the "INSERT INTO". I delete
> everything from the function and only keep the "INSERT INTO" and get the
> same problem.

A function like:
create function fz1() returns void as '
begin
INSERT INTO categorie (nom) VALUES (''test'');
RETURN;
end;' language 'plpgsql';

seems to work for me, what are you trying precisely?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2004-04-21 17:28:03 Re: Replication
Previous Message Marc G. Fournier 2004-04-21 17:11:16 Re: [OT] Tom's/Marc's spam filters?