How to create a stand alone plpgsql proc - Mailing list pgsql-general

Dear Sir：
　　In Oracle, I can create a procedure like following:

    DECLARE
      A NUMBER;
    BEGIN
       INSERT INTO DB1 VALUES(A);
    END;
    /
    and I run it(a.sql) use: sqlplus user/passwd @a.sql

    How I create a plpgsql that like the procedure above?
    (no 'create function', 'create procedure' ..., just a procedure
    that I can run?)
    And how to run it?

             Thank your
==================================================================
新浪網．免費 50MB 電子信箱  http://www.sinamail.com