240 reputation
517
bio website erike.net
location Hanover, Germany
age 34
visits member for 3 years, 3 months
seen 20 hours ago

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
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).
Sep
26
comment connection to Informix still active despite closing?
That was it, thanks for doing the research for me ;)
Sep
21
comment What's a good (free) client for Informix on Windows?
I finally found a good client (with free version): serverstudio.com
May
9
comment What joins are available in Informix 9.2?
@ypercube: Newer versions of Informix have LEFT, RIGHT, and FULL outer joins. I mentioned OUTER JOIN and OUTER referring to different possibilities for the syntax, not different joins. @RolandoMySQLDBA: Thanks for jumping in with an example and link.
May
9
comment What joins are available in Informix 9.2?
Sorry to ask and answer the question so quickly, wasn't expecting my colleague to know the answer.
May
3
comment Why does NOT IN with a set containing NULL always return FALSE/NULL?
+1 and thanks for the useful alternative.
Apr
16
comment Postgres Client - save table sorting
Yes, that would be an alternative, if no other client offers what I'm looking for.
Apr
16
comment Postgres Client - save table sorting
Sure, I use pgadmin3, and if I open a table and then sort using certain columns, the sorting is gone when I close the table. I'm looking for a client that can save this information so that the sorting remains when I reopen the table.
Apr
16
comment What's a good (free) client for Informix on Windows?
you missed one: dba.stackexchange.com/questions/755/…
Apr
12
comment What does NVL stand for?
OK, I was expecting something more interesting, like Null Value Limiter.
Apr
12
comment See actual results of SQL UPDATE command
Thanks, and now I see there's also something similar in Postgres, the RETURNING clause.
Mar
30
comment OVERLAPS for Informix
Exactly, two columns from two different tables with start and end dates.
Oct
4
comment What's a good (free) client for Informix on Windows?
mainly write queries/view data. (db server management would be nice extras, though.)
Sep
7
comment Is there a way to access temporary tables of other sessions in postgres?
Thanks for the tip. I was able to find out the name and schema for the temporary table using dbvis (which probably uses the first query you mentioned), but the problem was that I couldn't access them from a session other than the one they were created in.