Ulrich Goebel <ml@xxxxxxxxxxxxx> writes: > Hi, > > o.k. I have to give some more information... > > Am 13.03.21 um 19:39 schrieb David G. Johnston: >> On Saturday, March 13, 2021, Ulrich Goebel <ml@xxxxxxxxxxxxx >> <mailto:ml@xxxxxxxxxxxxx>> wrote: >> >> I would like to get the rows, where a column has the default value, >> similar to: >> select id fromt tbl where col = default >> >> If the default is a simple constant then why go through the trouble instead of >> just writing col = ‘constant’ ? > I think you may need to re-think your design or at least come at it from a different perspective. As shown by another post in the thread, at some level, this is 'sort of' possible, but it will be ugly and fragile. Possibly one of the issues you have is on one hand, you want the solution to be as generic as possible, but on the other, you require it to have specific knowledge about the definition of your table. i.e. which column(s) have a default value. Furthermore, your 'completion' table will need to be defined based on this information i.e. potentially multiple columns with multiple different data types etc. While the additional information you provided does give some increased understanding of what your trying to do, it is still describing your desired solution implementation. It might be better if you provide more high level details of what your attempting to do so that we can better understand how you arrived at the proposed solution and whether there may be better alternatives available.
