It shows posts by user with id 1 (Jeff Atwood), not -1.
On every use profile page the search bar on the top of the page already contains user:&lt;id&gt; text to simplify search for post of the currently visible user. But this doesn’t work correctly for the  user:        Instead of searching for posts owned by Community user I’ve got Jeff Atwood posts:        In this case minus sign was just ignored and instead of (-1, i.e. Community user), the (+1, i.e. Jeff Atwood) is used. Same happened for any other negative id for the “user:” option in the search box.
Performance impact of updating target columns with same values ON CONFLICT This is a question about the inner-workings of Postgres (v10) and performance.  Given a table, github_repos, with a multi-column unique index on org_id and github_id columns, is there any performance difference (or other issues to be aware of) between the two bulk upsert operations below? The difference is that in the first query, the org_id and github_id columns are included in the UPDATE, whereas in the second query they are not. Since the UPDATE runs ON CONFLICT, the updated values of org_id and github_id will be the same as the old values, but those columns are included in the UPDATE because the underlying library I am using is designed that way. I'm wondering if its safe to use as-is or whether I should be explicitly excluding those columns in the UPDATE.  Query #1:  INSERT INTO "github_repos" ("org_id","github_id","name") VALUES (1,1,'foo') ON CONFLICT (org_id, github_id) DO UPDATE SET "org_id"=EXCLUDED."org_id","github_id"=EXCLUDED."github_id","name"=EXCLUDED."name" RETURNING "id"   Query #2:  INSERT INTO "github_repos" ("org_id","github_id","name") VALUES (1,1,'foo') ON CONFLICT (org_id, github_id) DO UPDATE SET "name"=EXCLUDED."name" RETURNING "id"   github_repos table:        Column       |       Type        | Collation | Nullable  -------------------+-------------------+-----------+----------+  id                | bigint            |           | not null |  org_id            | bigint            |           | not null |  github_id         | bigint            |           | not null |  name              | character varying |           | not null |  Indexes:     "github_repos_pkey" PRIMARY KEY, btree (id)     "unique_repos" UNIQUE, btree (org_id, github_id) Good books for a high schooler self-studying Abstract Algebra? Does anyone have any suggestions for abstract algebra books particularly suited to self-study?     Here is some background and motivation, if it's helpful.  I'm currently a junior in high school, but I have some familiarity with groups, rings, polynomials and fields, as I went through Fraleigh's book. I liked its writing style, but many of the problems were not helpful. I would like to get better at algebra with some other book, particularly one that's aimed at someone who already has a little familiarity with the objects, but is by no means completely comfortable.  One of my longer-term goals is to learn a bit of algebraic number theory, as I've only been studying elementary number theory. That's why I feel it  good to learn more algebra first. (I'd also be interested in suggestions of other good subjects to learn prior to tackling algebraic number theory.)  I was considering using one of Lang's books, since they seem pretty universal, but I've heard rumors that they are very terse and not good for self-learning. Minimum distance between the curves $f(x) =e^x$ and $g(x) =\ln x$ What is the minimum distance between the curves $f(x) =e^x$ and $g(x) = \ln x$? I didn't understand how to solve the problem. Please help me. Nautilus 3.6 doesn't have a status bar? In 12.04, Nautilus showed the amount of remaining space in the status bar , but as of 13.04 the status bar is gone.  gsettings set org.gnome.nautilus.window-state start-with-status-bar true   turned out "no such key".  Is there any way to bring back the status bar? PrintWriter and PrintStream never throw IOExceptions CS0120: An object reference is required for the nonstatic field, method, or property 'foo' Consider:  namespace WindowsApplication1 {     public partial class Form1 : Form     {         public Form1()         {             InitializeComponent();         }          private void button1_Click(object sender, EventArgs e)         {             //int[] val = { 0, 0};             int val;             if (textBox1.Text == "")             {                 MessageBox.Show("Input any no");             }             else             {                 val = Convert.ToInt32(textBox1.Text);                 Thread ot1 = new Thread(new ParameterizedThreadStart(SumData));                 ot1.Start(val);             }         }          private static void ReadData(object state)         {             System.Windows.Forms.Application.Run();         }          void setTextboxText(int result)         {             if (this.InvokeRequired)             {                 this.Invoke(new IntDelegate(SetTextboxTextSafe), new object[] { result });             }             else             {                 SetTextboxTextSafe(result);             }         }          void SetTextboxTextSafe(int result)         {             label1.Text = result.ToString();         }          private static void SumData(object state)         {             int result;             //int[] icount = (int[])state;             int icount = (int)state;              for (int i = icount; i &gt; 0; i--)             {                 result += i;                 System.Threading.Thread.Sleep(1000);             }             setTextboxText(result);         }          delegate void IntDelegate(int result);          private void button2_Click(object sender, EventArgs e)         {             Application.Exit();         }     } }   Why is this error occurring?     An object reference is required for the nonstatic field, method, or property 'WindowsApplication1.Form1.setTextboxText(int) TeX support works fine in question and answer bodies, and comments can be rendered manually by tapping and selecting Render MathJax. See related question .  However, the titles are not rendered which makes the browsing experience less than perfect. See screenshot below.   Are there any plans to implement MathJax support in titles?  (I'm running Stack Exhange iOS App Version 1.0.0 on an iPhone 4S with iOS 7.1.1)    EDIT: I was just informed about  asking for the same functionality for the Android app. I guess I shouldn't hope too much then... I have downloaded and installed the newest  for my Windows 7 (64-bit OS), but when I want to install 64-bit Linux, the New->Create Virtual Machine only displays 32-bit option, no 64-bit option. Could anyone give any clues about this issue? Thanks very much in advance! Consider repeated measures ANOVA (RM-ANOVA) with one within-subject factor A and several measurements per subject for each level of A.  It is closely related to two-way ANOVA with two factors: A and subject. They use identical decomposition of the sum of squares into four parts: A, subject, A⋅subject, and residual. However, two-way ANOVA tests the effect of A by comparing SS of A with the residual SS, while RM-ANOVA tests the effect of A by comparing SS of A with the A$\cdot$subject interaction SS.   Why the difference?    Does this difference automatically follow from the repeated-measures structure of the data, or is it some convention?  Does this difference between two-way ANOVA and RM-ANOVA correspond to testing two different nulls? If so, what exactly are they and why would we use different nulls in these two cases? Two-way ANOVA's test can be understood as an F-test between two nested models: the full model, and the model without A. Can RM-ANOVA be understood in a similar way?   (If there is only one measurement per subject for each level of A, then the distinction sort of disappears because A$\cdot$subject and residual variation cannot be disentangled: )    Demonstration  I will use toy data d2 generated in . The same webpage shows correct syntax for RM-ANOVA.  # Discarding between-subject factors and leaving only one within-subject factor d = d2[d2$Xb1=='CG' &amp; d2$Xb2 == 'f', c(1,4,6)]   (See reproducible version .) Data look like that:       id Xw1     Y 1    s1   A  28.6 2    s1   A  96.6 3    s1   A  64.8 4    s1   B 107.5 5    s1   B  77.3 6    s1   B 120.9 7    s1   C 141.2 8    s1   C 124.1 9    s1   C  88.0 10   s2   A  86.7 ...   Here is two-way ANOVA: summary(aov(Y ~ Xw1*id, d))               Df Sum Sq Mean Sq F value   Pr(&gt;F)     Xw1           2  95274   47637  16.789 3.73e-07 *** id           19  31359    1650   0.582    0.913     Xw1:id       38  71151    1872   0.660    0.929     Residuals   120 340490    2837                    Here is RM-ANOVA: summary(aov(Y ~ Xw1 + Error(id/Xw1), d))  Error: id           Df Sum Sq Mean Sq F value Pr(&gt;F) Residuals 19  31359    1650                 Error: id:Xw1           Df Sum Sq Mean Sq F value   Pr(&gt;F)     Xw1        2  95274   47637   25.44 9.73e-08 *** Residuals 38  71151    1872                       Error: Within            Df Sum Sq Mean Sq F value Pr(&gt;F) Residuals 120 340490    2837               Note the identical SS decomposition, but two-way ANOVA tests Xw1 against the residual, while RM-ANOVA tests Xw1 against the Xw1:id interaction.  Why?  This question is related to . If we try using Error(id) instead of Error(id/Xw1) in the example above, then Xw1 will get tested against Xw1:id interaction lumped together with the residual variation.  (The same issue arises in factorial RM-ANOVA with multiple within-subject factors, where each factor or interaction is tested against its own "error term" aka "error stratum". These error strata are always given by the corresponding interaction with the block/plot/subject variable id.) Name an Armor Stand using the Standard Galactic Alphabet The Standard Galactic Alphabet is what appears in the Enchanting Table. Is there a way to give a name to an Armor Stand using these character.  I know there is a LingoJam Translator that give ASCII characters that look like the SGA, but that is not what I'm looking for. Can I use the same characters as the Enchanting Table? Should an image carousel on a mobile site automatically rotate? Or should the user have complete control? The intention is to have a slider/carousel that shows 6 or 7 images which the user can look through by clicking arrow buttons left or right. But the question has also come up if the user has not started looking through the images, should the carousel start automatically rotating the images. Since this is for a mobile site, I'm uncertain... What is involved in converting a PC video card to have boot screen on the Mac? I've got a PC video card that I'd like to get boot screen support for on my Mac Pro. In particular, it is a Gigabyte R9 270X. The card is supported on the Mac once it boots, but I would like to get boot screen back since my old 8800GT has been baked in the oven a few too many times by now :-)  I've seen numerous guides on the internet about flashing the BIOS on the video cards and also ones that speak about adding the EFI BIOS, but in the haphazard forum approach, it isn't clear how this all works. To some degree, I've recently come away with the notion that you don't get rid of the existing BIOS, but rather add an EFI partition to it that the Mac would recognize. If that assumption is correct, then it would lead me to believe that adding an EFI BIOS that works on a similar card (R9 280X or 7950 which are both close but not quite) should work since I'm assuming that the existing BIOS would be similar enough to hook in. Failing that, I'm not clear how you would get a card-specific EFI BIOS for boot screen support.  Anyone an expert on this? I'm just really having a hard time trying to sift through all this and hoping to get a more direct answer! Reasons not to use a 741 op-amp? Dobble card game - mathematical background In  there is a deck of 55 cards. Each of them has 8 symbols on it. There is a total of 50 different symbols and each two cards have one and only one in common.  I am wondering, given a total number of symbols N and a number of symbols on each card K, how do you find the biggest number of cards such that:   on each of those cards there are exactly K of the N symbols, every two cards have one and only one symbol in common. If the velocity is a relative quantity, will it make inconsistent equations when applying it to the conservation of energy equations?  For example:  In the train moving at $V$ relative to ground, there is an object moving at $v$ relative to the frame in the same direction the frame moves. Observer on the ground calculates the object kinetic energy as $\frac{1}{2}m(v+V)^2$. However, another observer on the frame calculates the energy as $\frac{1}{2}mv^2$. When each of these equations is plugged into the conservation of energy, they will result in 2 distinct results (I think). Areas versus volumes of revolution: why does the area require approximation by a cone? Suppose we rotate the graph of $y = f(x)$ about the $x$-axis from $a$ to $b$.  Then (using the disk method) the volume is $$\int_a^b \pi f(x)^2 dx$$ since we approximate a little piece as a cylinder.  However, if we want to find the surface area, then we approximate it as part of a cone and the formula is $$\int_a^b 2\pi f(x)\sqrt{1+f'(x)^2} dx.$$  But if approximated it by a circle with thickness $dx$ we would get $$\int_a^b 2\pi f(x) dx.$$  So my question is how come for volume we can make the cruder approximation of a disk but for surface area we can't. Remove default ID attribute from HTML helpers in ASP.NET MVC One of the most commonly asked questions of beginners. How do ranks work in Go for amateurs?  Why do we start backwards? And why do we suddenly count upwards again? What is the difference between 9d and 9p? How is this related to rating? What are the basic differences between ranks used in different countries and different servers? How can I get my graphics card to be recognized in System Info? Mouse Pointer Locator Due to a stroke, I have had some vision impairment in that I sometimes have a hard time locating my mouse pointer on the screen.  I have tried making the mouse pointer larger which helps but is still not the solution.  I am new to the Mac world and would appreciate your help.  In Windows, there is an option where pressing the CTRL key will help to identify the mouse pointer using a temporary display of several radiating concentric circles around the mouse pointer.  Is there something like this on OS X?