pgsql-sql since 2015-02-06 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

Feb. 10, 2015

Thread	Author	Time
Implementing incremental client updates	Nii Gii	11:39
Re: Implementing incremental client updates	Glyn Astill	13:05

Feb. 11, 2015

Thread	Author	Time
Advisory locks	Tom Paynter	10:32
Re: Advisory locks	daku.sandor	10:40
Re: Advisory locks	Tom Paynter	10:49

March 5, 2015

Thread	Author	Time
Schema for caching message-count in folders using triggers	Andreas Joseph Krogh	19:45
Re: Schema for caching message-count in folders using triggers	Adrian Klaver	19:59
Re: Schema for caching message-count in folders using triggers	Andreas Joseph Krogh	20:04
Re: Schema for caching message-count in folders using triggers	Adrian Klaver	20:31
Re: Schema for caching message-count in folders using triggers	Alvaro Herrera	21:16
Re: Schema for caching message-count in folders using triggers	Andreas Joseph Krogh	21:20

March 6, 2015

Thread	Author	Time
Find inconsistencies in data with date range	Jason Aleski	21:38
Re: Find inconsistencies in data with date range	Adrian Klaver	22:12

March 7, 2015

Thread	Author	Time
Re: Find inconsistencies in data with date range	David G Johnston	03:00
Re: Find inconsistencies in data with date range	s d	16:42

March 8, 2015

Thread	Author	Time
trigger to access only the last transaction	avpro avpro	22:01

March 9, 2015

Thread	Author	Time
Re: trigger to access only the last transaction	Marcos Almeida Azevedo	07:29
Re: trigger to access only the last transaction	Frank Pinto	07:46
Re: trigger to access only the last transaction	avpro avpro	07:50
Re: trigger to access only the last transaction	avpro avpro	07:50
Re: trigger to access only the last transaction	Frank Pinto	08:00
Re: trigger to access only the last transaction	s d	08:32
Strange Query - Reg	sramay	08:35
Re: Strange Query - Reg	sramay	08:36

March 10, 2015

Thread	Author	Time
Re: Strange Query - Reg	Adrian Klaver	15:53

March 12, 2015

Thread	Author	Time
Re: Find inconsistencies in data with date range	Jason Aleski	04:10

March 14, 2015

Thread	Author	Time
Re: Strange Query - Reg	bricklen	14:20

March 15, 2015

Thread	Author	Time
Perfomance 9.1.9 vs 9.4.1	Alexander Uspensky	08:51
Perfomance 9.1.9 vs 9.4.1	Alexander Uspensky	09:50
Re: Perfomance 9.1.9 vs 9.4.1	Pavel Stehule	11:34

March 16, 2015

Thread	Author	Time
Help with effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	21:59

March 17, 2015

Thread	Author	Time
Effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	07:45
Re: Effective query for listing flags in use by messages in a folder	Hector Vass	13:31
Re: Effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	21:02

March 18, 2015

Thread	Author	Time
Re: Effective query for listing flags in use by messages in a folder	Hector Vass	11:07
Re: Effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	11:59
Re: Effective query for listing flags in use by messages in a folder	Hector Vass	12:08
Re: Effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	12:20
Re: Effective query for listing flags in use by messages in a folder	Hector Vass	12:54
Re: Effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	13:01
Re: Effective query for listing flags in use by messages in a folder	Hector Vass	13:19
Re: Effective query for listing flags in use by messages in a folder	Andreas Joseph Krogh	13:37

March 19, 2015

Thread	Author	Time
Re: Effective query for listing flags in use by messages in a folder	Hector Vass	08:28
Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value	agharta	16:30
Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value	David G. Johnston	17:05

March 20, 2015

Thread	Author	Time
Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value	agharta	07:26
Re: Detect which sum of cartesian product (+ any combination of n records in tables) exceeds a value	agharta	07:31
'bitwise and' index	Lance Jacob	17:27
Re: 'bitwise and' index	Igor Neyman	17:33

March 27, 2015

Thread	Author	Time
check data for datatype	Suresh Raja	18:08
Re: check data for datatype	Raymond O'Donnell	18:14
Re: [GENERAL] check data for datatype	Jerry Sievers	18:53

