postgresql - Different effects of ORDER BY clause on two servers -


my query:

select * table group id; 

id field primary key, of course;

in 9.4.4 expected error:

column "table.name" must appear in group clause or used in aggregate function 

but! in 9.4.5 works, in mysql.

can tell me - why? :)

postgres version not matter here. tables not identical. in 9.4.5 table column id primary key, while in 9.4.4 not.


Comments

Popular posts from this blog

php - Wordpress website dashboard page or post editor content is not showing but front end data is showing properly -

javascript - Get parameter of GET request -

javascript - Twitter Bootstrap - how to add some more margin between tooltip popup and element -