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@xxxxxxxxx>: > 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. >
