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

Re: Declaring constants in PG/PLSQL

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: Mark Hesketh <renmark(at)iprimus(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Declaring constants in PG/PLSQL
Date: 2002-01-21 15:20:19
Message-ID: 1011626421.3096.76.camel@linda (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
On Mon, 2002-01-21 at 14:37, Mark Hesketh wrote:
>   Hi all,
> Can someone tell me if it's possible to globally scope my constants? How 
> do I declare them for reuse? Don't tell me I have to keep defining them 
> atop each function... :|

Why not create some functions that return your constants?

Oliver Elphick                                Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight                    
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "For we wrestle not against flesh and blood, but  
      against principalities, against powers, against the 
      rulers of the darkness of this world, against  
      spiritual wickedness in high places. Wherefore take 
      unto you the whole armour of God, that ye may be able 
      to withstand in the evil day, and having done all, to 
      stand."              Ephesians 6:12,13 

In response to


pgsql-novice by date

Next:From: Mark BleekerDate: 2002-01-22 11:02:43
Subject: automatically updated an attribute with the current time
Previous:From: Jules AlbertsDate: 2002-01-21 14:56:34
Subject: Re: Declaring constants in PG/PLSQL

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