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: fa96e3c604100311057aa68c4c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
> http://www.postgresql.org/docs/current/interactive/sql-
> createfunction.html
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>

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

In response to

Responses

Browse pgsql-novice by date

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