pgsql-sql since 2013-07-24 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

July 24, 2013

Thread Author Time
Re: Advice on key design Anton Gavazuk 08:16
Re: Advice on key design Stanley Hui 08:23
Re: Advice on key design Bèrto ëd Sèra 08:38
Re: Advice on key design Luca Ferrari 09:39
Re: Advice on key design Bèrto ëd Sèra 09:47
Re: Listing table definitions by only one command Luca Ferrari 10:00
Re: Advice on key design Luca Ferrari 10:05
Re: Advice on key design Bèrto ëd Sèra 10:12
Re: monthly statistics Luca Ferrari 11:27

July 25, 2013

Thread Author Time
value from max row in group by Gary Stainburn 17:45
Re: value from max row in group by Gary Stainburn 17:57
Re: value from max row in group by bricklen 17:58
Re: value from max row in group by Venky Kandaswamy 18:03
Re: value from max row in group by Marc Mamin 18:53

July 26, 2013

Thread Author Time
Re: value from max row in group by Gary Stainburn 08:18
Unique index and unique constraint JORGE MALDONADO 21:44
Re: Unique index and unique constraint Luca Vernini 22:07
Re: Unique index and unique constraint Alvaro Herrera 22:19
Criteria to define indexes JORGE MALDONADO 23:10

July 27, 2013

Thread Author Time
Re: Criteria to define indexes David Johnston 00:31
Re: Unique index and unique constraint Sergey Konoplev 01:56
Re: Unique index and unique constraint Dmitriy Igrishin 07:13

Aug. 3, 2013

Thread Author Time
Presenting data in 5 Rows & 5 Cols for 25 specific values F Bax 13:26
Re: Presenting data in 5 Rows & 5 Cols for 25 specific values Rob Sargentg 21:41

Aug. 5, 2013

Thread Author Time
Re: Presenting data in 5 Rows & 5 Cols for 25 specific values Rob Sargentg 04:01

Aug. 25, 2013

Thread Author Time
function array_to_string(text[]) does not exist Victor Sterpu 12:15
Re: function array_to_string(text[]) does not exist Jov 12:33
Re: function array_to_string(text[]) does not exist Pavel Stehule 13:18

Aug. 28, 2013

Thread Author Time
Is there a way to build a query based on data in a table? Herouth Maoz 10:07
Re: Is there a way to build a query based on data in a table? Brice André 10:45
CTAGS for PL/pgSQL ? 📎 Charles Sheridan 15:08

Aug. 29, 2013

Thread Author Time
Re: CTAGS for PL/pgSQL ? Luca Ferrari 12:57
Re: Using regexp_matches in the WHERE clause spulatkan 13:12
Re: CTAGS for PL/pgSQL ? Charles Sheridan 13:18
Re: CTAGS for PL/pgSQL ? Bruce Momjian 13:33
Re: Using regexp_matches in the WHERE clause David Johnston 13:43
Re: CTAGS for PL/pgSQL ? Luca Ferrari 14:00
Re: CTAGS for PL/pgSQL ? Charles Sheridan 14:17

Aug. 30, 2013

Thread Author Time
Re: Find Out a Way to Recover Data From Android Phone walerina 08:55

Sept. 3, 2013

Thread Author Time
Trigger for updating view with join Dmitry Morozovsky 23:38

Sept. 4, 2013

Thread Author Time
Re: Trigger for updating view with join Dmitry Morozovsky 05:20
Re: Trigger for updating view with join Dmitry Morozovsky 06:09

Sept. 6, 2013

Thread Author Time
Understanding Encoding Beena Emerson 05:56
Re: Understanding Encoding Gopal Tandon 06:01
Re: [NOVICE] Understanding Encoding Amit Langote 06:37
Re: [NOVICE] Understanding Encoding Beena Emerson 06:47
Re: [SQL] Understanding Encoding Tom Lane 06:59
Re: Understanding Encoding Tatsuo Ishii 07:03
Re: [NOVICE] Understanding Encoding Amit Langote 07:14
Re: [SQL] Understanding Encoding Beena Emerson 07:24
Re: Understanding Encoding Sebastien FLAESCH 07:53
Re: Understanding Encoding Beena Emerson 09:23

