Re: declare variable in postgresql

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Jignesh Ramavat <ramavat(dot)jignesh(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: declare variable in postgresql
Date: 2011-06-24 15:16:52
Message-ID: BANLkTik10p-VxOcW13mHAgqy6fcK2HHYDg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 24, 2011 at 3:41 AM, Jignesh Ramavat
<ramavat(dot)jignesh(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brar Piening 2011-06-24 15:53:07 Re: declare variable in postgresql
Previous Message Pavel Stehule 2011-06-24 15:15:41 Re: declare variable in postgresql