Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Paul Linehan
> Of course, this only holds for the very relaxed definition of open > source. RMS would/will be using this as a clear example of MS destroying > open source and the weakness of the general open source movement when it > fails to emphasise freedom. He's already said that GitHub isn't appropriate

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Paul Linehan
> Sourceforge seems to be out of favor, too, so are there any open source > platforms that provide services that sourceforge and github do? In a word: GitLab! Pól... > Rich

Re: Microsoft buys GitHub, is this a threat to open-source

2018-06-07 Thread Paul Linehan
> Microsoft has bought GitHub for $7.5 billion, is this a threat to the open > source community? Only to the extent that GitHub was a threat before this. They never embraced Open Source! They cynically portrayed themselves as the developer's best pal when, in fact, they are/were nothing more and

Re: SQL problem (forgot to change header with earlier post!).

2018-05-29 Thread Paul Linehan
Hi again, and thanks for your efforts on my behalf! > WITH num AS > ( >SELECT count (*) as cnt1 FROM v1 > ), > div AS > ( >SELECT count (*) as cnt2 FROM v2 > ) > SELECT (num.cnt1::numeric/div.cnt2) > From num cross join div; I've tried running this code 4 different ways and none of th

Re: SQL problem (forgot to change header with earlier post!).

2018-05-29 Thread Paul Linehan
Hi and grazie for your reply! > If it's not an excercise, I think you don't need them Not an exercise - I have to use the VIEW though - this was only a sample. In real life the VIEW is trickier! > select (select count(*) from t1) / (select count(*) from t2)::float Looks as if the CAST was pa

Re: SQL problem (forgot to change header with earlier post!).

2018-05-29 Thread Paul Linehan
Hi, and thanks for taking the trouble to reply! > WITH num AS > ( > SELECT count (*) as cnt1 FROM v1 > ), > div AS > ( > SELECT count (*) as cnt2 FROM v2 > ) > SELECT (num.cnt1::numeric/div.cnt2); I get this error ERROR: missing FROM-clause entry for table "num" LINE 9: SELECT (num.cnt1::n

SQL problem (forgot to change header with earlier post!).

2018-05-29 Thread Paul Linehan
Hi all, I have a problem that I just can't seem to solve: I want to divide the count of one table by the count of another - seems simple enough! I created simple VIEWs with counts of the tables, but I just can't grasp the logic! DDL and DML (simplified) at the bottom of post. I tried various c

Re: binaries for 11 beta compiled with --with-llvm?

2018-05-29 Thread Paul Linehan
Hi all, I have a problem that I just can't seem to solve: I want to divide the count of one table by the count of another - seems simple enough! I created simple VIEWs with counts of the tables, but I just can't grasp the logic! DDL and DML (simplified) at the bottom of post. I tried various c

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi and thanks for replying, > I tend to install ICUs versions into their own directories rather > than /usr/local, and use Debian rather than Fedora, but you > might try PKG_CONFIG_PATH=/usr/local/lib/pkgconfig I have figured it out. It all boils down to actually taking the time and effort to R

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi again, As a followup - I ran this command (do I need to set LD_LIBRARY_PATH?) [pol@polhost /]$ sudo find . -name "icu*" | grep -v Downloads | more And got: ./usr/local/sbin/icupkg ./usr/local/bin/icuinfo ./usr/local/bin/icu-config ./usr/local/lib/icu ./usr/local/lib/pkgconfig/icu-io.pc

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
>> On which platform and/or distribution are you trying the code >> compilation? > sorry about that - it's Linux Fedora 28, 64 bit Intel X86_64 - Samsung > laptop, 8GB RAM, quad-core. PostgreSQL 10.4 also. Pól...

Re: Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi, and thanks for responding, >> I'm having problems compiling PostgreSQL. > On which platform and/or distribution are you trying the code > compilation? Ooops! sorry about that - it's Linux Fedora 28, 64 bit Intel X86_64 - Samsung laptop, 8GB RAM, quad-core. Please don't hesitate to ask s

Problem compiling PostgreSQL.

2018-05-17 Thread Paul Linehan
Hi all, I'm having problems compiling PostgreSQL. I can run "make" no problem with this command ./configure --prefix=/home/pol/Downloads/sware/db/pg/inst --mandir=/home/pol/Downloads/sware/db/pg/inst/man --docdir=/home/pol/Downloads/sware/db/pg/inst/doc --enable-nls --with-python --with-openssl