diff options
| author | Grant Limberg <[email protected]> | 2021-06-04 14:48:41 -0700 |
|---|---|---|
| committer | Grant Limberg <[email protected]> | 2021-06-04 14:48:41 -0700 |
| commit | add33f1ab357b1917ba151e0e6ce52b769654eee (patch) | |
| tree | fe4c4ecd89acda3e3e8f861f7f52c259c130189a /controller/PostgreSQL.cpp | |
| parent | 3bfc438ae8b043f88db07a8002e37109b8f8deb5 (diff) | |
cast to bigint in query
Diffstat (limited to 'controller/PostgreSQL.cpp')
| -rw-r--r-- | controller/PostgreSQL.cpp | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/controller/PostgreSQL.cpp b/controller/PostgreSQL.cpp index 2b228476..beb8f3bb 100644 --- a/controller/PostgreSQL.cpp +++ b/controller/PostgreSQL.cpp @@ -418,8 +418,8 @@ void PostgreSQL::initializeNetworks() fprintf(stderr, "Initializing Networks...\n"); auto c = _pool->borrow(); pqxx::work w{*c->c}; - pqxx::result r = w.exec_params("SELECT id, EXTRACT(EPOCH FROM creation_time AT TIME ZONE 'UTC')*1000 as creation_time, capabilities, " - "enable_broadcast, EXTRACT(EPOCH FROM last_modified AT TIME ZONE 'UTC')*1000 AS last_modified, mtu, multicast_limit, name, private, remote_trace_level, " + pqxx::result r = w.exec_params("SELECT id, (EXTRACT(EPOCH FROM creation_time AT TIME ZONE 'UTC')*1000)::bigint as creation_time, capabilities, " + "enable_broadcast, (EXTRACT(EPOCH FROM last_modified AT TIME ZONE 'UTC')*1000)::bigint AS last_modified, mtu, multicast_limit, name, private, remote_trace_level, " "remote_trace_target, revision, rules, tags, v4_assign_mode, v6_assign_mode, sso_enabled FROM ztc_network " "WHERE deleted = false AND controller_id = $1", _myAddressStr); |