Re: Compare with default value?

Am 14.03.21 um 18:13 schrieb Adrian Klaver: On 3/14/21 6:30 AM, Ulrich Goebel wrote: Hi, Am 13.03.21 um 22:21 schrieb Tim Cross: 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

Re: Compare with default value?

Hi, Am 13.03.21 um 22:21 schrieb Tim Cross: Ulrich Goebel 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 mailto:m...@fam-goebel.de>> wrote: I would like to get the rows, w

Re: Compare with default value?

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 <mailto:m...@fam-goebel.de>> wrote: I would like to get the rows, where a column has the default value, similar to: select id

Compare with default value?

Hi, I would like to get the rows, where a column has the default value, similar to: select id fromt tbl where col = default Is there a chance? Thank's Ulrich -- Ulrich Goebel Am Büchel 57, 53173 Bonn

Re: UPDATE Syntax - solved

Solved. Use update tbl set (col1, col2, ...) = ROW(val1, val2, ...) where id=xx Thank's to Laurenz Albe in the german mailinglist. Am 03.02.21 um 11:31 schrieb Ulrich Goebel: Hi, in a Python Script I build an UPDATE using the syntax: update tbl set (col1, col2, ...) = (val1,

UPDATE Syntax

id this error message? Well, I could use the other syntax: update tbl set col1=val1, col2=val2, ... where id=xx but I just like the former... Thank's Ulrich -- Ulrich Goebel Am Büchel 57, 53173 Bonn