On Fri, Jun 24, 2011 at 3:41 AM, Jignesh Ramavat
<ramavat.jign...@gmail.com> wrote:
> Hello,
>
> need help,
>
> Declare @TypeTransactionID As int";
>
> Select @TypeTransactionID=ID from TypeTransaction Where TypeTransactionCode
> = 'TxnBackupInc' ";
>
> these is in sqlserver. If i want to do same in postgresql then ???

http://www.postgresql.org/docs/9.0/static/plpgsql.html
http://www.postgresql.org/docs/9.0/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS

merlin

-- 
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