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
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?) |