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
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 |