Sept. 11, 2013

Thread Author Time
Re: apt.postgresql.org vs. Pitti PPA - install error rawi 09:51
Re: apt.postgresql.org vs. Pitti PPA - install error Jan Lentfer 11:12
Re: apt.postgresql.org vs. Pitti PPA - install error rawi 12:00

Sept. 15, 2013

Thread Author Time
removing duplicates and using sort Nathan Mailg 02:36

Sept. 16, 2013

Thread Author Time
Re: removing duplicates and using sort Edward W. Rouse 14:04
Re: removing duplicates and using sort David Johnston 14:42

Sept. 17, 2013

Thread Author Time
Re: removing duplicates and using sort Nathan Mailg 16:03

Sept. 19, 2013

Thread Author Time
xmlElement and \n Enrico Oliva 07:46
Re: xmlElement and \n Luca Ferrari 08:52

Sept. 20, 2013

Thread Author Time
detect initiator of update/delete action ssylla 07:52
Re: detect initiator of update/delete action Luca Ferrari 13:47
unique key problem on update Gary Stainburn 16:07
Re: unique key problem on update Thomas Kellerer 16:26
Re: unique key problem on update Gary Stainburn 16:30
Re: unique key problem on update Thomas Kellerer 16:42
the value of OLD on an initial row insert James Sharrett 16:43

Sept. 23, 2013

Thread Author Time
Comparison semantics of CHAR data type Thomas Fanghaenel 00:51
Re: the value of OLD on an initial row insert Luca Ferrari 06:45

Sept. 25, 2013

Thread Author Time
postgres subfunction return error jonathansfl 23:11
Re: postgres subfunction return error David Johnston 23:19
Re: postgres subfunction return error jonathansfl 23:33

Sept. 27, 2013

Thread Author Time
Re: postgres subfunction return error jonathansfl 14:57
Can I simplify this somehow? Larry Rosenman 15:22
Re: postgres subfunction return error David Johnston 17:42
Re: Can I simplify this somehow? Adam Jelinek 19:24
Re: Can I simplify this somehow? Larry Rosenman 19:32
Re: postgres subfunction return error jonathansfl 21:02
Re: Can I simplify this somehow? Sergey Konoplev 23:12

Sept. 30, 2013

Thread Author Time
openclinica hugh holston 23:20
Re: openclinica Adrian Klaver 23:36

Oct. 1, 2013

Thread Author Time
PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Sergey Klochkov 09:07
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Jov 10:04
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Sergey Klochkov 10:23
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Sergey Klochkov 10:46
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Giuseppe Broccolo 11:01
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Sergey Klochkov 11:12
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects bricklen 12:30
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Magnus Hagander 12:49
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Alejandro Brust 19:30
DB link from postgres to Oracle; how to query Dbname.tablename? Bhanu Murthy 23:41

Oct. 2, 2013

Thread Author Time
Re: [SQL] DB link from postgres to Oracle; how to query Dbname.tablename? Jayadevan M 07:26
Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename? Albe Laurenz 07:58
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects Sergey Klochkov 14:44
Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename? Chris Twombly 17:03

Oct. 3, 2013

Thread Author Time
Re: Help needed with Window function David Johnston 01:06
Re: Help needed with Window function gmb 05:10

Oct. 4, 2013

Thread Author Time
Re: Help needed with Window function Akihiro Okuno 03:08
Unique index VS unique constraint JORGE MALDONADO 16:48
Re: Unique index VS unique constraint [email protected] 17:41
Re: Unique index VS unique constraint Adrian Klaver 19:43
Re: Unique index VS unique constraint Adrian Klaver 19:49
Advice on defining indexes JORGE MALDONADO 21:28
Re: Advice on defining indexes David Johnston 22:09
Re: Advice on defining indexes JORGE MALDONADO 22:23
Re: Unique index VS unique constraint David Johnston 22:38
Re: Advice on defining indexes David Johnston 22:44

