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: fa96e3c604100311057aa68c4c@mail.gmail.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group