1

Topic: What advantages of passage to the new version ?

Passage with 8 on 9.4 interests
Tell, what real  versions 9.4 before 8.4?

2

Re: What advantages of passage to the new version ?

I ask to transfer in . (Was mistaken section)

3

Re: What advantages of passage to the new version ?

queezy relax wrote:

passage with 8 on 9.4 Interests
Tell, what real  versions 9.4 before 8.4?

Ceases to pull on a forum on ms sql

4

Re: What advantages of passage to the new version ?

The subject can be deleted.
Already created where it is necessary.

5

Re: What advantages of passage to the new version ?

queezy relax wrote:

I ask to transfer in . (Was mistaken section)

Whether was mistaken... ?:-D
(In 10 versions it is a lot of that interesting )

6

Re: What advantages of passage to the new version ?

Hupin wrote:

it is passed...
Whether was mistaken... ?:-D
(In 10 versions it is a lot of that interesting )

But 10th yet did not let out like.
9 interests.

7

Re: What advantages of passage to the new version ?

queezy relax wrote:

the Subject can be deleted.
Already created where it is necessary.

8

Re: What advantages of passage to the new version ?

queezy relax wrote:

it is passed...
But 10th yet did not let out like.
9 interests.

So already just about,
The candidate let out
21st September 2017
PostgreSQL 10 RC 1 Released!

9

Re: What advantages of passage to the new version ?

Hupin wrote:

it is passed...
So already just about,
The candidate let out
21st September 2017
PostgreSQL 10 RC 1 Released!

Think it better SQl Server?

10

Re: What advantages of passage to the new version ?

queezy relax wrote:

it is passed...
Think it better SQl Server?

And in it on former to tables of other basis, but on the same server, through one place it is necessary to address?

11

Re: What advantages of passage to the new version ?

iii2 wrote:

it is passed...
And in it on former to tables of other basis, but on the same server, through one place it is necessary to address?

It is difficult to understand unambiguously that you mean under one place, but there are different variants.

12

Re: What advantages of passage to the new version ?

Hupin wrote:

it is passed...
It is difficult to understand unambiguously that you mean under one place, but there are different variants.

This sort of syntax means:

SELECT *
FROM table1 tb1
LEFT JOIN (
SELECT *
FROM dblink (' dbname=db2 ', ' SELECT id, code FROM table2 ')
AS tb2 (id int, code text);
) AS tb2 ON tb2.column = tb1.column;

13

Re: What advantages of passage to the new version ?

And sql server till now only on  works?

14

Re: What advantages of passage to the new version ?

queezy relax wrote:

And sql server till now only on  works?

No, on  too, but there is a rule - "to the first SP - attempts of implementation of products MS to produce only under the threat of immediate execution, and to the second SP - only under the threat of immediate sending to Siberia, on penal servitude".

15

Re: What advantages of passage to the new version ?

queezy relax wrote:

And sql server till now only on  works?

sql server 2017
on Windows, Linux, and Docker containers.
But costs money.

16

Re: What advantages of passage to the new version ?

iii2 wrote:

it is passed...
This sort of syntax means:

SELECT *
FROM table1 tb1
LEFT JOIN (
SELECT *
FROM dblink (' dbname=db2 ', ' SELECT id, code FROM table2 ')
AS tb2 (id int, code text);
) AS tb2 ON tb2.column = tb1.column;

It is possible still
CREATE EXTENSION postgres_fdw;

17

Re: What advantages of passage to the new version ?

iii2 wrote:

it is passed...
No, on  too, but there is a rule - "to the first SP - attempts of implementation of products MS to produce only under the threat of immediate execution, and to the second SP - only under the threat of immediate sending to Siberia, on penal servitude".

is a step forward.
Tell, and on  MS on  somebody used a SQL Server already?
Rolg Hupin, into the account of money did not understand, for the license for  ask more?

18

Re: What advantages of passage to the new version ?

queezy relax wrote:

it is passed...
is a step forward.
Tell, and on  MS on  somebody used a SQL Server already?
Rolg Hupin, into the account of money did not understand, for the license for  ask more?

Yes ..., I do not think, but also it is not less, probably.
I put still releases-candidates on  when was more subquality work and restrictions, the dragon works.
Naturally, the part of restrictions remains, for example, there are no expanded procedures, restrictions on SQLCLR and ..
Now like FTS works normally

19

Re: What advantages of passage to the new version ?

Hupin wrote:

it is passed...
Yes ..., I do not think, but also it is not less, probably.
I put still releases-candidates on  when was more subquality work and restrictions, the dragon works.
Naturally, the part of restrictions remains, for example, there are no expanded procedures, restrictions on SQLCLR and ..
Now like FTS works normally

And restrictions on SQLCLR - what sort? Is, like, net framework for ?
By the way, concerning the license - the free express train - anywhere did not get to.

20

Re: What advantages of passage to the new version ?

iii2 wrote:

it is passed...
And restrictions on SQLCLR - what sort? Is, like, net framework for ?
By the way, concerning the license - the free express train - anywhere did not get to.

SQLCLR there there was in candidates a restriction: only SAFE
Here particulars:
https://docs.microsoft.com/en-us/sql/li … ease-notes