Re: execute if statement

Mmmmm.......

How do I execute dynamic sql that starts with an if statement.
I'm converting mssql code to pgsql.

2012/12/1 Raymond O'Donnell <rod(at)iol(dot)ie>

> On 01/12/2012 19:11, Peter Kroon wrote:
> > How can I achieve this?
> >
> > EXECUTE '
> >
> > if 1=1 then
> > raise notice ''%'', ''notice has been raised...'';
> > end if;
> >
> > ';
>
> I think EXECUTE used like this is available only in a function:
>
> create or replace function my_function()
> returns void
> as
> $$
> begin
> execute ....
> end;
> $$
> language plpgsql;
>
> In "ordinary" SQL, EXECUTE executes a prepared statement.
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod(at)iol(dot)ie
>