Re: Declaring constants in PG/PLSQL - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: Declaring constants in PG/PLSQL
Date
Msg-id 1011626421.3096.76.camel@linda
Whole thread Raw
In response to Declaring constants in PG/PLSQL  (Mark Hesketh <renmark@iprimus.com.au>)
List 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.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
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

Attachment

pgsql-novice by date:

Previous
From: "Jules Alberts"
Date:
Subject: Re: Declaring constants in PG/PLSQL
Next
From: "Mark Bleeker"
Date:
Subject: automatically updated an attribute with the current time