defining and using constants in postgreSQL

From: nzanella(at)cs(dot)mun(dot)ca (Neil Zanella)
To: pgsql-sql(at)postgresql(dot)org
Subject: defining and using constants in postgreSQL
Date: 2003-10-26 03:30:25
Message-ID: b68d2f19.0310251930.5f691e77@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I am looking for a way that I can define a constant in PostgreSQL (so that
I end up with a constant similar to one that I could have in Oracle). I have
searched the archives and it seems that the solutions that were suggested in
include creating a table of constants or alternatively creating a function
that returns a constant. However, I would like to have a predefined constant
in the global scope which I can access without the round brackets used to
call a function. That is, I would like to be able to define a constant
named foo that I can then access with the name foo, not foo().

Is this possible at all with PostgreSQL?

I know PostgreSQL has some predefined constants that don't take the round
brackets so in principle it should be possible to define more. Is there a
way to do such thing in PostgreSQL?

Thanks,

Neil

Browse pgsql-sql by date

  From Date Subject
Next Message sarek 2003-10-26 20:01:42 index and min()
Previous Message Michael Glaesmann 2003-10-25 11:06:05 Re: problem with sql