Try a pg function. http://www.postgresql.org/idocs/index.php?sql-createfunction.html CREATE FUNCTION one() RETURNS int4 AS 'SELECT 1 AS RESULT' LANGUAGE 'sql'; SELECT one() AS answer; answer -------- 1 If you are truly adventurous, you could create a 'constant' table and have the function take an argument, which is key to the table. Frank At 02:00 PM 2/4/02 +0000, Shane Wright wrote: >Hi > >This may be the wrong list to ask this, apologies if so :) > >Anyway, is there any way to define constants in PostgreSQL - my app has lots >of them at the PHP level, but it'd be nice to use them directly in the SQL >without overly complex query building. > >Something like this... > >DEFINE CONSTANT MYCONST = 4; > >SELECT * FROM mytable WHERE myfield=MYCONST; > > >Thanks > >-- >Shane > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx >
