Skip site navigation (1) Skip section navigation (2)

constants

From: Shane Wright <me(at)shanewright(dot)co(dot)uk>
To: pgsql-php(at)postgresql(dot)org
Subject: constants
Date: 2002-02-04 14:00:03
Message-ID: 200202041400.g14E0oA11034@fullerruss.dsvr.co.uk (view raw or flat)
Thread:
Lists: pgsql-php
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

Responses

pgsql-php by date

Next:From: Chadwick RolfsDate: 2002-02-04 19:48:21
Subject: Re: constants
Previous:From: Frank JoerdensDate: 2002-02-02 19:41:12
Subject: Re: pg_pconnect - ??

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group