Re: create constant values

Hi,
 
   i have a:

                     select
*from foo where type = 1 and score > 12; 
 
   i would like to say
 

                    
select* from foo where type = QUARTERBACK and score > 12; 
 
 
Just an example.
 
John
 
-------- Original Message --------Subject: Re: [NOVICE] create constant valuesFrom: "Rodrigo_De_León"
<rdeleonp@gmail.com>Date:Wed, November 21, 2007 10:32 amTo: john@msasystems.netCc: pgsql-novice
<pgsql-novice@postgresql.org>OnNov 21, 2007 12:02 PM, <john@msasystems.net> wrote:> Is there anyway to
createconstant values that could be used and reused in> postgres.What are you trying to do?If you share the specific
requirementsyou have, maybe someone on thislist can help you.---------------------------(end of
broadcast)---------------------------TIP1: if p 
 osting/reading through Usenet, please send an appropriatesubscribe-nomail command to majordomo@postgresql.org so that
yourmessagecan get through to the mailing list cleanly