meta user
network profile
|
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. |
