220 reputation
516
bio website erike.net
location Hanover, Germany
age 34
visits member for 2 years, 11 months
seen 4 hours ago

Jul
2
awarded  Curious
Jun
17
awarded  Notable Question
May
8
awarded  Notable Question
Apr
1
awarded  Notable Question
Mar
30
awarded  Nice Question
Jan
2
awarded  Popular Question
Oct
30
awarded  Yearling
Apr
12
awarded  Notable Question
Apr
12
comment Use CASE to select columns in UPDATE query?
Thanks to both of you for the tips, in my case the single update statement worked fine.
Apr
12
accepted Use CASE to select columns in UPDATE query?
Apr
12
comment Use CASE to select columns in UPDATE query?
Thanks for the tip about everything being updated, if this is slow, I may take @Colin 't Hart's suggestion to have multiple update statements.
Apr
12
comment Use CASE to select columns in UPDATE query?
Thanks for the answer. I've added some more information to my question, I hope it's understandable. That's a good alternative with multiple update statements (I'd prefer one update statement, but I see there's an advantage there).
Apr
12
revised Use CASE to select columns in UPDATE query?
added 323 characters in body
Apr
12
asked Use CASE to select columns in UPDATE query?
Apr
4
awarded  Popular Question
Mar
29
awarded  Popular Question
Feb
15
awarded  Popular Question
Dec
24
accepted Is there a way to access temporary tables of other sessions in postgres?
Sep
26
comment connection to Informix still active despite closing?
That was it, thanks for doing the research for me ;)
Sep
26
accepted connection to Informix still active despite closing?