"Igor Neyman" <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE FUNCTION exec_plpgsql_block(exec_string text)
> RETURNS BOOLEAN
> AS $THIS$
> DECLARE lRet BOOLEAN;
> BEGIN
> EXECUTE 'CREATE OR REPLACE FUNCTION any_block()
> RETURNS VOID
> AS $$ ' || exec_string || ' $$LANGUAGE PLPGSQL;' ;
> PERFORM a
executes it.
Pretty simple solution.
Igor Neyman
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Lane
Sent: Thursday, May 24, 2007 11:12 AM
To: Abraham, Danny
Cc: pgsql-admin@postgresql.org; Devrim GÜNDÜZ
Subject: Re: [ADMIN] anonymous block in
"Abraham, Danny" <[EMAIL PROTECTED]> writes:
> This code is my first "like Oracle anonymous blocl". It does not go =
> through.
There are no anonymous blocks in Postgres --- you must create a
function.
regards, tom lane
---(end of broadcast)---
#!/bin/sh
psql --quiet -t << EOF
declare
x varchar(80);
begin
x:='Hello World';
raise notice x;
end;
\q
EOF
==
Hi,
This code is my first "like Oracle anonymous blocl". It does not go through.
Can anyone help?
Thanks
Danny
