[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

Re: [GENERAL] declare variable in postgresql

2011-06-24 Thread Pavel Stehule
Hello 2011/6/24 Jignesh Ramavat ramavat.jign...@gmail.com: 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

Re: [GENERAL] declare variable in postgresql

2011-06-24 Thread Merlin Moncure
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

Re: [GENERAL] declare variable in postgresql

2011-06-24 Thread Brar Piening
On Fri, 24 Jun 2011 10:16:52 -0500, Merlin Moncure mmonc...@gmail.com 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