From: Aasmund Midttun Godal <postgresql@envisity.com>
To: roland@astrofoto.org
Cc: pgsql-docs@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] PL/pgSQL examples NOT involving functions
Date: Thu, 15 Nov 2001 21:50:49 GMT
Message-ID: <20011115215049.14167.qmail@ns.krot.org> (raw)
In-Reply-To: <m2adxoget3.fsf@tycho.rlent.pnet>
References: <m2adxoget3.fsf@tycho.rlent.pnet>
Well, to the best of my knowledge your question is a contradiction in terms:
plpgsql is a procedural language to use it you must create a stored procedure or function...
However you are probably able to do many of the things you may want with plain old SQL look it up in the docs especially the case structure.
Regards,
Aasmund.
On 15 Nov 2001 11:49:12 -0500, Roland Roberts <roland@astrofoto.org> wrote:
> How can I write a few lines of PL/pgSQL which do not involve creating
> a function? I can find no examples of this in the docs, but say I
> would like to do something like
>
> BEGIN
> IF EXISTS (SELECT * FROM foo WHERE idx = 27)
> THEN
> UPDATE foo SET var='some value' WHERE idx=27;
> ELSE
> INSERT INTO foo (idx, var) VALUES (27, 'some value');
> END IF
> END;
>
> roland
> --
> PGP Key ID: 66 BC 3B CD
> Roland B. Roberts, PhD RL Enterprises
> roland@rlenter.com 76-15 113th Street, Apt 3B
> roland@astrofoto.org Forest Hills, NY 11375
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
Aasmund Midttun Godal
aasmund@godal.com - http://www.godal.com/
+47 40 45 20 46
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: postgresql@envisity.com, roland@astrofoto.org, pgsql-sql@postgresql.org
Subject: Re: [SQL] PL/pgSQL examples NOT involving functions
In-Reply-To: <20011115215049.14167.qmail@ns.krot.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox