Postgres Pro
Downloads
Home   >   mailing lists

User-Defined Variables - Mailing list pgsql-general

From Daniel Futerman
Subject User-Defined Variables
Date
Msg-id 6ca02fc80807100115w5560ed1ay2a59e2a3e94eff19@mail.gmail.com
Whole thread Raw
Responses Re: User-Defined Variables
Re: User-Defined Variables
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "Vyacheslav Kalinin"
Date:
Subject: Re: Inaccurate row count estimation
Next
From: "Pavel Stehule"
Date:
Subject: Re: User-Defined Variables