Re: [GENERAL] declare variable in postgresql

2011-06-24 Thread Brar Piening
On Fri, 24 Jun 2011 10:16:52 -0500, Merlin Moncure wrote: http://www.postgresql.org/docs/9.0/static/plpgsql.html http://www.postgresql.org/docs/9.0/static/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS Plus http://www.postgresql.org/docs/current/static/sql-do.html if want it the non

Re: [GENERAL] declare variable in postgresql

2011-06-24 Thread Merlin Moncure
On Fri, Jun 24, 2011 at 3:41 AM, Jignesh Ramavat 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

Re: [GENERAL] declare variable in postgresql

2011-06-24 Thread Pavel Stehule
Hello 2011/6/24 Jignesh Ramavat : > 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 - Postgr

[GENERAL] declare variable in postgresql

2011-06-24 Thread Jignesh Ramavat
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 ??? -- Thanks & Regards, Jignesh Ramavat Software Engineer