March 30, 2015

Thread	Author	Time
Link Office Word form document with data from PostgreSQL	avpro avpro	08:20
Re: Link Office Word form document with data from PostgreSQL	Tim Clarke	09:22
JSON TO POSTGRE TABLE	Kavi	09:54
Re: [GENERAL] JSON TO POSTGRE TABLE	Michael Paquier	10:11
Re: JSON TO POSTGRE TABLE	Michael Paquier	10:13
Re: [SQL] JSON TO POSTGRE TABLE	Shujie Shang	10:20
Re: [SQL] Link Office Word form document with data from PostgreSQL	Hector Vass	10:48
Re: [SQL] [GENERAL] JSON TO POSTGRE TABLE	Felipe Santos	11:09
Re: [GENERAL] Link Office Word form document with data from PostgreSQL	Vincent Veyron	13:01
Re: Link Office Word form document with data from PostgreSQL	John R Pierce	15:18
Re: [SQL] Re: Link Office Word form document with data from PostgreSQL	Vincenzo Campanella	15:37
Re: Link Office Word form document with data from PostgreSQL	Andy Colson	16:48
Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL	Vincent Veyron	17:51
Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL	avpro avpro	20:51
Re: Re: [GENERAL] Link Office Word form document with data from PostgreSQL	Ken Tanzer	22:18
Re: Link Office Word form document with data from PostgreSQL	Stephen Davies	23:59

April 3, 2015

Thread	Author	Time
Thank you: an anti-question (or a Pg love letter)	Steve Midgley	23:01

April 7, 2015

Thread	Author	Time
Re: Thank you: an anti-question (or a Pg love letter)	Andrej	04:21
Re: Thank you: an anti-question (or a Pg love letter)	john	14:03
Re: check data for datatype	Gerardo Herzig	16:59
Setting the Field Separator in PSQL	Osborn, Marty	20:39
Re: [SQL] check data for datatype	Jim Nasby	21:31
Re: Setting the Field Separator in PSQL	Adrian Klaver	21:36
Re: Setting the Field Separator in PSQL	David G. Johnston	21:48
Re: Setting the Field Separator in PSQL	David G. Johnston	21:52
Re: Setting the Field Separator in PSQL	David G. Johnston	21:54
Re: Setting the Field Separator in PSQL	Adrian Klaver	21:57

April 14, 2015

Thread	Author	Time
pgsql-function	Rishi Ranjan	10:39
Re: pgsql-function	hubert depesz lubaczewski	11:27
Re: pgsql-function	Rishi Ranjan	17:20
Re: pgsql-function	David G. Johnston	17:28
Re: pgsql-function	Rishi Ranjan	17:31
Re: pgsql-function	David G. Johnston	17:37
Re: pgsql-function	hubert depesz lubaczewski	17:39
Re: pgsql-function	David G. Johnston	17:45

April 17, 2015

Thread	Author	Time
Best way to aggregate sum for each month	Andreas Joseph Krogh	22:10
Re: Best way to aggregate sum for each month	Naresh Kumar	23:29
Re: Best way to aggregate sum for each month	Andreas Joseph Krogh	23:46
Re: Best way to aggregate sum for each month	David G. Johnston	23:55

April 18, 2015

Thread	Author	Time
Re: Best way to aggregate sum for each month	Naresh Kumar	00:05
function to send email with query results	Suresh Raja	05:30
Re: [SQL] function to send email with query results	David G. Johnston	05:52
Re: function to send email with query results	John R Pierce	06:57
Re: function to send email with query results	Andreas Kretschmer	11:04
Re: [SQL] function to send email with query results	Jim Nasby	22:42

April 19, 2015

Thread	Author	Time
Re: [SQL] function to send email with query results	Anil Menon	15:59

April 21, 2015

