constants

[Shane Wright <me@xxxxxxxxxxxxxxxxx>]

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