pgsql-sql since 2013-01-05 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

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
Re: query doesn't always follow 'correct' path.. Bert 14:39
Re: query doesn't always follow 'correct' path.. Виктор Егоров 15:20
Re: query doesn't always follow 'correct' path.. Julien Cigar 15:20
Re: Summing & Grouping in a Hierarchical Structure Relyea, Mike 15:24
Re: query doesn't always follow 'correct' path.. Julien Cigar 15:28
Re: query doesn't always follow 'correct' path.. Bert 15:34

Feb. 20, 2013

Thread Author Time
Re: Volatile functions in WITH Sergey Konoplev 06:17
Re: Volatile functions in WITH Ben Morrow 08:19
Re: Volatile functions in WITH Sergey Konoplev 16:10
Re: Volatile functions in WITH Ben Morrow 18:16
Re: Volatile functions in WITH Sergey Konoplev 20:28

Feb. 21, 2013

Thread Author Time
Re: Volatile functions in WITH Ben Morrow 01:25
Re: Summing & Grouping in a Hierarchical Structure Don Parris 10:38
Re: Summing & Grouping in a Hierarchical Structure Don Parris 10:42
need help denero team 17:36
Re: need help Carlos Chapi 19:56
Re: need help denero team 20:20
Re: need help Oliver d'Azevedo Cristina 20:35
Re: need help Russell Keane 21:07
Re: need help Russell Keane 21:28
Re: need help Oliver d'Azevedo Cristina 22:26

Feb. 22, 2013

Thread Author Time
Re: Summing & Grouping in a Hierarchical Structure Alexander Gataric 03:28
Re: need help Jaime Casanova 03:55
Re: need help Russell Keane 08:31
Re: Summing & Grouping in a Hierarchical Structure Misa Simic 09:00
Re: need help Russell Keane 09:26
Re: need help denero team 10:41
Is using the xml column type a good idea for queries that need to be fast? Denis Papathanasiou 17:20
Re: need help denero team 18:30
Update HSTORE record and then delete if it is now empty - What is the correct sql? Ashwin Jayaprakash 22:46

Feb. 23, 2013

Thread Author Time
Re: Summing & Grouping in a Hierarchical Structure Don Parris 00:15
Re: Summing & Grouping in a Hierarchical Structure Don Parris 02:52
Re: Summing & Grouping in a Hierarchical Structure Bryan L Nuse 04:54
Re: Update HSTORE record and then delete if it is now empty - What is the correct sql? Ian Lawrence Barwick 05:53
Re: Update HSTORE record and then delete if it is now empty - What is the correct sql? Tom Lane 10:49
Re: Summing & Grouping in a Hierarchical Structure Misa Simic 12:19
Re: Summing & Grouping in a Hierarchical Structure Don Parris 15:50
Re: Summing & Grouping in a Hierarchical Structure Bryan L Nuse 16:15
Re: Summing & Grouping in a Hierarchical Structure Don Parris 17:53
Re: Summing & Grouping in a Hierarchical Structure Don Parris 18:00
Re: Update HSTORE record and then delete if it is now empty - What is the correct sql? Ashwin Jayaprakash 18:04
Re: Update HSTORE record and then delete if it is now empty - What is the correct sql? Ashwin Jayaprakash 18:07
Re: Summing & Grouping in a Hierarchical Structure Misa Simic 19:12
Re: Summing & Grouping in a Hierarchical Structure Ben Morrow 20:13
Re: Summing & Grouping in a Hierarchical Structure Don Parris 21:30

Feb. 24, 2013

Thread Author Time
Using Ltree For Hierarchical Structures Don Parris 22:20

Feb. 25, 2013

Thread Author Time
Euclidean distance between two sets of tuples Surfing 18:34
Creating a new database with a TEMPLATE did not work mkumbale 22:49
Re: Creating a new database with a TEMPLATE did not work Adrian Klaver 22:56

Feb. 26, 2013