Thread	Author	Time
How to determine offending column for insert exceptions	Shawn Gennaria	14:39
Re: How to determine offending column for insert exceptions	Adrian Klaver	14:59
Re: How to determine offending column for insert exceptions	Shawn Gennaria	15:07
Re: How to determine offending column for insert exceptions	Adrian Klaver	15:38
Re: How to determine offending column for insert exceptions	Shawn Gennaria	16:37
Re: How to determine offending column for insert exceptions	Alvaro Herrera	16:46
Re: How to determine offending column for insert exceptions	Shawn Gennaria	16:48
Re: How to determine offending column for insert exceptions	David G. Johnston	17:04
Re: How to determine offending column for insert exceptions	s d	17:05
Re: How to determine offending column for insert exceptions	Seth Gordon	17:28
Re: How to determine offending column for insert exceptions	Shawn Gennaria	17:54
Re: How to determine offending column for insert exceptions	Adrian Klaver	17:54
Re: How to determine offending column for insert exceptions	Adrian Klaver	18:05

April 27, 2015

Thread	Author	Time
Question regarding querying some JSON/JSONB	Weston Weems	14:19
Re: Question regarding querying some JSON/JSONB	Steve Midgley	18:42
Re: Question regarding querying some JSON/JSONB	Weston Weems	18:50

May 5, 2015

Thread	Author	Time
documenting tables version control	Suresh Raja	20:13
Re: documenting tables version control	Steve Midgley	20:21
Re: documenting tables version control	PT	20:22
Re: [GENERAL] documenting tables version control	Joshua D. Drake	20:28
Re: documenting tables version control	Melvin Davidson	21:42

May 6, 2015

Thread	Author	Time
Re: documenting tables version control	Tim Clarke	08:47
Re: documenting tables version control	Gavin Flower	10:04
Re: documenting tables version control	Tim Clarke	10:06
Re: documenting tables version control	Suresh Raja	14:31
Re: [GENERAL] documenting tables version control	Steve Midgley	14:35
Re: [GENERAL] documenting tables version control	Steve Midgley	14:36
Re: [SQL] documenting tables version control	Adrian Klaver	14:40

May 7, 2015

Thread	Author	Time
generating json without nulls	Tim Dudgeon	10:56
Re: generating json without nulls	Andreas Joseph Krogh	15:16
Re: generating json without nulls	Tim Dudgeon	15:29
Re: generating json without nulls	David G. Johnston	16:27
Re: generating json without nulls	Andreas Joseph Krogh	19:52

May 12, 2015

Thread	Author	Time
ERROR: column "gid" specified more than once	BahramPSQL	08:31
Re: ERROR: column "gid" specified more than once	David G. Johnston	15:07
Re: ERROR: column "gid" specified more than once	Jason Aleski	15:26
Re: ERROR: column "gid" specified more than once	David G. Johnston	15:49
Re: ERROR: column "gid" specified more than once	[email protected]	15:53
Re: ERROR: column "gid" specified more than once	David G. Johnston	16:09
Re: ERROR: column "gid" specified more than once	David G. Johnston	16:19
Re: ERROR: column "gid" specified more than once	[email protected]	17:02

May 19, 2015

Thread	Author	Time
Re: generating json without nulls	Tim Dudgeon	09:48
Does PG support bulk operation in embedded C	Ravi Krishna	23:47

May 20, 2015

Thread	Author	Time
Re: Does PG support bulk operation in embedded C	Joshua D. Drake	00:13
Re: [GENERAL] Does PG support bulk operation in embedded C 📎	Ravi Krishna	00:27
Re: [GENERAL] Does PG support bulk operation in embedded C	Joshua D. Drake	00:36
Re: [GENERAL] Does PG support bulk operation in embedded C	Michael Paquier	00:43
Re: [GENERAL] Does PG support bulk operation in embedded C	john	13:56
Re: [GENERAL] Does PG support bulk operation in embedded C	Ravi Krishna	15:23
Re: [GENERAL] Does PG support bulk operation in embedded C	Steve Midgley	15:43
Fwd: [GENERAL] Does PG support bulk operation in embedded C	Steve Midgley	18:11

May 21, 2015

Thread	Author	Time
extracting PII data and transforming it across table.	Suresh Raja	16:27
Re: extracting PII data and transforming it across table.	Steve Midgley	16:33
Re: extracting PII data and transforming it across table.	Suresh Raja	16:51
Group By with condition	JORGE MALDONADO	22:14
Re: Group By with condition	Steve Midgley	22:29
Re: Group By with condition	David G. Johnston	23:54

