Postgresql: function UNIX_TIMESTAMP() doesnt exist about mangos-one-server-old HOT 9 CLOSED

oh, so someone is still using postgre?.. yes, please, provide a fix for postgre if you can

from mangos-one-server-old.

Strange, it used long time in master version directly in code and none one report porblems when some other porblems has been reported about posgre use.

from mangos-one-server-old.

"If it's a good fix I can make patch for all queries"

No-no, this is not right way...

We have some other syntax diff in queries for mysql/posgre and have special defines for provide alternative syntax. If you confirm that this work right i can add like define for in all places use instead direct UNIX_TIMESTAMP
But we also use FROM_UNIXTIME(time). Is it ok case?

from mangos-one-server-old.

found http://janusz.slota.name/blog/2009/06/mysql-from_unixtime-and-unix_timestamp-functions-in-postgresql/

Tested as postgres function and work then what the best, postgres functions or core modification?

from mangos-one-server-old.

Hmm, intresting sollution, if function psosible then maybe better have its.
As i understand then need do add its query in posrgre database connection init?
it need do for each connection or single time. in any case this need do then in PostgreSQLConnection::Initialize possible. Can you test this way? And maybe provide patch if work....

from mangos-one-server-old.

Function replacement need to be added one time at each database using FROM_UNIXTIME and UNIX_TIMESTAMP
http://www.picdo.net/fichiers/2011/2/12/05ca3557-7ecb-4e0d-b24d-e9a14261671b_pgfunctions.tiff

from mangos-one-server-old.

Fixed in [11155] in suggested way. Please look is i ok write because can't do real test in PostgreSQL.

from mangos-one-server-old.

it works but you have forget the function FROM_UNIXTIME
https://gist.github.com/824546

from mangos-one-server-old.

Oh, thank you :) Fixed in [11160]

from mangos-one-server-old.