pgsql-sql - September 2007

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 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28

Sept. 1, 2007

Thread Author Time
Re: How to influence the planner Richard Ray 00:03
Re: How to influence the planner Richard Huxton 10:29

Sept. 2, 2007

Thread Author Time
Re: Request into several DBMS simultaneously on DDL and DML Dmitry Turin 05:42
Re: pg & Delphi Dmitry Turin 05:44
Re: pg & Delphi Josh Tolley 20:38
PK & FK & Index Question L D 21:12
Re: PK & FK & Index Questio Rodrigo De León 21:20

Sept. 3, 2007

Thread Author Time
Speeding up schema changes Stefan Arentz 11:22
Re: Speeding up schema changes Gregory Stark 12:26
Execute SQL statements with 'context'/predefined variables blay bloo 18:02
Constraints for grouping PostgreSQL Admin 18:31
Re: Constraints for grouping Richard Broersma Jr 20:35
Re: Constraints for grouping Richard Broersma Jr 20:40
Re: Execute SQL statements with 'context'/predefined variables chester c young 21:59

Sept. 4, 2007

Thread Author Time
Re: Constraints for grouping PostgreSQL Admin 00:21
Cast on character columns in views Luiz K. Matsumura 03:44
Re: Execute SQL statements with 'context'/predefined variables chester c young 04:08
Re: Cast on character columns in views Richard Broersma Jr 04:23
Re: Request into several DBMS simultaneously on DDL and DML Dmitry Turin 04:25
Difference between "foo is false" and "foo=false"? Partial index on boolean. 📎 Bryce Nesbitt 04:43
Re: Difference between "foo is false" and "foo=false"? Partial index on boolean. Tom Lane 04:56
Re: Difference between "foo is false" and "foo=false"? Partial index on boolean. 📎 Bryce Nesbitt 05:07
Re: Cast on character columns in views Luiz K. Matsumura 06:38
Re: Cast on character columns in views Luiz K. Matsumura 07:33
Partial index on boolean - Sometimes fails to index scan 📎 Bryce Nesbitt 07:51
EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ? Marc Mamin 08:35
Re: Difference between "foo is false" and "foo=false"? Partial index on boolean. Richard Huxton 08:43
Use of delete...returning in function problem Bart Degryse 09:03
Re: EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ? Dirk Jagdmann 09:38
8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution 📎 Aleksandr Vinokurov 10:37
Re: Use of delete...returning in function problem Richard Huxton 10:45
Re: Cast on character columns in views Richard Broersma Jr 11:03
Re: Cast on character columns in views Richard Broersma Jr 11:08
Re: Use of delete...returning in function problem Bart Degryse 12:09
Re: How to influence the planner Scott Marlowe 14:11
Re: Partial index on boolean - Sometimes fails to index scan 📎 Bryce Nesbitt 14:40
Re: Cast on character columns in views Tom Lane 15:03
Trigger to change different row in same table PostgreSQL Admin 15:13
Re: Trigger to change different row in same table PostgreSQL Admin 15:27
Re: Use of delete...returning in function problem Tom Lane 15:55
Re: How to influence the planner Richard Ray 15:56

Sept. 5, 2007

Thread Author Time
work hour calculations novice 03:45
Re: work hour calculations Raj A 03:54
Re: work hour calculations novice 03:56
Re: work hour calculations A. Kretschmer 06:45
ISO time zone format Sabin Coanda 07:30
Re: 8.0.1 to 8.0.13 upgrade added 15% lack of time of query execution 📎 Aleksandr Vinokurov 07:57
Re: ISO time zone format Achilleas Mantzios 07:58
Re: ISO time zone format Richard Huxton 08:16
Re: EXECUTE 'EXECUTE ...' or how to use dynamic prepared statements ? Marc Mamin 08:22
tsearch2 query question roy simkes 08:33
Re: ISO time zone format Sabin Coanda 13:09
Re: ISO time zone format Richard Huxton 14:32
recursive query Joel Fradkin 14:47
Re: ISO time zone format Sabin Coanda 14:54