May 26, 2015

Thread	Author	Time
Postgres CTE issues	Shekar Tippur	15:45
Re: Postgres CTE issues	David G. Johnston	16:00
Fwd: Postgres CTE issues	David G. Johnston	16:14
Re: Postgres CTE issues	Marc Mamin	17:00
Re: Postgres CTE issues	Shekar Tippur	17:07
Re: Postgres CTE issues	Shekar Tippur	17:40
Re: Postgres CTE issues	David G. Johnston	17:56
Re: Postgres CTE issues	Shekar Tippur	17:58
PG and Temporal	Ravi Krishna	20:59

May 27, 2015

Thread	Author	Time
Re: Postgres CTE issues	daku.sandor	06:24

May 28, 2015

Thread	Author	Time
Re: [SQL] extracting PII data and transforming it across table.	John R Pierce	04:57
Drop or disable or bypass "_return" rule on select on a view.	Shashwat Arghode	06:23
Re: Drop or disable or bypass "_return" rule on select on a view.	Vincenzo Campanella	09:19
Re: Drop or disable or bypass "_return" rule on select on a view.	Shashwat Arghode	09:44
Re: Drop or disable or bypass "_return" rule on select on a view.	Luca Ferrari	10:34
Re: Drop or disable or bypass "_return" rule on select on a view.	Tom Lane	13:53
Re: Drop or disable or bypass "_return" rule on select on a view.	Merlin Moncure	14:17
Re: [NOVICE] Drop or disable or bypass "_return" rule on select on a view.	Faisal Karim	19:34

May 29, 2015

Thread	Author	Time
Re: [SQL] Drop or disable or bypass "_return" rule on select on a view.	Shashwat Arghode	06:13

June 1, 2015

Thread	Author	Time
Re: PG and Temporal	Steve Midgley	17:25
Re: PG and Temporal	Ravi Krishna	18:02

June 2, 2015

Thread	Author	Time
Re: PG and Temporal	Skylar Thompson	13:36

June 4, 2015

Thread	Author	Time
remove tablespace for primary key (*not* by drop/recreate constraint)	Emi Lu	16:41
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	David G. Johnston	17:44
Re: remove tablespace for primary key (*not* by drop/recreate constraint) 📎	Emi Lu	18:35
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	Adrian Klaver	18:50
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	David G. Johnston	18:51

June 5, 2015

Thread	Author	Time
Re: remove tablespace for primary key (*not* by drop/recreate constraint) 📎	Emi Lu	13:33
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	Igor Neyman	13:47
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	Igor Neyman	13:52
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	David G. Johnston	13:59
Re: remove tablespace for primary key (*not* by drop/recreate constraint) 📎	Emi Lu	14:00
Re: remove tablespace for primary key (*not* by drop/recreate constraint)	Igor Neyman	14:25

June 10, 2015

Thread	Author	Time
Renumber Primary Keys and Update the same as Foreign Keys	Jon Forsyth	23:05
Re: Renumber Primary Keys and Update the same as Foreign Keys	Adrian Klaver	23:51

June 11, 2015

Thread	Author	Time
Re: Renumber Primary Keys and Update the same as Foreign Keys	Jon Forsyth	20:02
Re: Renumber Primary Keys and Update the same as Foreign Keys	Adrian Klaver	20:24

June 12, 2015

Thread	Author	Time
Null principal provided for method...	Andreas Joseph Krogh	13:42
Re: Null principal provided for method...	Andreas Joseph Krogh	13:47

June 16, 2015

Thread	Author	Time
self join issue	Ed Rouse	20:41

June 17, 2015

Thread	Author	Time
Re: self join issue	David G. Johnston	15:18
EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer?	Stephen Tahmosh	15:19
Re: EnterpriseDB: PostgreSql 9.4 Where is the Language Pack Installer?	Stephen Tahmosh	15:34

June 18, 2015

Thread	Author	Time
3 foreign keys in 1 table for 3 1-to-many relations?	gvim	00:51
Re: 3 foreign keys in 1 table for 3 1-to-many relations?	David G. Johnston	01:30

Browse Archives

Prev | Next