pgsql-sql since 2007-08-28 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

Aug. 28, 2007

Thread Author Time
pg & Delphi Kitter Georgiy 04:41
Request into several DBMS simultaneously on DDL and DML Kitter Georgiy 04:44
Re: pg & Delphi Daniel Drotos 06:54
Re: Request into several DBMS simultaneously on DDL and DML Richard Huxton 07:58
Re: pg & Delphi Richard Huxton 07:59
Re: fetch first rows of grouped data hubert depesz lubaczewski 09:14
Re: Database normalization Sebastian Ritter 11:47
Re: fetch first rows of grouped data Michael Glaesemann 13:00
Re: Database normalization Asko Oja 13:00
Re: fetch first rows of grouped data hubert depesz lubaczewski 13:13
Re: Database normalization Andrew Sullivan 13:26
Re: Database normalization Sebastian Ritter 14:37
Re: Database normalization Bart Degryse 14:43
Re: Database normalization Erik Jones 14:46
Re: Database normalization Andrew Sullivan 14:59
Re: Database normalization Sebastian Ritter 15:10
Re: Database normalization Sebastian Ritter 15:15
Re: Database normalization Andrew Sullivan 15:19
Re: Database normalization Sebastian Ritter 15:35
Was: fetch first rows of grouped data Guy Fraser 16:05
Re: Was: fetch first rows of grouped data Sebastian Ritter 17:38
Re: pg & Delphi sergio carrasco 17:51
Re: pg & Delphi Josh Tolley 20:32

Aug. 29, 2007

Thread Author Time
Postgres 7.4 function Radhika Sambamurti 18:41
Re: Postgres 7.4 function Scott Marlowe 19:12

Aug. 30, 2007

Thread Author Time
date problems ivan marchesini 13:01
Re: date problems A. Kretschmer 13:29
Re: date problems Michael Glaesemann 14:39
Re: date problems Roberto Spier 18:31
Reporting functions (OLAP) Sean Davis 21:43

Aug. 31, 2007

Thread Author Time
Software CASE - PostgreSQL AlphaÔmega 02:06
Incomprehensible dogged sort in Merge Join 📎 Aleksandr Vinokurov 14:18
Re: Incomprehensible dogged sort in Merge Join Tom Lane 14:43
Re: Incomprehensible dogged sort in Merge Join Gregory Stark 14:45
Re: Incomprehensible dogged sort in Merge Join Aleksandr Vinokurov 14:53
Re: Incomprehensible dogged sort in Merge Join Aleksandr Vinokurov 14:56
Re: Incomprehensible dogged sort in Merge Join Alvaro Herrera 15:03
Re: Incomprehensible dogged sort in Merge Join Aleksandr Vinokurov 15:08
Re: Reporting functions (OLAP) Chris Browne 15:09
Re: Incomprehensible dogged sort in Merge Join Gregory Stark 15:24
Re: Incomprehensible dogged sort in Merge Join Chris Browne 17:49
How to influence the planner Richard Ray 18:32
Re: How to influence the planner Michael Glaesemann 19:18
Re: How to influence the planner Richard Ray 21:07
Re: How to influence the planner Tom Lane 21:37
Re: How to influence the planner Michael Glaesemann 21:38
Re: How to influence the planner Tom Lane 21:50

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

Browse Archives

Prev | Next