User-Defined Variables

From: "Daniel Futerman" <daniel(dot)futerman(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: User-Defined Variables
Date: 2008-07-10 08:15:11
Message-ID: 6ca02fc80807100115w5560ed1ay2a59e2a3e94eff19@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Is there a quick solution to implementing user-defined variables in
PostgreSQL as they are used in MySQL?

I have the following MySQL script which i want to implement in Postgres
(NOTE : all ` have been changed to " for Postgres use):

SET @OTHER_CONCEPT_ID = (SELECT "concept_id" FROM "concept_name" where name
= 'MRO' LIMIT 1);

Thanks,
Daniel.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-07-10 08:49:53 Re: User-Defined Variables
Previous Message Pavel Stehule 2008-07-10 06:02:16 Re: Array as parameter for stored procedure