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

Post a Comment

Popular posts from this blog

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

Reversible shuffling a int array in java -

this question has answer here: reversible shuffle algorithm using key 4 answers i have int array of considerably large size. need shuffle array using key. should able obtain original array using same key. searched shuffle algorithms 1 found fisher yates not use key. the int array pixel values of image. need hide data it. hiding data after shuffling array enables accessing of data if 1 have key. fisher-yates uses pseudo-random number generator, can seed using key (look cryptographic prngs). reverse process, shuffle array of indices [0, n ) using same key, perform reverse shuffle.
Read more