On Mon, May 3, 2010 at 10:44 AM, Andre Lopes <lopes80andre@gmail.com> 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