Starting with pl/pgsql..

Поиск
Список
Период
Сортировка
От Terry Yapt
Тема Starting with pl/pgsql..
Дата
Msg-id 3D26C18B.F954DDF9@technovell.com
обсуждение исходный текст
Ответы Re: Starting with pl/pgsql..  (Josh Jore <josh@greentechnologist.org>)
Список pgsql-novice
Hello all,

I have starting with PostGreSQL. I come from Oracle 8i and 9i but we want to start using PostGreSQL in a few projects
andsee if it runs fine. 

I have testing now pl/pgsql language.  It is very important for me because I have a lot of oracle pl/sql code in all my
databasesand I think is better do almost everything will be possible on the server than the client... 

Ok.  I have read all Oracle -> PostGreSQL documents (Programmer, O'reilly book, etc)... and I am trying to do my first
pl/pgsql"procedure". 

First question:
  ONLY functions exists on pl/pgsql ?  No Procedures ?  No Packages ?

Second question:
  I am doing this and obtaining this too:
    www=# select x(10,40);
    NOTICE:  Error occurred while executing PL/pgSQL function x
    NOTICE:  line 8 at assignment
    ERROR:  zero-length delimited identifier

I have changed almost everything.  The way to do, variable names, etc.. but the same error (or others) I am obtained.

I don't understand anything.... and it is a TEST-EASY function.  :-((((

Thanks and best regards..

=============================================================
                Table "pepe"
 Column |         Type          | Modifiers
--------+-----------------------+-----------
 a      | numeric(2,0)          | not null
 b      | character varying(50) |
Primary key: pepe_pkey
=============================================================
-- Function: x(int4, int4)
CREATE FUNCTION "x"("int4", "int4") RETURNS "int4" AS '  DECLARE
     inicio alias for $1;
     final alias for $2;
     --
     texto varchar;
  BEGIN
    FOR X IN inicio..final LOOP
       texto := "ESTE ES: " || X;
       INSERT INTO pepe VALUES (X, texto);
    END LOOP;
  END;
' LANGUAGE 'plpgsql';
=============================================================



В списке pgsql-novice по дате отправления:

Предыдущее
От: Oliver Elphick
Дата:
Сообщение: Re: limiting a select
Следующее
От: Andrew McMillan
Дата:
Сообщение: Re: Carraige Return issue