Sept. 6, 2007

Thread Author Time
How to use serial variable to insert into muiti-recrods? hu js 07:11
Re: How to use serial variable to insert into muiti-recrods? Ashish Karalkar 07:48
Re: How to use serial variable to insert into muiti-recrods? Milen A. Radev 07:49
Re: How to use serial variable to insert into muiti-recrods? Richard Huxton 08:16
Re: How to use serial variable to insert into muiti-recrods? Jean-David Beyer 11:45

Sept. 7, 2007

Thread Author Time
to_date function anru chen 05:22
Re: to_date function Phillip Smith 06:17
Re: to_date function A. Kretschmer 06:35
Failing join with set returning function Bart Degryse 09:51
Re: work hour calculations Filip Rembiałkowski 12:13
Re: Failing join with set returning function [email protected] 13:04
SERIAL type's sequence is double-called or ? Aleksandr Vinokurov 13:40
Re: to_date function Tom Lane 14:25
Re: SERIAL type's sequence is double-called or ? Richard Huxton 14:38
Re: to_date function A. Kretschmer 17:41

Sept. 9, 2007

Thread Author Time
Re: work hour calculations novice 01:06
Re: work hour calculations Filip Rembiałkowski 11:01

Sept. 10, 2007

Thread Author Time
Function Volatility Fernando Hevia 00:24
postgresql HEAD build failure John Summerfield 00:52
Re: postgresql HEAD build failure Alvaro Herrera 01:01
Re: postgresql HEAD build failure John Summerfield 01:36
Re: postgresql HEAD build failure Alvaro Herrera 01:43
Re: Function Volatility Tom Lane 02:15
Re: postgresql HEAD build failure Tom Lane 02:51
Re: Function Volatility Fernando Hevia 13:47
Re: postgresql HEAD build failure Erik Jones 14:59

Sept. 11, 2007

Thread Author Time
Does postgresql8.2 supports multithreading? Jyoti Seth 07:08
Re: Does postgresql8.2 supports multithreading? A. Kretschmer 07:31
Re: Does postgresql8.2 supports multithreading? Dave Page 08:11
select sum within transaction problem Bart Degryse 15:45
Re: Does postgresql8.2 supports multithreading? Josh Tolley 17:29
Simple Query? Koen Bok 21:27
Re: Simple Query? Rodrigo De León 21:46
Re: Simple Query? Richard Broersma Jr 21:59

Sept. 12, 2007

Thread Author Time
Extracting hostname from URI column ogjunk-pgjedan 00:06
Re: Extracting hostname from URI column Paul Lambert 00:22
Re: Extracting hostname from URI column chester c young 00:42
Re: select sum within transaction problem Tom Lane 01:09
Re: Extracting hostname from URI column Paul Lambert 01:13
Re: Extracting hostname from URI column Andrej Ricnik-Bay 02:19
Re: Extracting hostname from URI column Paul Lambert 02:38
Re: Extracting hostname from URI column ogjunk-pgjedan 03:16
Re: Extracting hostname from URI column chester c young 03:47
Re: Extracting hostname from URI column Paul Lambert 03:53
Re: Extracting hostname from URI column chester c young 03:56
Re: Extracting hostname from URI column ogjunk-pgjedan 03:58
Re: Extracting hostname from URI column Paul Lambert 04:03
Re: Extracting hostname from URI column Alvaro Herrera 12:52
Re: Simple Query? Osvaldo Rosario Kussama 14:22

Sept. 13, 2007

Thread Author Time
Index usage in bitwise operation context W.Alphonse HAROUNY 12:34
Re: Index usage in bitwise operation context Gregory Stark 22:55

Sept. 14, 2007

