On Fri, 2020-04-10 at 01:40 +, Virendra Kumar wrote:
> Here is test case.
>
> create table testx
> (
> v_code character varying(32),
> client_id bigint
> );
> alter table testx add constraint testx_pkey primary key (v_code);
>
> create table testy
> (
> dxid bigint,
> v_co
Hi Team,
Here is test case.create table testx
(
v_code character varying(32),
client_id bigint
);
alter table testx add constraint testx_pkey primary key (v_code);
create table testy
(
dxid bigint,
v_code character varying(32)
);
alter table testy add constraint testy_pkey prim
On Thursday, April 9, 2020, David Gauthier wrote:
> psql (9.6.7, server 11.3) on linux
>
> In the copy/paste below, first 2 lines returned by a select on the view,
> why didn't it sort on start_datetime correctly ? I would think that the
> one started on 04-08 would come before the one on 04-09
Greetings,
* Roberto Della Pasqua (roberto.dellapas...@live.com) wrote:
> Please sorry because I'm newbie of PGSQL
We all were, once upon a time. :)
> I need the best performing and overall quality full-text search, can be
> possible to have the data stored in pgsql and the index to elasticsear
David Gauthier writes:
> In the copy/paste below, first 2 lines returned by a select on the view,
> why didn't it sort on start_datetime correctly ?
Putting an ORDER BY in a view is a bit dangerous (last I looked,
it wasn't even legal in standard SQL). Yeah, the view will sort,
but there is noth
psql (9.6.7, server 11.3) on linux
In the copy/paste below, first 2 lines returned by a select on the view,
why didn't it sort on start_datetime correctly ? I would think that the
one started on 04-08 would come before the one on 04-09 ?
dvdb=> \d sim_phases;
Table "dvm.sim_phase
i dont know how to do with elastic-search
according to programcreek you can create an index from a jdbc
source
https://www.programcreek.com/java-api-examples/?code=SeldonIO/semantic-vectors-lucene-tools/semantic-vectors-lucene-tools-master/src/main/java/io/seldon/semvec/CreateLuceneIndexFromDb.j
In this instance, BDR from 2ndquadrant is probably your best bet. It is
commercial but they are a community supporting company.
JD
On Wed, Apr 8, 2020, 08:53 Stephen Frost wrote:
> Greetings,
>
> * Vano Beridze (vanua...@gmail.com) wrote:
> > What are the plans to support multi-master natively?
