On Mon, May 3, 2010 at 10:44 AM, Andre Lopes <lopes80andre@xxxxxxxxx> wrote: > Hi, > > I need to write some dynamic SQL in pgsql. > > I have to do something like this: > > [code=SQL Server] > SET @STRINGN = @STRINGN + ' AND A.' + @CAMPOFECINI + ' IN (SELECT > MAX(B.' + @CAMPOFECINI + ') > FROM ' + @TABLA + ' B > WHERE B.ID_SOCIEDAD = A.ID_SOCIEDAD > AND B.ID_EMPREGAD = A.ID_EMPREGAD' > IF @F_ALTA IS NOT NULL > SET @STRINGN = @STRINGN + ' AND B.DAT_INI_ACT_EMP = > A.DAT_INI_ACT_EMP' > SET @STRINGN = @STRINGN + ')' > EXEC sp_executesql @STRINGN, > N'@FINI2 datetime out, @FFIN2 datetime out, @CAMP2 > varchar(50) out', > @FINI out, @FFIN out , @CAMP out > [/code] > > There is documentation on how can I do this in pgsql? > > Best Regards, > Hi Andre, This may helps http://www.postgresql.org/docs/8.4/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN Best regards, Jorge -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
