Skip site navigation (1) Skip section navigation (2)

Re: Writing plpgsql not in a function (directly from plsql)?

From: Vitaly Belman <vitalyb(at)gmail(dot)com>
To: John DeSoi <jd(at)icx(dot)net>
Cc: Postgresql Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Writing plpgsql not in a function (directly from plsql)?
Date: 2004-10-03 18:05:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
The idea is to write it without creating a function... Just as a quick script.

Not possible? :(

On Sun, 3 Oct 2004 11:21:50 -0400, John DeSoi <jd(at)icx(dot)net> wrote:
> On Oct 2, 2004, at 5:59 PM, Vitaly Belman wrote:
> > Is it possible to write plpgsq from psql? I don't want to write a
> > function just to write a little script, for example, I'd like to write
> > something like:
> You can do this from psql, but you need to use the CREATE FUNCTION
> command and enclose your procedure body in quotes.
> See
> createfunction.html
> John DeSoi, Ph.D.
> Power Tools for PostgreSQL

 ICQ: 1912453
 AIM: VitalyB1984
 MSN: tmdagent(at)hotmail(dot)com
 Yahoo!: VitalyBe

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2004-10-03 21:27:25
Subject: Re: Stable function semantics (was Re: Mislabeled timestamp functions)
Previous:From: Mike RylanderDate: 2004-10-03 14:49:12
Subject: Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group