pgsql-sql since 2014-12-09 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

Dec. 9, 2014

Thread Author Time
Re: Check/unique constraint question Scott Rohde 18:01
Re: Check/unique constraint question Tom Lane 18:43
Re: Check/unique constraint question Scott Rohde 22:06
Re: Check/unique constraint question Tom Lane 22:16

Dec. 12, 2014

Thread Author Time
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Josh Berkus 21:24
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 21:44
Re: [PERFORM] Re: querying with index on jsonb slower than standard column. Why? Claudio Freire 22:10
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 23:27

Dec. 13, 2014

Thread Author Time
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Tom Lane 01:20
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Andrew Dunstan 03:05
Re: Re: [SQL] querying with index on jsonb slower than standard column. Why? Claudio Freire 05:38

Dec. 14, 2014

Thread Author Time
foregin table insert error Ed Rahn 09:13
Re: foregin table insert error Adrian Klaver 14:30
Re: foregin table insert error Ed Rahn 16:49
Re: foregin table insert error Adrian Klaver 18:39
Re: foregin table insert error Adrian Klaver 18:53

Dec. 29, 2014

Thread Author Time
localtime(0) Suresh Raja 16:31
Re: localtime(0) Rene Romero Benavides 16:39
Re: localtime(0) Jonathan S. Katz 16:39

Jan. 6, 2015

Thread Author Time
Add new field with auto-icrement to existing table Brice André 16:31
Re: Add new field with auto-icrement to existing table Andreas Kretschmer 17:44
Re: Add new field with auto-icrement to existing table Brice André 20:26

Jan. 7, 2015

Thread Author Time
Count values that match elements in csv string sqlnewbie2015 00:05
Re: Count values that match elements in csv string David G Johnston 02:21
Use a TEXT string which is an output from a function for executing a new query in postgres Roy Blum 18:12
Re: Use a TEXT string which is an output from a function for executing a new query in postgres Rob Sargent 18:16

Jan. 8, 2015

Thread Author Time
Re: Use a TEXT string which is an output from a function for executing a new query in postgres Craig Ringer 00:08

Jan. 11, 2015

Thread Author Time
pg_stat_acvtivity Marcin Krawczyk 12:29
Re: pg_stat_acvtivity Pavel Stehule 13:47

Jan. 16, 2015

Thread Author Time
fifo stock calculation with window function Dmitry Teslenko 10:07

Jan. 23, 2015

Thread Author Time
commit inside a function failing Suresh Raja 19:56
Re: [SQL] commit inside a function failing Pavel Stehule 20:00
Re: commit inside a function failing Adrian Klaver 20:04
Re: [SQL] commit inside a function failing [email protected] 20:06
Better way to compute moving averages? Jason Aleski 22:58

Jan. 24, 2015

Thread Author Time
Re: Better way to compute moving averages? David G Johnston 00:50
Re: Better way to compute moving averages? Jason Aleski 02:36
Re: commit inside a function failing 📎 Christopher Browne 15:26

Jan. 26, 2015

Thread Author Time
check if the same function is already running, then exit! Suresh Raja 19:58
Re: check if the same function is already running, then exit! Pavel Stehule 20:01
Re: check if the same function is already running, then exit! Andy Colson 20:05

Jan. 28, 2015

Thread Author Time
Re: How to insert in a table the error returns by query David G Johnston 16:55
Re: How to insert in a table the error returns by query ciamblex 17:49
Re: How to insert in a table the error returns by query David G Johnston 18:22
Re: How to insert in a table the error returns by query Marc Mamin 18:52
Re: How to insert in a table the error returns by query David G Johnston 19:03

Jan. 29, 2015

Thread Author Time
Re: How to insert in a table the error returns by query Marc Mamin 18:01

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

Browse Archives

Prev | Next