Thread Author Time
Re: Creating a new database with a TEMPLATE did not work Ben Morrow 02:46
Re: Using Ltree For Hierarchical Structures Igor Neyman 14:01
Re: Using Ltree For Hierarchical Structures Misa Simic 16:14
Re: Creating a new database with a TEMPLATE did not work mkumbale 18:20
Re: Using Ltree For Hierarchical Structures Don Parris 18:22
Re: Using Ltree For Hierarchical Structures Thomas Kellerer 18:43
Re: Using Ltree For Hierarchical Structures Igor Neyman 19:30
Re: Using Ltree For Hierarchical Structures Don Parris 21:54
Re: Using Ltree For Hierarchical Structures Misa Simic 23:12

Feb. 27, 2013

Thread Author Time
Re: Using Ltree For Hierarchical Structures Igor Neyman 16:02

Feb. 28, 2013

Thread Author Time
Concatenating bytea types... Marko Rihtar 10:21
Need help revoking access WHERE state = 'deleted' Mark Stosberg 16:37
Re: Need help revoking access WHERE state = 'deleted' Ben Morrow 18:02
Re: Need help revoking access WHERE state = 'deleted' Mark Stosberg 18:35
Re: Need help revoking access WHERE state = 'deleted' Tom Lane 19:08
Re: Need help revoking access WHERE state = 'deleted' Mark Stosberg 19:29

March 1, 2013

Thread Author Time
Re: Concatenating bytea types... Richard Huxton 14:32

March 2, 2013

Thread Author Time
Re: Concatenating bytea types... Jasen Betts 05:07
Re: Need help revoking access WHERE state = 'deleted' Wayne Cuddy 18:20
I need to fill up a sparse table in an view Andreas 19:30
Re: I need to fill up a sparse table in an view Victor Yegorov 20:46
Re: Need help revoking access WHERE state = 'deleted' Ben Morrow 23:45

March 4, 2013

Thread Author Time
Migrate to Postgres - Alias a Keyword? Huan Ruan 23:17

March 5, 2013

Thread Author Time
Re: Migrate to Postgres - Alias a Keyword? Torsten Zuehlsdorff 13:45

March 9, 2013

Thread Author Time
3/9/2013 2:45:30 PM Barbara Woolums 13:45

March 12, 2013

Thread Author Time
xmlelement name Ben Morgan 13:55
Re: xmlelement name Pavel Stehule 14:27

March 14, 2013

Thread Author Time
bug in 9.2.2 ? subquery accepts wrong column name : upd Achilleas Mantzios 15:29
Re: bug in 9.2.2 ? subquery accepts wrong column name : upd Tom Lane 16:17
UPDATE query with variable number of OR conditions in WHERE JORGE MALDONADO 22:25
Re: UPDATE query with variable number of OR conditions in WHERE Ben Morrow 23:58

March 15, 2013

Thread Author Time
Re: UPDATE query with variable number of OR conditions in WHERE Tom Lane 03:15
Re: bug in 9.2.2 ? subquery accepts wrong column name : upd Achilleas Mantzios 07:49

March 16, 2013

Thread Author Time
ZIP function Victor Sterpu 19:50
Re: ZIP function Jasen Betts 23:37

March 17, 2013

Thread Author Time
Re: ZIP function Ben Morrow 01:36
Efficiency Problem Surfing 11:15
Re: Efficiency Problem Misa Simic 11:39
Re: Efficiency Problem Surfing 11:43
link Claudio Adriano Guarracino 15:47

March 18, 2013

Thread Author Time
How to split an array-column? Andreas 19:13
Re: How to split an array-column? Venky Kandaswamy 19:24
Re: How to split an array-column? Andreas 20:43

March 21, 2013

Thread Author Time
Reading from file without superuser privilege Jose Antonio Quintana/UPC 11:43
Re: Reading from file without superuser privilege Adrian Klaver 13:40

March 25, 2013

Thread Author Time
From with case Mauricio Cruz 13:48
Re: From with case Pavel Stehule 14:01

Browse Archives

Prev | Next