pgsql-sql since 2015-03-10 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

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
Re: self join issue Marc Mamin 19:45

June 22, 2015

Thread Author Time
Re: extracting PII data and transforming it across table. Suresh Raja 21:09
Run analyze on schema Suresh Raja 21:10
Re: Run analyze on schema Jerry Sievers 23:53

June 24, 2015

Thread Author Time
Re: [GENERAL] Run analyze on schema Suresh Raja 03:34

June 29, 2015

Thread Author Time
Disable Trigger for session only gmb 07:43
Re: Disable Trigger for session only Adrian Klaver 13:06
Re: Disable Trigger for session only gmb 14:13
Re: Disable Trigger for session only Adrian Klaver 14:26
Re: Disable Trigger for session only Greg Sabino Mullane 20:34
Re: Disable Trigger for session only Adrian Klaver 20:43

June 30, 2015

Thread Author Time
Re: Disable Trigger for session only gmb 07:17
Re: Disable Trigger for session only gmb 08:31

July 1, 2015

Thread Author Time
[C#] File Upload to PostgreSQL drunken 08:10
Re: [C#] File Upload to PostgreSQL David G. Johnston 12:17

July 2, 2015

Thread Author Time
PGSQL-Performance mailing list John Sherwood 10:52

July 3, 2015

Thread Author Time
Re: Help with 'contestant' query Greg Sabino Mullane 19:36

July 7, 2015

Thread Author Time
Backups failing despite many settings that should prevent it John Sherwood 13:35
Re: Backups failing despite many settings that should prevent it Tom Lane 14:28

July 8, 2015

Thread Author Time
Oracle to PostgreSQL Migration - Need Information Tim Clotworthy 16:30
Re: Oracle to PostgreSQL Migration - Need Information [email protected] 18:21
encrypt psql password in unix script Suresh Raja 18:34
Re: encrypt psql password in unix script John R Pierce 18:46
Re: encrypt psql password in unix script Steve Midgley 19:01

Browse Archives

Prev | Next