plpgsql - can't get a simple block to execute

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

Responses

Browse pgsql-novice by date

  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