pgsql-sql - October 2008

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
Jump to day: 1 2 3 6 7 8 9 10 11 13 14 15 16 17 20 22 23 24 25 26 27 28 29 30 31

Oct. 1, 2008

Thread Author Time
Re: Can COPY update or skip existing records? Rafael Domiciano 01:07
Re: Can COPY update or skip existing records? Gurjeet Singh 02:27
Re: Can COPY update or skip existing records? Scott Marlowe 02:30
Accessing elements of bytea[] always returns NULL Sestak, John S 15:06
Re: Accessing elements of bytea[] always returns NULL Tom Lane 15:47
Re: Can COPY update or skip existing records? Tony Wasson 16:33

Oct. 2, 2008

Thread Author Time
Query how-to Montaseri 20:49
Re: Query how-to Richard Broersma 21:10
Re: Query how-to Frank Bax 22:04

Oct. 3, 2008

Thread Author Time
Re: Query how-to Marc Mamin 12:20
For each key, find row with highest value of other field Raj Mathur 18:55
Re: For each key, find row with highest value of other field Oliveiros Cristina 19:11
Re: For each key, find row with highest value of other field Fernando Hevia 19:19
Re: For each key, find row with highest value of other field Mark Roberts 19:57
Re: Query how-to Marc Mamin 20:29

Oct. 6, 2008

Thread Author Time
many-to-many relationship Louis-David Mitterrand 13:08
Re: many-to-many relationship Dave Steinberg 13:30
Re: many-to-many relationship Louis-David Mitterrand 15:25
pg_dump more than one table in one command? Emi Lu 21:02
Re: pg_dump more than one table in one command? Harold A. Giménez Ch. 21:24
Re: pg_dump more than one table in one command? Scott Marlowe 21:48
Re: pg_dump more than one table in one command? Harold A. Giménez Ch. 21:52

Oct. 7, 2008

Thread Author Time
Array from INSERT .. RETURNING in plpgsql? Erik Jones 07:27
Re: Array from INSERT .. RETURNING in plpgsql? Pavel Stehule 07:54

Oct. 8, 2008

Thread Author Time
Re: many-to-many relationship Steve Midgley 00:16
Re: many-to-many relationship Louis-David Mitterrand 09:25
100% CPU at concurent access Sabin Coanda 16:56
Re: 100% CPU at concurent access Tom Lane 23:13

Oct. 9, 2008

Thread Author Time
Re: Insert a space between each character Dirk Jagdmann 06:20
trigger parameters, what am I doing wrong ?? Marcin Krawczyk 07:11
Re: 100% CPU at concurent access Sabin Coanda 09:37
sequence number in a result Campbell, Lance 16:31
Re: sequence number in a result Oliveiros Cristina 16:48
Re: sequence number in a result Oliveiros Cristina 16:49
Re: sequence number in a result Relyea, Mike 17:05
Re: sequence number in a result Tom Lane 17:14
Re: trigger parameters, what am I doing wrong ?? Tom Lane 17:22
Re: many-to-many relationship Steve Midgley 19:16

Oct. 10, 2008

Thread Author Time
Re: trigger parameters, what am I doing wrong ?? Bart Degryse 07:06
SELECT multiple MAX(id)s ? Aarni Ruuhimäki 10:56
Re: 100% CPU at concurent access Sabin Coanda 11:25
replicating a table in several databases Gerardo Herzig 11:58
Re: replicating a table in several databases Chris Browne 14:59
Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier 16:08
Re: Problem with delete trigger: how to allow only triggers to delete a row? Adrian Klaver 17:23
Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier 17:55
Re: Problem with delete trigger: how to allow only triggers to delete a row? Alvaro Herrera 18:05
Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier 18:25
Re: Problem with delete trigger: how to allow only triggers to delete a row? Alvaro Herrera 18:39
Re: Problem with delete trigger: how to allow only triggers to delete a row? Tom Lane 20:53
Re: Problem with delete trigger: how to allow only triggers to delete a row? Adrian Klaver 20:57
Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier 21:16
Re: Problem with delete trigger: how to allow only triggers to delete a row? Adrian Klaver 22:10

Oct. 11, 2008

Thread Author Time
EXISTS Denis Woodbury 11:22
Re: EXISTS Leif B. Kristensen 12:32
Re: EXISTS Tom Lane 17:32

Oct. 13, 2008

Thread Author Time
Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Christopher Maier 18:15
Re: Problem with delete trigger: how to allow only triggers to delete a row? Christopher Maier 18:21
Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Tom Lane 18:30
Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Adrian Klaver 19:08
Updating Query of 1 table from data in another Chris Preston 19:23
Re: Updating Query of 1 table from data in another Scott Marlowe 19:52
Re: Order of trigger execution: AFTER DELETE ON EACH ROW doesn't appear to be working properly Christopher Maier 20:12

Oct. 14, 2008

Thread Author Time
Re: EXISTS Craig Ringer 07:48
Re: EXISTS Denis Woodbury 14:03
Re: SELECT multiple MAX(id)s ? Fernando Hevia 15:27
effectiveness tool Judith Altamirano 22:34
Re: effectiveness tool Adrian Klaver 23:54

Oct. 15, 2008

Thread Author Time
Re: effectiveness tool Scott Marlowe 00:01
Re: replicating a table in several databases Scott Marlowe 00:14
Re: replicating a table in several databases zouguanghui 00:59
Re: effectiveness tool Stefano Buliani 07:40
Re: Updating Query of 1 table from data in another Scott Marlowe 14:26

