Re: best way for constants in the database - Mailing list pgsql-sql

From Owen Jacobson
Subject Re: best way for constants in the database
Date
Msg-id 144D12D7DD4EC04F99241498BB4EEDCC1C8046@nelson.osl.com
Whole thread Raw
In response to best way for constants in the database  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
chester c young wrote:

> anybody have a good way to impliment constants in the database?
>
> using an immutable pgpgsql function, constant_name() - works, but not
> necessarily very efficient.

A function declared IMMUTABLE should be efficient enough; it'll usually be evaluated once per query at most.  The real
answeris, as usual, "it depends."  What're you trying to accomplish with a constant? 


pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: best way for constants in the database
Next
From: Ottó Havasvölgyi
Date:
Subject: Re: For update