Re: User-Defined Variables - Mailing list pgsql-general

Hello

PostgreSQL doesn't support this  feature. There are some techniques
that you can use:
http://www.pgsql.cz/index.php/PostgreSQL_SQL_Tricks#Any_other_session_variables
http://www.postgresql.org/docs/8.3/static/plperl-global.html

Regards
Pavel Stehule


2008/7/10 Daniel Futerman <daniel.futerman@gmail.com>:
> 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.
>