Oct. 16, 2008

Thread Author Time
Most efficient way to achieve this ts_query Jamie Tufnell 01:00
Re: Most efficient way to achieve this ts_query Frank Bax 03:49
Search fields in multiple tables Raj Mathur 04:01
Re: Most efficient way to achieve this ts_query Jamie Tufnell 04:41
Re: Search fields in multiple tables Oliveiros Cristina 14:02

Oct. 17, 2008

Thread Author Time
returning count(*) when it is > 1, else -1 Gerardo Herzig 11:45
Re: returning count(*) when it is > 1, else -1 Pavel Stehule 12:00
Re: returning count(*) when it is > 1, else -1 Richard Huxton 12:01
Re: returning count(*) when it is > 1, else -1 Gerardo Herzig 12:11
Re: returning count(*) when it is > 1, else -1 Gerardo Herzig 12:27
Re: returning count(*) when it is > 1, else -1 Achilleas Mantzios 12:28
Re: returning count(*) when it is > 1, else -1 Tom Lane 12:32
Re: returning count(*) when it is > 1, else -1 Gerardo Herzig 12:50

Oct. 20, 2008

Thread Author Time
my rules wont execute aldy 08:23
generating date sequences Patrick Scharrenberg 13:24
Re: generating date sequences A. Kretschmer 13:40
Re: generating date sequences Patrick Scharrenberg 13:55
Full Text Index Stats Ryan Hansen 19:32

Oct. 22, 2008

Thread Author Time
grouping/clustering query David Garamond 05:14

Oct. 23, 2008

Thread Author Time
Re: Full Text Index Stats Oleg Bartunov 06:52
Postgres-sql-php Zied Kharrat 08:14
Re: SELECT multiple MAX(id)s ? Aarni 10:00
Re: Postgres-sql-php Oliveiros Cristina 10:28
Re: Postgres-sql-php Zied Kharrat 12:46
Re: Postgres-sql-php Oliveiros Cristina 13:25
Re: grouping/clustering query Steve Midgley 16:08
Re: Postgres-sql-php Oliveiros Cristina 18:00
Re: grouping/clustering query Joe 18:28

Oct. 24, 2008

Thread Author Time
Re: grouping/clustering query Steve Midgley 15:04
Re: grouping/clustering query Oliveiros Cristina 15:20
Re: grouping/clustering query Tony Wasson 17:24
Re: grouping/clustering query Tony Wasson 20:48

Oct. 25, 2008

Thread Author Time
Re: grouping/clustering query David Garamond 01:50
Truncate on pg_dump / pg_restore Bryce Nesbitt 06:32
Re: Truncate on pg_dump / pg_restore chris smith 10:18
Re: Truncate on pg_dump / pg_restore 📎 Bryce Nesbitt 15:23
Re: Truncate on pg_dump / pg_restore Harold A. Giménez Ch. 15:36
SQL Statement Missing From Log Bryce Nesbitt 21:42

Oct. 26, 2008

Thread Author Time
how to sum entries from the last entry to some entry in between dynamically? Devil™ Dhuvader 18:22

Oct. 27, 2008

Thread Author Time
Re: SQL Statement Missing From Log Tom Lane 12:15
How to hand over array as variable in plpgsql function? Jan Peters 16:25
Fwd: grouping/clustering query Osvaldo Kussama 19:28
Re: How to hand over array as variable in plpgsql function? Tom Lane 19:46

Oct. 28, 2008

Thread Author Time
Re: How to hand over array as variable in plpgsql function? Jan Peters 08:23
Performing intersection without intersect operator Nacef LABIDI 11:14
Re: Performing intersection without intersect operator Oliveiros Cristina 11:51
Re: Performing intersection without intersect operator Peter Eisentraut 11:59
Re: How to hand over array as variable in plpgsql function? Tom Lane 12:31
join table? Michael Higgins 19:56

Oct. 29, 2008

Thread Author Time
Comparing sequential rows in a result Murray Long 09:01
Re: Comparing sequential rows in a result Murray Long 09:25
simple SQL query Kevin Duffy 17:39
Re: simple SQL query Andreas Joseph Krogh 19:58
Re: simple SQL query Kevin Duffy 20:56
Re: simple SQL query Andreas Joseph Krogh 21:50
trying to repair a bad header block gherzig 21:59
Re: trying to repair a bad header block Tom Lane 22:23
Re: trying to repair a bad header block Scott Marlowe 22:29

Oct. 30, 2008

Thread Author Time
Re: trying to repair a bad header block Tom Lane 00:36
Re: trying to repair a bad header block Scott Marlowe 01:24
Re: trying to repair a bad header block Scott Marlowe 01:25
Re: simple SQL query Tom Lane 02:30
Re: trying to repair a bad header block gherzig 10:26
Re: trying to repair a bad header block gherzig 10:28
Subqueries Pascal Tufenkji 12:17
Re: Subqueries Oliveiros Cristina 12:49
Re: Subqueries Helio Campos Mello de Andrade 12:52
Date Index Ryan Hansen 20:49
Re: Date Index Scott Marlowe 21:06

Oct. 31, 2008

Thread Author Time
Re: Date Index A. Kretschmer 07:48
Re: Subqueries Pascal Tufenkji 09:26
Re: Subqueries Gregory Stark 10:58

Browse Archives

Prev | Next
Jump to day: 1 2 3 6 7 8 9 10 11 13 14 15 16 17 20 22 23 24 25 26 27 28 29 30 31