Converting mulitlinestring to linestring in PostgreSQL with PostGIS?
Converting MultiLinestring to Linestring with PostGIS
Changes to parameter not showing on Report Server after deployment I am making a skydome and I have a texture hooked up with an emission shader for it, however, since the dome is blue it only emits blue light. Is there a way that I can have the whole sky illuminated and have the light reaching the rest of my scene be a different colour? Measures of residuals heteroscedasticity This wikipedia  lists a number of techniques to detect OLS residuals heteroscedasticity. I would like to learn which hands-on technique is more efficient in detecting regions affected by heteroscedasticity.  For example, here the central region in the OLS 'Residuals vs Fitted' plot seen to have higher variance than the sides of the plot (I am not entirely sure in facts, but let's assume it's the case for the sake of the question). To confirm, looking at the error labels in the QQ plot we can see that they match the error labels in the center of the Residuals plot.  But how can we quantify the residuals region that has significantly higher variance? It's known that when you're connecting to a wrong server via ssh and send your password  to it, your password comes in a plain text and a server saves it by default. Probably. I wonder, where I can retrieve it? I don't see it in /var/log/auth.log, although I do see all the attempts to authenticate. Setting: Let $\sum a_n z^n$ have radius of convergence $R$.  We have that  $$ R = \frac{1}{\underset{n \rightarrow \infty}{\limsup} \left|a_n \right|^{1/n}} $$  via Hadamard's formula for the radius of convergence.  Question: What are the radii of convergence for (i) $\sum a_n z^{2n}$ and (ii) $\sum a_n^2 z^n$?  Attempt for $\sum a_n^2 z^n$:   For ease of notation, let $R_1$ and $R_2$ denote the radii of convergence for power series $\sum a_n z^{2n}$ and $\sum a_n^2 z^n$ respectively. From Hadamard's formula, we then have  $$ R_2 = \frac{1}{\underset{n \rightarrow \infty}{\limsup} \left|a_n^2 \right|^{1/n}} = \left( \frac{1}{\underset{n \rightarrow \infty}{\limsup} \left|a_n \right|^{1/n}} \right)^2 = R^2 $$   But what about $R_1$? Is it okay to use the phrase "try and"? Is it grammatically correct? e.g. "I will try and answer ..." I read the following sentence in book (App).     I will try and answer any questions you ask.   Why don't they use the following? (it is much common):     I will try to answer any questions you ask.   Is there any difference in meaning?  Update:  I noticed that a lot of books and news websites are using this phrase:        Although Katty will try and answer as many questions as she can.    He puller would have a chance to try and answer the question on her own ... I have Ubuntu budgie 17.04 (budgie-desktop 10.2.9). While pressing Alt+Tab to switch between the windows, the windows are switched randomly and I am not able to select which window to shift.  This feature was available in Ubuntu 16.04 but not in Ubuntu-budgie-17.04.    How to resolve this? How to gather full network usage statistics on a freebsd router? I have a freebsd box, which serves as a router from LAN to the outside world. It has several Internet providers, OpenVPN servers and clients, NAT and so on.  I would like to have complete statistics on when, who, to whom, via which provider, via which protocol, and how many bytes have been sent.   I agree that the minimal time scale will be an hour, i.e. no need for millisecond precision.  I tried vnstat2, ntopng and some other programs, but they don't seemed to have what I need or it is not obvious.   I don't understand, why this feature is not easily available. But I am not good in freebsd, so please, give me some clues. Cardinality of cartesian square Given an infinite set $A$ -  does the cardinality of $A$ equal to the cardinality of $A^2$? I asked this question for many people/professors without getting a sufficient answer, why in QM Lebesgue spaces of second degree are assumed to be the one that corresponds to the Hilbert vector space of state functions, from where this arises? and why 2-order space that assumes the following inner product:  $\langle\phi|\psi\rangle =\int\phi^{*}\psi\,dx$  While there is many ways to define the inner product.  In Physics books, this always assumed as given, never explains it, also I tried to read some abstract math books on this things, and found some concepts like "Metric weight" that will be minimized in such spaces, even so I don't really understand what is behind that, so why $L_2$? what special about them? Who and how physicists understood that those are the one we need to use? Increase the visibility of the association bonus by documenting it with the other privileges Flagged emails keep returning and won't synchronize between Apple Mail and Gmail I've had this problem before and can't recall how I managed to fix it last time. I use Apple Mail to access my Gmail and normally flagged emails show up correctly. Starred emails in Gmail equate to flagged emails in Apple Mail and I can unflag an email in either Gmail or Apple Mail and it works.  But now I've got four emails that I can't unflag. They're not flagged in Gmail at all (although they used to be). When I see them in the Flagged folder in Apple Mail, they don't even have flag icons next to them but they're still counted in the number showing next to "Flagged". If I manually re-flag them and then unflag them, they disappear from the Flagged box. But then if I click into Inbox and then back into Flagged they show up again.  Any ideas about how to make these guys disappear for good?! Finite Summation of Fractional Factorial Series What is the best way to replace the file browse button in html? I know that it's possible to replace the browse button, which is generated in html, when you use input tag with type="file.  I'm not sure what is the best way, so if someone has experience with this please contribute. Given two ciphertexts $c_1 = enc(p_1)$ and $c_2= enc(p_2)$ using any additive homomorphic encryption scheme (or specifically Paillier).   Can we find out whether the underlying plaintexts $p_1,p_2$ are equal without decrypting $c_1,c_2$ i.e. homomorphically? I have to show that the ring $\mathbb{Z}[X]/(X^2-1)$ is not isomorphic with $\mathbb{Z}\times \mathbb{Z}$.    I know that $(\mathbb{Z}\times\mathbb{Z})^*=\{(\pm1,\pm1)\}$, so I thought I should be looking for elements which have inverses in $\mathbb{Z}[X]/(X^2-1)$ and hopefully find more or less than 4. But I didnt succeed, so I need hints. Thanks. How to format a USB or external drive? Using Ubuntu 11.10, how do I format an external or USB drive? I don't find an option to 'format' when I right click. In the new version, the drives don't come up on the desktop, but instead come on the Launcher. Where can I travel for prolonged periods of time while legally working remotely for a company in my home country? I found several questions about inbound travelers to the US in this scenario, but little about other countries: I work for a company in my home country (USA) who are open to me working remotely while traveling.   Which countries allow me to legally work remotely for a company in my home country (USA) while traveling in their country? The work has absolutely no connection to the destination country, it would take place identically entirely within the USA if I weren't traveling. Prevent Mac Terminal from reverting to default theme I can't find any way to change the Terminal theme and have that theme applied permanently.  I want to change to another darker theme other than the default 'basic' theme, and (most importantly) have it remain as the theme every time I open Terminal. Jutifying: irrational + rational = irrational I am not sure how to show this. This is what I tried.   Proposition: If x is rational number and y is an irrational number then x+y is an irrational number.  Logically speaking this is  P=x is rational  Q= Y is irrational  R= x+y is irrational  $P\wedge Q \rightarrow R$  Explanation: What I did  $x=\frac{p}{q}$ P and Q integer  Y cannot be written as the a rational by definition  So therefore  $x+y=\frac{p}{q}+y$  Will not be a rational number as there cannot be a common denominator.