pgsql-sql since 2012-09-30 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

Sept. 30, 2012

Thread Author Time
Re: Reuse temporary calculation results in an SQL update query [SOLVDED] David Johnston 16:26

Oct. 2, 2012

Thread Author Time
[noob] How to optimize this double pivot query? Robert Buck 00:47
Re: [noob] How to optimize this double pivot query? David Johnston 01:07
Re: [noob] How to optimize this double pivot query? Robert Buck 01:13
Re: [noob] How to optimize this double pivot query? David Johnston 01:28
Re: [noob] How to optimize this double pivot query? Thomas Kellerer 06:46
Re: [noob] How to optimize this double pivot query? Samuel Gendler 09:21
Re: [noob] How to optimize this double pivot query? Robert Buck 09:45
Re: Help in accessing array David Johnston 13:53
Re: [noob] How to optimize this double pivot query? Samuel Gendler 19:57
Re: [noob] How to optimize this double pivot query? Samuel Gendler 20:09

Oct. 3, 2012

Thread Author Time
Re: [noob] How to optimize this double pivot query? Robert Buck 16:23
Re: [noob] How to optimize this double pivot query? Robert Buck 16:31
Re: [noob] How to optimize this double pivot query? Samuel Gendler 20:05

Oct. 4, 2012

Thread Author Time
Calling the CTE for multiple inputs air 19:31
String Search Fabio Ebner - Dna Solution 19:40
Re: Calling the CTE for multiple inputs David Johnston 19:51
Re: String Search David Johnston 19:57

Oct. 5, 2012

Thread Author Time
Re: Calling the CTE for multiple inputs Craig Ringer 03:34
checking the gaps in intervals Anton Gavazuk 22:42

Oct. 6, 2012

Thread Author Time
Re: checking the gaps in intervals Andreas Kretschmer 07:44
Re: checking the gaps in intervals Andreas Kretschmer 07:55
Re: checking the gaps in intervals Gavin Flower 08:04
How to make this CTE also print rows with 0 as count? air 12:47
Re: Calling the CTE for multiple inputs air 12:56
Re: How to make this CTE also print rows with 0 as count? David Johnston 17:30
Re: checking the gaps in intervals Gavin Flower 21:58

Oct. 7, 2012

Thread Author Time
Re: Calling the CTE for multiple inputs Jasen Betts 01:02
Re: checking the gaps in intervals Jasen Betts 01:30

Oct. 8, 2012

Thread Author Time
Error 42704 Kim Bisgaard 15:38

Oct. 11, 2012

Thread Author Time
Database object names and libpq in UTF-8 locale on Windows Sebastien FLAESCH 08:56
Re: Database object names and libpq in UTF-8 locale on Windows Tom Lane 14:03
Re: Database object names and libpq in UTF-8 locale on Windows Sebastien FLAESCH 14:13
Re: checking the gaps in intervals Gavin Flower 20:25

Oct. 14, 2012

Thread Author Time
rolling statistic probaply a window function? Andreas 17:43

Oct. 19, 2012

Thread Author Time
Recursive temporal query Liam Caffrey 15:40
Re: Recursive temporal query Liam Caffrey 15:41
Re: Recursive temporal query Liam Caffrey 15:46
Trigger triggered from a foreign key Victor Sterpu 18:14
Re: Trigger triggered from a foreign key David Johnston 18:24
Insert strings that contain colons into a table lmagnell 20:24
Re: Insert strings that contain colons into a table David Johnston 20:34
Re: Insert strings that contain colons into a table lmagnell 20:49

Oct. 21, 2012

Thread Author Time
Partition database between users and implement disk quotas Brice André 19:18

Oct. 22, 2012

Thread Author Time
Re: Trigger triggered from a foreign key Jasen Betts 11:29

Oct. 26, 2012

Thread Author Time
pull in most recent record in a view Gary Stainburn 09:02
Re: pull in most recent record in a view Gary Stainburn 09:24

Oct. 28, 2012

