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

From: Darren Ferguson <darren(at)crystalballinc(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:04:16
Message-ID: Pine.LNX.4.10.10202131703260.30509-100000@thread.crystalballinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You have not given us any information regarding table type or error
message that you are getting from the running of the function.

If you provide this information then we might be able to help

Darren

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 ?
>
> I (quickly) checked the idocs and didn't found
> anything about that... so, amazing discovery or stupid
> question ?
>
> Regards,
> Jeff.
>
> ___________________________________________________________
> Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en franais !
> Yahoo! Mail : http://fr.mail.yahoo.fr
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-02-13 22:21:37 Re: insert within pl/pgsql procedures: NOVICE question ?
Previous Message Jeff Anto 2002-02-13 21:50:40 insert within pl/pgsql procedures: NOVICE question ?