pgsql-sql since 2012-11-04 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

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

Jan. 30, 2013

Thread Author Time
Re: Writeable CTE Not Working? Tom Lane 01:16
Re: Writeable CTE Not Working? Kong Man 02:45

Jan. 31, 2013

Thread Author Time
Partition tables to improve select speed? Bert 09:43
How to put multiples results in just one column Nei Rauni Santos 12:35
Re: How to put multiples results in just one column Pavel Stehule 12:39
Re: How to put multiples results in just one column Nei Rauni Santos 13:55
Re: How to put multiples results in just one column Pavel Stehule 14:04
Re: Partition tables to improve select speed? Jonathan S. Katz 16:48

Feb. 5, 2013

Thread Author Time
Querying multiple database Dev Kumkar 17:12

Feb. 6, 2013

Thread Author Time
Setting a default value for a select statement without results JORGE MALDONADO 00:23
Re: Setting a default value for a select statement without results Anton Gavazuk 00:35
Re: Setting a default value for a select statement without results Ian Lawrence Barwick 00:48
index scan vs bitmap index scan Wayne Cuddy 01:13
Re: Setting a default value for a select statement without results Jasen Betts 04:07
Re: Querying multiple database Dev Kumkar 06:57
Re: Querying multiple database Dev Kumkar 11:01
Facing authentication error on postgres 9.2 -> dblink functions Dev Kumkar 13:09
Re: [ADMIN] Facing authentication error on postgres 9.2 -> dblink functions Albe Laurenz 13:30
Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions Andrew Dunstan 13:42
Re: Facing authentication error on postgres 9.2 -> dblink functions Dev Kumkar 17:55
Re: Facing authentication error on postgres 9.2 -> dblink functions Dev Kumkar 17:59
create an index on unnest Francois Payette 18:15
Re: Facing authentication error on postgres 9.2 -> dblink functions Dev Kumkar 19:19
Re: create an index on unnest Francois Payette 19:37
Re: Setting a default value for a select statement without results JORGE MALDONADO 20:04
Re: Facing authentication error on postgres 9.2 -> dblink functions Dev Kumkar 20:18

Feb. 7, 2013

Thread Author Time
Conditional expression in an UPDATE statement JORGE MALDONADO 01:08
Re: Conditional expression in an UPDATE statement Jasen Betts 06:41

Feb. 12, 2013

Thread Author Time
upsert doesn't seem to work.. Bert 09:38

Feb. 14, 2013

Thread Author Time
Re: upsert doesn't seem to work.. Sergey Konoplev 00:53

Feb. 15, 2013

Thread Author Time
Summing & Grouping in a Hierarchical Structure Don Parris 01:57
Re: Summing & Grouping in a Hierarchical Structure Alexander Gataric 04:30
Perform Function When The Rows Of A View Change Adam 20:31

Feb. 17, 2013

Thread Author Time
Volatile functions in WITH Ben Morrow 07:58
Re: upsert doesn't seem to work.. Ben Morrow 09:44
Re: Perform Function When The Rows Of A View Change Ben Morrow 10:50
How to reject overlapping timespans? Andreas 17:02
Re: How to reject overlapping timespans? Andreas Kretschmer 18:20
Re: How to reject overlapping timespans? Andreas 18:59
Re: How to reject overlapping timespans? Ben Morrow 22:26

Feb. 18, 2013

Thread Author Time
query doesn't always follow 'correct' path.. Bert 09:43
Re: query doesn't always follow 'correct' path.. Frank Lanitz 10:51
HP and libxnet ... Sebastien FLAESCH 11:44
Re: query doesn't always follow 'correct' path.. Bert 13:42