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

June 7, 2013

Thread Author Time
Advice with an insert query JORGE MALDONADO 13:58
Re: Advice with an insert query Andreas Gaab 14:01
Re: Advice with an insert query Oliver d'Azevedo Cristina 14:06
Re: Advice with an insert query Thomas Kellerer 14:26

June 13, 2013

Thread Author Time
Index Usage and Running Times by FullTextSearch with prefix matching rawi 11:39
Re: Index Usage and Running Times by FullTextSearch with prefix matching Tom Lane 14:56
Re: Index Usage and Running Times by FullTextSearch with prefix matching rawi 15:20
Re: Index Usage and Running Times by FullTextSearch with prefix matching rawi 15:39
Select clause in JOIN statement JORGE MALDONADO 22:40
Re: Select clause in JOIN statement Luca Vernini 23:10

June 14, 2013

Thread Author Time
Re: Select clause in JOIN statement 📎 Andreas Joseph Krogh 07:14

June 18, 2013

Thread Author Time
apt.postgresql.org vs. Pitti PPA - install error rawi 10:12
Re: apt.postgresql.org vs. Pitti PPA - install error basti 10:43
Re: apt.postgresql.org vs. Pitti PPA - install error rawi 11:31
Re: Index Usage and Running Times by FullTextSearch with prefix matching rawi 12:49

June 20, 2013

Thread Author Time
UNNEST result order vs Array data gmb 10:40
Re: UNNEST result order vs Array data Vik Fearing 10:45
Re: UNNEST result order vs Array data gmb 11:00
Re: UNNEST result order vs Array data Achilleas Mantzios 11:15
Re: UNNEST result order vs Array data Richard Huxton 11:37
Re: UNNEST result order vs Array data Vik Fearing 12:11
Re: UNNEST result order vs Array data gmb 12:13
Re: UNNEST result order vs Array data gmb 12:32
Re: UNNEST result order vs Array data David Johnston 13:34

June 21, 2013

Thread Author Time
Re: Index Usage and Running Times by FullTextSearch with prefix matching rawi 09:31

July 3, 2013

Thread Author Time
Unquoted column names fold to lower case Dev Kumkar 09:12
Re: Unquoted column names fold to lower case Dev Kumkar 09:16
Re: Unquoted column names fold to lower case Vik Fearing 09:27
Re: Unquoted column names fold to lower case Dev Kumkar 11:25
Re: Unquoted column names fold to lower case Theodore Petrosky 13:41
Re: Unquoted column names fold to lower case Thomas Kellerer 14:16
Re: Unquoted column names fold to lower case Bruce Momjian 15:24
Re: Unquoted column names fold to lower case Dev Kumkar 15:32
Re: Unquoted column names fold to lower case Bruce Momjian 15:35
Re: Unquoted column names fold to lower case Dev Kumkar 15:50
Re: Unquoted column names fold to lower case Thomas Kellerer 16:05
Re: Unquoted column names fold to lower case Tom Lane 16:20
Re: Unquoted column names fold to lower case Bruce Momjian 16:27
Re: Unquoted column names fold to lower case Dev Kumkar 18:46
Re: Unquoted column names fold to lower case Dev Kumkar 18:49
Re: Unquoted column names fold to lower case Alvaro Herrera 19:08
Re: Unquoted column names fold to lower case Dev Kumkar 19:42
Re: Unquoted column names fold to lower case Tom Lane 19:47
Re: Unquoted column names fold to lower case Bruce Momjian 20:06
Re: Unquoted column names fold to lower case Dev Kumkar 20:30
Re: Unquoted column names fold to lower case Dev Kumkar 21:01
Re: Unquoted column names fold to lower case Bruce Momjian 23:29

July 8, 2013

Thread Author Time
monthly statistics Andreas 12:18
Update a composite nested type variable Luca Vernini 13:11
Re: Update a composite nested type variable David Johnston 19:01
Re: Update a composite nested type variable Luca Vernini 19:44
Re: Update a composite nested type variable David Johnston 23:25

July 9, 2013

Thread Author Time
delete where not in another table Campbell, Lance 19:25
Re: delete where not in another table Igor Neyman 20:36

July 11, 2013

Thread Author Time
DateDiff() function Huan Ruan 05:17
Re: DateDiff() function Gavin Flower 06:18

July 14, 2013

Thread Author Time
Re: delete where not in another table Marc Mamin 07:24

July 16, 2013

Thread Author Time
update column based on postgis query on anther table Stefan Sylla 02:53
Re: update column based on postgis query on anther table Tom Lane 05:24
Re: update column based on postgis query on anther table ssylla 07:57
Re: update column based on postgis query on anther table Igor Neyman 13:45
Re: SOLVED: update column based on postgis query on anther table Stefan Sylla 14:27

July 17, 2013

Thread Author Time
Re: update column based on postgis query on anther table Gulcin Yildirim 09:58
Listing table definitions by only one command Carla Goncalves 15:29
Re: Listing table definitions by only one command Wes James 16:07

July 18, 2013

Thread Author Time
Re: Listing table definitions by only one command Giuseppe Broccolo 16:39

July 21, 2013

Thread Author Time
Mag Gam Mag Gam 06:22

July 22, 2013

Thread Author Time
table constraint on two columns ldrlj1 14:05
Re: table constraint on two columns Vik Fearing 14:16
Re: table constraint on two columns Adrian Klaver 14:44
Re: table constraint on two columns ldrlj1 14:53

July 23, 2013

Thread Author Time
Advice on key design JORGE MALDONADO 21:44
Re: Advice on key design Anton Gavazuk 22:02
Re: Advice on key design JORGE MALDONADO 22:28

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 lucazeo@gmail.com 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

Browse Archives

Prev | Next