Oct. 5, 2013

Thread Author Time
Re: Unique index VS unique constraint Steve Grey 02:20
Re: Unique index VS unique constraint David Johnston 03:42
Re: Unique index VS unique constraint JORGE MALDONADO 22:24

Oct. 6, 2013

Thread Author Time
Re: Unique index VS unique constraint Sergey Konoplev 00:59

Oct. 8, 2013

Thread Author Time
[No subject] Kaleeswaran Velu 16:23
Re: Plugge, Joe R. 16:26
Re: Andreas Kretschmer 16:28
Many to many link tables with history? Craig R. Skinner 17:04

Oct. 9, 2013

Thread Author Time
Question about index/constraint definition in a table JORGE MALDONADO 22:23
Re: Question about index/constraint definition in a table David Johnston 22:31

Oct. 10, 2013

Thread Author Time
Re: Question about index/constraint definition in a table David Johnston 01:11
Re: Kaleeswaran Velu 03:54
generate a range within a view Gary Stainburn 10:26
Re: generate a range within a view Gary Stainburn 11:03
Re: Many to many link tables with history? Craig R. Skinner 20:23
Re: Many to many link tables with history? Dylan Sanders 20:25
Re: Many to many link tables with history? Craig R. Skinner 20:55

Oct. 11, 2013

Thread Author Time
Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects luckyjackgao 07:24
Re: [SQL] Comparison semantics of CHAR data type Bruce Momjian 19:44
Re: [SQL] Comparison semantics of CHAR data type Kevin Grittner 20:58

Oct. 14, 2013

Thread Author Time
Re: [SQL] Comparison semantics of CHAR data type Thomas Fanghaenel 17:57

Oct. 16, 2013

Thread Author Time
PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK Craig R. Skinner 12:50
Re: PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK Craig R. Skinner 14:41
Re: [SQL] Comparison semantics of CHAR data type Bruce Momjian 18:17

Oct. 17, 2013

Thread Author Time
Advice - indexing on varchar fields where only last x characters known Gary Stainburn 11:20
Re: Advice - indexing on varchar fields where only last x characters known Jayadevan M 11:35
Re: Advice - indexing on varchar fields where only last x characters known Craig R. Skinner 11:45
Re: Advice - indexing on varchar fields where only last x characters known Gavin Flower 18:27
Re: Advice - indexing on varchar fields where only last x characters known Alvaro Herrera 18:39
Re: Advice - indexing on varchar fields where only last x characters known Gavin Flower 18:43
Re: Advice - indexing on varchar fields where only last x characters known David Johnston 19:16

Oct. 18, 2013

Thread Author Time
Re: Re: Advice - indexing on varchar fields where only last x characters known Gary Stainburn 07:22
Re: Re: Advice - indexing on varchar fields where only last x characters known Craig R. Skinner 11:37
Re: Advice - indexing on varchar fields where only last x characters known David Johnston 13:44

Oct. 21, 2013

Thread Author Time
Re: Re: Advice - indexing on varchar fields where only last x characters known Gary Stainburn 09:52

Oct. 24, 2013

Thread Author Time
Number of days in a tstzrange? Craig R. Skinner 20:46
Re: Number of days in a tstzrange? Jonathan S. Katz 21:00

Oct. 25, 2013

Thread Author Time
index on values stored in a json array Raphael Bauduin 09:17
Re: index on values stored in a json array Jonathan S. Katz 14:21

Oct. 28, 2013

Thread Author Time
Re: index on values stored in a json array Raphael Bauduin 07:30

Oct. 29, 2013

