declare variable in postgresql

From: Jignesh Ramavat <ramavat(dot)jignesh(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: declare variable in postgresql
Date: 2011-06-24 08:41:32
Message-ID: BANLkTi=mGEM8yMhmwqMXNtXYU5WCB4ArCA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-06-24 09:15:35 Re: Help making tablespaces work for my application
Previous Message tv 2011-06-24 08:16:50 Re: PostgreSQL 8.4.8 bringing my website down every evening