Thread Author Time
Optimize querry sql Stanislas de Larocque 08:31
Optimize querry sql Stanislas de Larocque 08:32
Re: Optimize querry sql A. Kretschmer 08:49
Re: Optimize querry sql Stanislas de Larocque 10:26
Re: Optimize querry sql A. Kretschmer 11:55
Re: Optimize querry sql hubert depesz lubaczewski 11:59
Optimize querry sql Stanislas de Larocque 13:02
Re: Optimize querry sql hubert depesz lubaczewski 13:36
Re: Optimize querry sql Scott Marlowe 13:36
Re: Optimize querry sql A. Kretschmer 14:52
Re: Optimize querry sql Scott Marlowe 15:17

Sept. 15, 2007

Thread Author Time
Re: Optimize querry sql Michael Glaesemann 14:25

Sept. 16, 2007

Thread Author Time
Format intervall as hours/minutes etc Andreas Joseph Krogh 11:00
Re: Format intervall as hours/minutes etc Andreas Kretschmer 11:14
Re: Format intervall as hours/minutes etc Andreas Joseph Krogh 11:27
Re: Format intervall as hours/minutes etc Tom Lane 15:41
Re: Format intervall as hours/minutes etc Shane Ambler 16:45
Re: Format intervall as hours/minutes etc Andreas Joseph Krogh 19:32
Re: Extracting hostname from URI column Paul Lambert 22:54
Re: Extracting hostname from URI column Gregory Stark 23:18

Sept. 17, 2007

Thread Author Time
Re: Optimize querry sql Stanislas de Larocque 07:17
Re: Optimize querry sql hubert depesz lubaczewski 07:25
Re: Format interval as hours/minutes etc Oliver Elphick 12:13
Re: Extracting hostname from URI column Andrew Sullivan 14:43

Sept. 18, 2007

Thread Author Time
SQL performance help: self join or static var Steve Midgley 00:42
error dropping operator Sabin Coanda 10:55
Table transform query Philippe Lang 13:12
Re: Table transform query Philippe Lang 13:49
Re: Table transform query Rodrigo De León 13:51
Re: error dropping operator Tom Lane 15:13

Sept. 19, 2007

Thread Author Time
Re: Extracting hostname from URI column John Summerfield 05:32
Re: Table transform query Nis Jørgensen 08:13
Re: Speeding up schema changes Decibel! 15:04
Re: Speeding up schema changes Gregory Stark 17:43

Sept. 21, 2007

Thread Author Time
Re: Table transform query Philippe Lang 08:25
Many databases Stefan Arentz 22:39
Re: Many databases Stefan Arentz 23:16
Re: Many databases Richard Broersma Jr 23:33

Sept. 22, 2007

Thread Author Time
Intermittent Empty return John Mulkerin 20:31
Re: Intermittent Empty return Tom Lane 20:41
Re: Intermittent Empty return John Mulkerin 22:09
Re: Intermittent Empty return Scott Marlowe 23:14

Sept. 23, 2007

Thread Author Time
Re: Intermittent Empty return John Mulkerin 14:29
How pull Matt Magoffin 22:26

Sept. 24, 2007

Thread Author Time
Re: How pull Filip Rembiałkowski 01:15
Re: Many databases Erik Jones 04:56
Re: How pull Matt Magoffin 07:37
foreign key problem ivan marchesini 12:34
Re: Many databases Erik Jones 15:37

Sept. 25, 2007

Thread Author Time
problems with copy chester c young 00:38
Re: could not [extend relation|write block N of temporary file|write to hash-join temporary file] Alessandra Bilardi 17:28

Sept. 26, 2007

Thread Author Time
Re: foreign key problem Ashish Karalkar 13:25

Sept. 27, 2007

Thread Author Time
Problems with bulk update Venelin Arnaudov 08:21
Re: Problems with bulk update Richard Huxton 09:27
Re: Problems with bulk update Venelin Arnaudov 10:38

Sept. 28, 2007

Thread Author Time
to restore database in schema Penchalaiah P. 10:00
Re: to restore database in schema Richard Huxton 10:19
Re: problems with copy Luis Carlos Ferreira 16:21

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 21 22 23 24 25 26 27 28