From: | "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> |
---|---|
To: | "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org> |
Subject: | plpgsql - can't get a simple block to execute |
Date: | 2005-04-05 18:53:30 |
Message-ID: | 41669DC6FE3B80449A33A4DD46DB370A09E7E97B@entcoexch15.broadband.att.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I'm resending as I didn't get any response earlier.
> This should be simple, but it's not. I think I'm just missing something
> simple. I converted an oracle PL/SQL program to plpgssql, but it wouldn't
> work, so I tried some very simple blocks, and even they fail. As far as I
> can tell, the syntax is all valid.
>
Any help would be appreciated.
> (postgres) robux:/opt/postgres/VRNJED
> ->cat it.sql
>
> \echo raise notice attempt
> begin
> raise notice 'hello';
> end;
>
> \echo select into attempt
> declare
> i_int integer;
> begin
> select count(1) into i_int from vrnsys_version;
> end;
>
> (postgres) robux:/opt/postgres/VRNJED
> ->psql -U vrnsys
> Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help on internal slash commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> VRNJED=> \i it.sql
> raise notice attempt
> psql:it.sql:4: ERROR: parser: parse error at or near "raise" at character
> 9
> psql:it.sql:5: WARNING: COMMIT: no transaction in progress
> COMMIT
> select into attempt
> psql:it.sql:9: ERROR: parser: parse error at or near "integer" at
> character 17
> psql:it.sql:11: ERROR: parser: parse error at or near "select" at
> character 8
> psql:it.sql:12: WARNING: COMMIT: no transaction in progress
> COMMIT
> VRNJED-> \q
> (postgres) robux:/opt/postgres/VRNJED
> ->
>
> Jed S. Walker
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Celia McInnis | 2005-04-05 19:17:34 | casting for bit strings in plpgsql. |
Previous Message | Eduardo Vázquez Rodríguez | 2005-04-05 18:44:50 | Postgres Out of Memory |