Thread Author Time
complex query 📎 Mark Fenbers 00:01
Re: complex query Scott Marlowe 00:24
Re: complex query 📎 Mark Fenbers 01:56
Re: complex query Scott Marlowe 02:20
Re: complex query Oliveiros d'Azevedo Cristina 11:15
Re: pull in most recent record in a view David Johnston 14:54

Oct. 29, 2012

Thread Author Time
Fun with Dates 📎 Mark Fenbers 22:38
Re: Fun with Dates Thomas Kellerer 22:44
Re: Fun with Dates 📎 Mark Fenbers 22:51

Oct. 30, 2012

Thread Author Time
replace text occurrences loaded from table jan zimmek 11:45
Re: replace text occurrences loaded from table David Johnston 15:08
Fwd: replace text occurrences loaded from table jan zimmek 15:15

Nov. 5, 2012

Thread Author Time
Re: Date Index Adam Tauno Williams 10:54
Re: Date Index Tom Lane 15:13

Nov. 7, 2012

Thread Author Time
find sudstring on text (data type) field failure pantelis vlachos 08:36

Nov. 11, 2012

Thread Author Time
How to compare two tables in PostgreSQL saikiran mothe 03:13
Re: find sudstring on text (data type) field failure Craig Ringer 10:24

Nov. 12, 2012

Thread Author Time
Re: How to compare two tables in PostgreSQL Rob Sargentg 07:23
Re: find sudstring on text (data type) field failure Achilleas Mantzios 07:52
Re: How to compare two tables in PostgreSQL Allan Kamau 08:00
Re: How to compare two tables in PostgreSQL Willem Leenen 09:13
Re: How to compare two tables in PostgreSQL Willem Leenen 09:20
Re: How to compare two tables in PostgreSQL Devrim GÜNDÜZ 09:28
Re: How to compare two tables in PostgreSQL Allan Kamau 10:44

Nov. 13, 2012

Thread Author Time
Re: How to compare two tables in PostgreSQL Igor Neyman 15:19

Nov. 17, 2012

Thread Author Time
organizing cron jobs in one function Louis-David Mitterrand 16:19

Nov. 18, 2012

Thread Author Time
Re: organizing cron jobs in one function Jasen Betts 00:50
Re: organizing cron jobs in one function Craig Ringer 11:27
Re: organizing cron jobs in one function Louis-David Mitterrand 17:11

Nov. 19, 2012

Thread Author Time
Re: organizing cron jobs in one function Craig Ringer 00:31
Re: organizing cron jobs in one function Louis-David Mitterrand 10:09

Nov. 20, 2012

Thread Author Time
regexp_replace behavior Marcin Krawczyk 14:43
Re: regexp_replace behavior Alvaro Herrera 14:55
Re: regexp_replace behavior Marcin Krawczyk 15:02

Nov. 26, 2012

Thread Author Time
Using regexp_matches in the WHERE clause Thomas Kellerer 12:13

Nov. 27, 2012

Thread Author Time
locks problem Marcin Krawczyk 09:27
output query on many to many relationship into several columns ssylla 09:59
Re: locks problem Marcin Krawczyk 10:01
select on many-to-many relationship ssylla 10:13
Re: Using regexp_matches in the WHERE clause Willem Leenen 11:44
Re: Using regexp_matches in the WHERE clause Thomas Kellerer 12:08
Re: Using regexp_matches in the WHERE clause Pavel Stehule 12:26
Re: Using regexp_matches in the WHERE clause Thomas Kellerer 12:30
Re: Using regexp_matches in the WHERE clause Pavel Stehule 12:35
Re: Using regexp_matches in the WHERE clause David Johnston 14:22
Re: select on many-to-many relationship Виктор Егоров 17:48

Nov. 28, 2012

Thread Author Time
Re: select on many-to-many relationship Sergey Konoplev 00:27
Joining several rows into only one JORGE MALDONADO 18:33
Re: Joining several rows into only one Jonathan S. Katz 18:37
Re: Joining several rows into only one Oliver d'Azevedo Cristina 18:42
Re: Joining several rows into only one David Johnston 18:52

