| From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | Ulrich Goebel <ml(at)fam-goebel(dot)de> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Compare with default value? |
| Date: | 2021-03-13 20:50:49 |
| Message-ID: | CAKFQuwZtSa6boq02Yw+dYhuabgvBa+7EgT_Dw9gGfE1Gq5N8UA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, Mar 13, 2021 at 1:41 PM Ulrich Goebel <ml(at)fam-goebel(dot)de> wrote:
> But it could help to get a reference to the default value.
>
There is no such thing as a "default value". There is a "default
expression" though. It should be available in the system catalogs as part
of the definition of a table. But I'm of the general impression that
attributing some special significance to a value in the database because it
happens to have been computed by a default expression instead of some
explicitly supplied value is generally a wrong approach to take. The data
should be interpreted in an internally self-sufficient way.
David J.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2021-03-13 20:52:51 | Re: Compare with default value? |
| Previous Message | Ulrich Goebel | 2021-03-13 20:41:13 | Re: Compare with default value? |