Received: from smtp-relay.noc.dsvr.net (smtp-relay.noc.dsvr.net [212.69.192.4]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g14E12l28328 for ; Mon, 4 Feb 2002 09:01:03 -0500 (EST) (envelope-from me@shanewright.co.uk) Received: from [212.69.206.2] (helo=fullerruss.dsvr.co.uk) by smtp-relay.noc.dsvr.net with esmtp (Exim 3.16 #1) id 16Xjfz-000AGV-00 for pgsql-php@postgresql.org; Mon, 04 Feb 2002 14:00:55 +0000 Received: from there (host213-1-163-207.btinternet.com [213.1.163.207]) by fullerruss.dsvr.co.uk (8.11.3/8.11.1) with SMTP id g14E0oA11034 for ; Mon, 4 Feb 2002 14:00:51 GMT Message-Id: <200202041400.g14E0oA11034@fullerruss.dsvr.co.uk> Content-Type: text/plain; charset="iso-8859-1" From: Shane Wright Reply-To: me@shanewright.co.uk To: pgsql-php@postgresql.org Subject: constants Date: Mon, 4 Feb 2002 14:00:03 +0000 X-Mailer: KMail [version 1.3.2] MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Archive-Number: 200202/14 X-Sequence-Number: 920 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