Nov. 29, 2012

Thread Author Time
\copy multiline Seb 03:21
Re: \copy multiline Guillaume Lelarge 09:33
unique keys / foreign keys on two tables Gary Stainburn 10:14
Re: unique keys / foreign keys on two tables Wolfe Whalen 11:13
Re: \copy multiline Rob Sargentg 13:10
Re: \copy multiline Sebastian P. Luque 15:31
Re: \copy multiline Sebastian P. Luque 15:35

Nov. 30, 2012

Thread Author Time
Can't get upsert working. Bert 17:00

Dec. 2, 2012

Thread Author Time
Re: Can't get upsert working. Jasen Betts 09:56

Dec. 4, 2012

Thread Author Time
Re: Can't get upsert working. Richard Huxton 08:36

Dec. 12, 2012

Thread Author Time
Load UTF8@psql into latin1@mysql through JDBC Emi Lu 17:13
Re: Load UTF8@psql into latin1@mysql through JDBC Adrian Klaver 17:33
Re: Load UTF8@psql into latin1@mysql through JDBC Emi Lu 17:47
Re: Load UTF8@psql into latin1@mysql through JDBC Emi Lu 18:06
Re: Load UTF8@psql into latin1@mysql through JDBC Adrian Klaver 19:34

Dec. 21, 2012

Thread Author Time
deciding on one of multiple results returned Wes James 16:31
Re: deciding on one of multiple results returned David Johnston 16:46
Re: deciding on one of multiple results returned Seth Gordon 16:57
Re: deciding on one of multiple results returned Wes James 17:28
Re: deciding on one of multiple results returned Scott Marlowe 18:22
Re: deciding on one of multiple results returned Wes James 18:50

Dec. 24, 2012

Thread Author Time
Help with a select statement design JORGE MALDONADO 16:30

Dec. 27, 2012

Thread Author Time
strange corruption? John Fabiani 14:27
Re: strange corruption? Gavin Flower 16:21
Re: strange corruption? Gavin Flower 20:20
Re: strange corruption? Scott Marlowe 21:27

Dec. 28, 2012

Thread Author Time
Re: strange corruption? msi77 03:26
sql basic question Antonio Parrotta 11:23
Re: sql basic question Anton Gavazuk 11:38
Re: sql basic question Antonio Parrotta 11:43
Re: sql basic question Anton Gavazuk 11:48
Re: sql basic question Antonio Parrotta 14:12
Fwd: Re: sql basic question Andreas Kretschmer 14:21
Re: sql basic question Antonio Parrotta 14:52
Re: sql basic question Andreas Kretschmer 15:30
Re: Help with a select statement design Andreas Kretschmer 15:42
Re: Help with a select statement design Franz Timmer 16:12
Re: Find Out a Way to Recover Data From Android Phone johnmethew 23:11

Dec. 29, 2012

Thread Author Time
Query execution based on a condition JORGE MALDONADO 19:05
Re: Query execution based on a condition David Johnston 19:23
Re: Query execution based on a condition msi77 19:36
Re: Query execution based on a condition Adrian Klaver 19:46

Jan. 7, 2013

Thread Author Time
Split a string to rows? Emi Lu 19:44
Re: Split a string to rows? Steve Crawford 19:54
Re: Split a string to rows? Jonathan S. Katz 19:58
Re: Split a string to rows? Emi Lu 20:16
Re: Split a string to rows? Emi Lu 20:21
Re: Split a string to rows? Thomas Kellerer 20:31

Jan. 8, 2013

Thread Author Time
Re: Split a string to rows? Emi Lu 14:34
Re: Split a string to rows? [email protected] 14:37
Re: Split a string to rows? Dave Page 14:39
copy users/groups Edward W. Rouse 15:08
Re: copy users/groups Adrian Klaver 15:25
How to generate drop cascade with pg_dump Emi Lu 21:53

