Hello 2011/6/24 Jignesh Ramavat <ramavat.jignesh@xxxxxxxxx>: > 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 ??? > you can't do it - PostgreSQL does not support session variables Regards Pavel Stehule > -- > Thanks & Regards, > Jignesh Ramavat > Software Engineer > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general