Search Postgresql Archives

Re: Compare with default value?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Mar 13, 2021, at 1:51 PM, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:


On Sat, Mar 13, 2021 at 1:41 PM Ulrich Goebel <ml@xxxxxxxxxxxxx> 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.
 
Can you distinguish the case of the actual value  matching the (computed) default?


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux