pgsql-sql since 2013-02-17 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

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
Re: From with case	Mauricio Cruz	14:38
Re: From with case	Ben Morrow	22:50

March 26, 2013

Thread	Author	Time
Re: From with case	Pavel Stehule	05:33
Re: From with case	Ben Morrow	06:22
Re: From with case	Pavel Stehule	07:44
Re: From with case	Pavel Stehule	08:08
how can I replace all instances of a pattern	James Sharrett	13:08
Re: how can I replace all instances of a pattern	James Sharrett	13:13
Re: how can I replace all instances of a pattern	[email protected]	13:18
Re: how can I replace all instances of a pattern	Steve Crawford	13:22
Re: how can I replace all instances of a pattern	James Sharrett	13:31

April 2, 2013

Thread	Author	Time
Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?	David Guyot (English)	14:29
Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?	Douglas J Hunley	14:47
Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?	David Guyot	14:53
Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?	Douglas J Hunley	16:51
Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?	Douglas J Hunley	16:54

April 4, 2013

Thread	Author	Time
Postgres trigger issue with update statement in it.	Kaleeswaran Velu	04:08
Re: Postgres trigger issue with update statement in it.	Wolfe Whalen	07:28
Re: Postgres trigger issue with update statement in it.	Adrian Klaver	13:16
Re: Postgres trigger issue with update statement in it.	Kaleeswaran Velu	17:54

April 5, 2013

Thread	Author	Time
Data Loss from SQL SELECT (vs. COPY/pg_dump)	Kong Man	19:56
Re: Data Loss from SQL SELECT (vs. COPY/pg_dump)	Kong Man	22:51

April 10, 2013

Thread	Author	Time
Encrypting PGBouncer to Postgres DB connections	Bhanu Murthy	18:06
Re: Encrypting PGBouncer to Postgres DB connections	AJ Weber	18:15
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	[email protected]	18:16
Advice for index design	JORGE MALDONADO	22:30

April 11, 2013

Thread	Author	Time
Re: Advice for index design	Gavin Flower	00:00
Restrict FOREIGN KEY to a part of the referenced table	Matthias Nagel	07:55
Slow update with ST_Contians()	androclos	16:38
Re: Advice for index design	Greg Sabino Mullane	23:36

April 12, 2013

Thread	Author	Time
Re: Advice for index design	Jasen Betts	13:29
Re: Restrict FOREIGN KEY to a part of the referenced table	Jasen Betts	13:53
Re: Restrict FOREIGN KEY to a part of the referenced table	Richard Broersma	19:52
Clarity on how LOCK interacts with INHERIT	Robins Tharakan	20:59
Re: Clarity on how LOCK interacts with INHERIT	Simon Riggs	21:09
pivot query with count	Tony Capobianco	21:14

April 13, 2013

Thread	Author	Time
pivot query with count	Tony Capobianco	00:28
Re: pivot query with count	David Johnston	03:26
Re: pivot query with count	David Johnston	03:29
Re: pivot query with count	Tony Capobianco	22:05

April 16, 2013

Thread	Author	Time
Peer-review requested of soft-delete scheme	Mark Stosberg	16:24
building psycopg2	Thomas Burnett	18:42

April 18, 2013

Thread	Author	Time
copy from csv, variable filename within a function	basti	07:26
Fwd: copy from csv, variable filename within a function	basti	08:34
ALTER USER abc PASSWORD - what's going on ???	Marcin Krawczyk	10:59
Re: ALTER USER abc PASSWORD - what's going on ???	SEKA Bruno-Emmanuel	11:19
Re: ALTER USER abc PASSWORD - what's going on ???	Marcin Krawczyk	11:21
Re: ALTER USER abc PASSWORD - what's going on ???	SEKA Bruno-Emmanuel	11:31
Re: Peer-review requested of soft-delete scheme	Jasen Betts	11:44
Re: copy from csv, variable filename within a function	bricklen	13:48
Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help	Sofer, Yuval	15:41
Re: Primary DB stuck becuase of unavailable standby (synchronized streaming) - please help	Andreas Kretschmer	16:38
Re: ALTER USER abc PASSWORD - what's going on ???	Guillaume Lelarge	18:18

April 19, 2013

Thread	Author	Time
SQL query with Overlapping date time ranges	chinnaobi	03:41
Re: ALTER USER abc PASSWORD - what's going on ???	Marcin Krawczyk	08:13

April 20, 2013

Thread	Author	Time
Table indexes in a SELECT with JOIN´s	JORGE MALDONADO	16:32
Re: [SQL] Table indexes in a SELECT with JOIN´s	Pavel Stehule	16:59

April 22, 2013

Thread	Author	Time
check for overlapping time intervals	Wolfgang Meiners	10:19
Re: check for overlapping time intervals	Thomas Kellerer	10:36
Re: check for overlapping time intervals	Wolfgang Meiners	18:06

April 23, 2013

Thread	Author	Time
Not Able to Delink the old tables	shabeer ece	08:01

April 25, 2013

Thread	Author	Time
execute	Mauricio Cruz	16:17

April 26, 2013

Thread	Author	Time
Re: execute	Sergey Konoplev	00:21
Re: execute	Jov	00:57

April 27, 2013

Thread	Author	Time
Re: execute	Jasen Betts	06:34

April 30, 2013

Thread	Author	Time
Correct implementation of 1:n relationship with n>0?	Wolfgang Keller	14:39
Re: Correct implementation of 1:n relationship with n>0?	Achilleas Mantzios	15:12
Re: Correct implementation of 1:n relationship with n>0?	Anton Gavazuk	15:14
Re: Correct implementation of 1:n relationship with n>0?	Misa Simic	15:35
Re: Correct implementation of 1:n relationship with n>0?	Misa Simic	16:21
Re: Correct implementation of 1:n relationship with n>0?	Vik Fearing	16:37
Re: Correct implementation of 1:n relationship with n>0?	Wolfgang Keller	18:19
Re: Correct implementation of 1:n relationship with n>0?	Wolfgang Keller	18:25
Re: Correct implementation of 1:n relationship with n>0?	Igor Neyman	18:43

May 2, 2013

Thread	Author	Time
Re: Correct implementation of 1:n relationship with n>0?	Achilleas Mantzios	07:45

May 6, 2013

Thread	Author	Time
Order of execution	JORGE MALDONADO	00:04
Re: Order of execution	Jasen Betts	09:07

May 7, 2013

Thread	Author	Time
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	handsfree	16:17
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	Bhanu Murthy	17:07

May 8, 2013

Thread	Author	Time
Re: Correct implementation of 1:n relationship with n>0?	Achilleas Mantzios	07:04
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	Albe Laurenz	07:47
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	handsfree	08:35
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	handsfree	08:40
Re: [SQL] Encrypting PGBouncer to Postgres DB connections	Albe Laurenz	09:32

May 13, 2013

Thread	Author	Time
transaction isolationa level - SERIALIZABLE	Marcin Krawczyk	09:22
Re: transaction isolationa level - SERIALIZABLE	Adrian Klaver	14:31
Re: transaction isolationa level - SERIALIZABLE	Marcin Krawczyk	22:25

May 14, 2013

Thread	Author	Time
array_agg() with join question	George Woodring	14:08
Re: array_agg() with join question	Igor Neyman	15:37
Re: Correct implementation of 1:n relationship with n>0?	Wolfgang Keller	18:33
Re: array_agg() with join question	George Woodring	19:38

May 17, 2013

Thread	Author	Time
How to right justify text in psql?	Brian Sherwood	15:26

May 18, 2013

Thread	Author	Time
Re: How to right justify text in psql?	Jov	04:07

Browse Archives

Prev | Next