Thread Author Time
sum of until (running balance) and sum of over date range in the same query M. D. 03:42
Re: sum of until (running balance) and sum of over date range in the same query David Johnston 04:17
Re: Number of days in a tstzrange? Craig R. Skinner 11:34
Re: Re: sum of until (running balance) and sum of over date range in the same query M. D. 13:19

Oct. 30, 2013

Thread Author Time
Re: Number of days in a tstzrange? Craig R. Skinner 10:40
Re: Number of days in a tstzrange? Gavin Flower 18:21

Nov. 4, 2013

Thread Author Time
json and aggregate Diway 20:22
Re: json and aggregate David Johnston 20:38
Re: json and aggregate Diway 21:05
Re: json and aggregate David Johnston 21:15

Nov. 8, 2013

Thread Author Time
Query specific table using relative position in search path George Woodring 16:51
How to script inserts where id is needed as fk Michael Schmidt 19:44
Re: How to script inserts where id is needed as fk Jonathan S. Katz 19:48
Re: Query specific table using relative position in search path Sergey Konoplev 20:42
Re: Query specific table using relative position in search path George Woodring 20:57
Re: Query specific table using relative position in search path Sergey Konoplev 21:32

Nov. 9, 2013

Thread Author Time
Find datatype of a column during the backend flow Ishaya Bhatt 15:27
Re: How to script inserts where id is needed as fk Michael Schmidt 20:09
Re: How to script inserts where id is needed as fk Jonathan S. Katz 21:15
Re: How to script inserts where id is needed as fk David Johnston 21:55
Re: How to script inserts where id is needed as fk Michael Schmidt 23:20

Nov. 10, 2013

Thread Author Time
Re: Find datatype of a column during the backend flow Sergey Konoplev 23:40

Nov. 12, 2013

Thread Author Time
Function args: TEXT -vs- VARCHAR? Craig R. Skinner 18:17
Re: Function args: TEXT -vs- VARCHAR? Luca Vernini 18:23

Nov. 13, 2013

Thread Author Time
Re: Function args: TEXT -vs- VARCHAR? Sergey Konoplev 03:07
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 13:03
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 13:05
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 14:17
Re: Function args: TEXT -vs- VARCHAR? Pavel Stehule 14:20
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 14:25
Re: Function args: TEXT -vs- VARCHAR? Adrian Klaver 14:34
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 15:51
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 16:36
Re: Function args: TEXT -vs- VARCHAR? David Johnston 17:14
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 17:51
Re: Function args: TEXT -vs- VARCHAR? David Johnston 17:59
Re: Function args: TEXT -vs- VARCHAR? Craig R. Skinner 18:04
Re: Function args: TEXT -vs- VARCHAR? Tom Lane 18:31

Nov. 14, 2013

Thread Author Time
Re: Function args: TEXT -vs- VARCHAR? Sergey Konoplev 07:41

Nov. 24, 2013

Thread Author Time
Importing MySql dumped db into pgadmin miks87 15:49
Re: Importing MySql dumped db into pgadmin Theodore Petrosky 16:02
Re: Importing MySql dumped db into pgadmin Adrian Klaver 16:08
Re: Importing MySql dumped db into pgadmin miks87 16:11
Re: Importing MySql dumped db into pgadmin miks87 16:21
Re: Importing MySql dumped db into pgadmin Jan Lentfer 16:37
Re: Importing MySql dumped db into pgadmin Adrian Klaver 17:06

Nov. 25, 2013

Thread Author Time
tab delimiter in output Marcin Krawczyk 11:14
Re: tab delimiter in output Ian Lawrence Barwick 11:26
Re: tab delimiter in output Thomas Kellerer 11:42
Re: tab delimiter in output Marcin Krawczyk 12:00
Re: tab delimiter in output Marcin Krawczyk 12:01

Nov. 27, 2013

Thread Author Time
isnumeric(varchar) by psql Emi Lu 21:46

Browse Archives

Prev | Next