On 01/12/2012 19:44, Peter Kroon wrote:
> Mmmmm.......
> 
> How do I execute dynamic sql that starts with an if statement.
> I'm converting mssql code to pgsql.
> 

Without trying it, I'd guess that you need to have the IF outside the
dynamic code, something like this:

  if .... then
    execute '.....';
  end if;

If you show what you're trying to achieve, someone might be able to
suggest something better.

Ray.

-- 
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to