<html><body><div>Hi,</div>
<div> </div>
<div> i have a:</div>
<div> select * from foo where type = 1 and score > 12;</div>
<div> </div>
<div> i would like to say</div>
<div> </div>
<div> select * from foo where type = QUARTERBACK and score > 12;</div>
<div> </div>
<div> </div>
<div>Just an example.</div>
<div> </div>
<div>John</div>
<div><BR><BR> </div>
<BLOCKQUOTE style="PADDING-LEFT: 8px; MARGIN-LEFT: 8px; BORDER-LEFT: blue 2px solid" webmail="1">-------- Original Message --------<BR>Subject: Re: [NOVICE] create constant values<BR>From: "Rodrigo_De_León" <rdeleonp(at)gmail(dot)com><BR>Date: Wed, November 21, 2007 10:32 am<BR>To: john(at)msasystems(dot)net<BR>Cc: pgsql-novice <pgsql-novice(at)postgresql(dot)org><BR><BR>On Nov 21, 2007 12:02 PM, <<A onclick="Popup.composeWindow('pcompose.php?sendto=john%40msasystems.net'); return false;" href="http://email.secureserver.net/pcompose.php?aEmlPart=0&type=reply&folder=INBOX.pgsql-novice&uid=5#Compose">john<B></B>@msasystems.net</A>> wrote:<BR>> Is there anyway to create constant values that could be used and reused in<BR>> postgres.<BR><BR>What are you trying to do?<BR><BR>If you share the specific requirements you have, maybe someone on this<BR>list can help you.<BR><BR>---------------------------(end of broadcast)---------------------------<BR>TIP 1: if p
osting/reading through Usenet, please send an appropriate<BR>subscribe-nomail command to <A onclick="Popup.composeWindow('pcompose.php?sendto=majordomo%40postgresql.org'); return false;" href="http://email.secureserver.net/pcompose.php?aEmlPart=0&type=reply&folder=INBOX.pgsql-novice&uid=5#Compose">majordomo<B></B>@postgresql.org</A> so that your<BR>message can get through to the mailing list cleanly<BR></BLOCKQUOTE></body></html>