Re: declare variable in postgresql

From: Pavel Stehule <pavel(dot)stehule(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:15:41
Message-ID: BANLkTi=3RJ8EObu1OU=ooV4_vhXALN1PKg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello

2011/6/24 Jignesh Ramavat <ramavat(dot)jignesh(at)gmail(dot)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 do it - PostgreSQL does not support session variables

Regards

Pavel Stehule

> --
> Thanks & Regards,
> Jignesh Ramavat
> Software Engineer
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-06-24 15:16:52 Re: declare variable in postgresql
Previous Message Francisco Figueiredo Jr. 2011-06-24 15:09:13 Pgfoundry problem with Npgsql bug tracker