On 09 Aug 2014, at 13:24, Alexis Bernard wrote:
> Primary key definition: "tracks_pkey" PRIMARY KEY, btree (id)
> select version(): PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by
> gcc (Ubuntu 4.8.2-16ubuntu6) 4.8.2, 64-bit
> Ubuntu trusty with kernel 3.13.0-29-generic.
>
> I have a
On 08/07/2014 09:50 PM, vpmm2007 wrote:
create or replace package CUM_A_TYPES
as
type LT_PAYMENT is record
(BASICnumber,
DPnumber,
GRADE_PAYnumber
);
TYPE TYPE_CALC_TAX is record
(
FIN_ROLE_ID number(8),
CALC_FOR_ROLE_CODE number(4));
NEED TO CONVERT TH
Hi,
Thanks for your detailed response Alban.
Primary key definition: "tracks_pkey" PRIMARY KEY, btree (id)
select version(): PostgreSQL 9.3.4 on x86_64-unknown-linux-gnu, compiled by
gcc (Ubuntu 4.8.2-16ubuntu6) 4.8.2, 64-bit
Ubuntu trusty with kernel 3.13.0-29-generic.
I have a autovacuum proce
On 09 Aug 2014, at 11:38, Alexis Bernard wrote:
> Hi,
>
> I am having regurlarly duplicated rows with the same primary key.
>
> => select id, created_at, updated_at from tracks where created_at =
> '2014-07-03 15:09:16.336488';
>id | created_at | updated_at
Hi,
I am having regurlarly duplicated rows with the same primary key.
=> select id, created_at, updated_at from tracks where created_at =
'2014-07-03 15:09:16.336488';
id | created_at | updated_at
++
331
David,
You are right of course about sample data.
I've put some data up on Pastebin here http://pastebin.com/EtVnjiYv
As for an example of an expected result from the above :
- Order individual test results asc/desc as required, so you end up for example
with for test1 as shown on paste bin
