Postgres Pro
Downloads
Home   >   mailing lists

Re: declare variable in postgresql - Mailing list pgsql-general

From Pavel Stehule
Subject Re: declare variable in postgresql
Date
Msg-id BANLkTi=3RJ8EObu1OU=ooV4_vhXALN1PKg@mail.gmail.com
Whole thread Raw
In response to declare variable in postgresql  (Jignesh Ramavat <ramavat.jignesh@gmail.com>)
List pgsql-general
Tree view 
Hello

2011/6/24 Jignesh Ramavat <ramavat.jignesh@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 do it - PostgreSQL does not support session variables

Regards

Pavel Stehule

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

pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Pgfoundry problem with Npgsql bug tracker
Next
From: Merlin Moncure
Date:
Subject: Re: declare variable in postgresql