Jan. 9, 2013

Thread Author Time
Re: How to generate drop cascade with pg_dump Adrian Klaver 16:52

Jan. 15, 2013

Thread Author Time
Why doesn't this work Barbara Woolums 11:50
Re: Why doesn't this work Bèrto ëd Sèra 11:55
Re: Why doesn't this work Leif Biberg Kristensen 11:58
Re: Why doesn't this work Rob Sargent 15:04
Re: returning values from dynamic SQL to a variable kgeographer 17:08
Curious problem of using BETWEEN with start and end being the same versus EQUALS '=' Venky Kandaswamy 18:18
Re: returning values from dynamic SQL to a variable Pavel Stehule 18:23
Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '=' Tom Lane 22:30
Re: [SQL] Curious problem of using BETWEEN with start and end being the same versus EQUALS '=' Venky Kandaswamy 22:44

Jan. 16, 2013

Thread Author Time
Re: returning values from dynamic SQL to a variable Karl Grossner 00:40
returning the number of rows output by a copy command from a function James Sharrett 16:30
Re: returning the number of rows output by a copy command from a function Rob Sargent 16:36
Re: returning the number of rows output by a copy command from a function Adrian Klaver 16:42
Re: returning the number of rows output by a copy command from a function Misa Simic 16:55
Re: returning the number of rows output by a copy command from a function James Sharrett 17:13
Re: returning the number of rows output by a copy command from a function James Sharrett 17:16
Re: returning the number of rows output by a copy command from a function Pavel Stehule 17:19
Re: returning the number of rows output by a copy command from a function Adrian Klaver 17:21
Re: returning the number of rows output by a copy command from a function James Sharrett 17:26
Re: returning the number of rows output by a copy command from a function Adrian Klaver 17:29
returning the number of rows output by a copy command from a function Misa Simic 17:33
Re: returning the number of rows output by a copy command from a function Misa Simic 17:46

Jan. 17, 2013

Thread Author Time
Re: returning the number of rows output by a copy command from a function Jasen Betts 10:54
number of values updated per column Willy-Bas Loos 17:36
Re: number of values updated per column Akihiro Okuno 18:30
Aggregate over a linked list M Lubratt 23:19
Re: Aggregate over a linked list Venky Kandaswamy 23:30

Jan. 20, 2013

Thread Author Time
[No subject] wln 03:35

Jan. 22, 2013

Thread Author Time
need some magic with generate_series() Andreas 21:41
Re: need some magic with generate_series() jan zimmek 21:49
Re: need some magic with generate_series() Filip Rembiałkowski 21:52
Re: need some magic with generate_series() Andreas 22:49

Jan. 23, 2013

Thread Author Time
Re: [SQL] need some magic with generate_series() Alexander Gataric 00:08
Re: need some magic with generate_series() Andreas 01:00
Re: [SQL] need some magic with generate_series() Alexander Gataric 01:37
vacuum / analyze parent tables on partitioned tables. Bert 10:21
Range types (DATERANGE, TSTZRANGE) in a foreign key with "inclusion" logic Matthias Nagel 10:28
Problem with extract(epoch from interval ... Kaloyan Iliev 10:54
Re: Problem with extract(epoch from interval ... Ian Lawrence Barwick 11:00
Re: Problem with extract(epoch from interval ... Kaloyan Iliev 11:23
Re: Re: [SQL] need some magic with generate_series() Andreas 12:11
Re: Problem with extract(epoch from interval ... Adrian Klaver 14:37

Jan. 24, 2013

Thread Author Time
How to access multicolumn function results? Andreas 00:58
Re: How to access multicolumn function results? Tom Lane 01:42

Jan. 29, 2013

Thread Author Time
Writeable CTE Not Working? Kong Man 02:32
Re: Writeable CTE Not Working? Виктор Егоров 07:40
Re: Writeable CTE Not Working? Kong Man 19:29

Browse Archives

Prev | Next