pgsql-sql since 2007-08-20 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. 20, 2007

Thread Author Time
TRIGGERS and FUNCTIONS ashok raj 04:56
Re: TRIGGERS and FUNCTIONS Richard Broersma Jr 11:21
Re: When is a shared library unloaded? Jon Horsman 15:47

Aug. 21, 2007

Thread Author Time
Re: Join query help novice 00:52
Re: Join query help Michael Glaesemann 01:04
Re: Join query help novice 01:21
Re: Join query help Michael Glaesemann 01:27
Re: Join query help novice 01:33
Re: [SQL] Join query help Michael Glaesemann 01:35
Re: Join query help Michael Glaesemann 01:36
wrong answer A. R. Van Hook 13:09
Re: wrong answer Richard Huxton 13:23
Join question tyrrill_ed 17:48
Re: Join question Richard Broersma Jr 19:16
Re: Join question Richard Broersma Jr 19:18
SELECT syntax synopsis: column_definition? Richard Broersma Jr 19:34
Re: Join question Michael Glaesemann 21:16
Make a SQL statement not run trigger Jon Collette 21:26
Re: Make a SQL statement not run trigger Rodrigo De León 21:51
Re: Make a SQL statement not run trigger Jon Collette 22:04
Re: Make a SQL statement not run trigger Scott Marlowe 22:07
Re: Make a SQL statement not run trigger Thomas Kellerer 22:24
Re: Make a SQL statement not run trigger Jon Collette 22:44
Re: Make a SQL statement not run trigger Jon Collette 22:49
Re: Make a SQL statement not run trigger Scott Marlowe 23:01
Re: SELECT syntax synopsis: column_definition? Michael Glaesemann 23:04
Re: SELECT syntax synopsis: column_definition? Michael Glaesemann 23:17
Re: SELECT syntax synopsis: column_definition? Gregory Stark 23:53

Aug. 22, 2007

Thread Author Time
Re: SELECT syntax synopsis: column_definition? Scott Marlowe 01:42
Re: SELECT syntax synopsis: column_definition? Alvaro Herrera 01:55
Re: SELECT syntax synopsis: column_definition? Richard Broersma Jr 03:10
raw data into table process novice 04:36
Pgcluster 1.7 Fail safe !!! 📎 Trinath Somanchi 04:59
Re: SELECT syntax synopsis: column_definition? Tom Lane 05:33
Solution to retrieve first and last row for each minute roopa perumalraja 07:25
Re: Solution to retrieve first and last row for each minute Christian Kindler 08:49
Re: raw data into table process Russell Smith 11:23
Database creation script Dani Castaños 11:33
Re: raw data into table process Steve Midgley 11:36
Re: Solution to retrieve first and last row for each minute roopa perumalraja 12:13
Partial index and query plan Aleksandr Vinokurov 12:57
Re: Solution to retrieve first and last row for each minute Christian Kindler 13:35
Re: Partial index and query plan Tom Lane 14:10
Re: Partial index and query plan Aleksandr Vinokurov 14:32
Re: Partial index and query plan Scott Marlowe 14:43
Re: Partial index and query plan Aleksandr Vinokurov 15:02
minimum bounding circle for a triangle/polygon George Pavlov 15:39

Aug. 23, 2007

Thread Author Time
table column vs. out param [1:0] Kristo Kaiv 05:51
Re: table column vs. out param [1:0] Kristo Kaiv 08:11
Re: table column vs. out param [1:0] Kristo Kaiv 08:16

Aug. 24, 2007

Thread Author Time
SQL query to display like this RPK 10:42
Re: SQL query to display like this Richard Huxton 11:36

Aug. 25, 2007

Thread Author Time
Returning array of IDs as a sub-query with group-by Andreas Joseph Krogh 15:10
Re: Returning array of IDs as a sub-query with group-by Andreas Joseph Krogh 15:55
Re: Returning array of IDs as a sub-query with group-by Ragnar 21:02
Re: Returning array of IDs as a sub-query with group-by Andreas Joseph Krogh 22:42

Aug. 26, 2007

Thread Author Time
Block size with pg_dump? Jean-David Beyer 21:35
List of FKeys ? Andreas 23:35

Aug. 27, 2007

Thread Author Time
Re: Block size with pg_dump? Bruce Momjian 00:11
Re: Block size with pg_dump? Jean-David Beyer 01:09
Re: Block size with pg_dump? Erik Jones 02:41
Re: Block size with pg_dump? Bruce Momjian 02:49
Re: List of FKeys ? Tom Lane 03:48
Re: [GENERAL] table column vs. out param [1:0] Kristo Kaiv 07:52
Re: List of FKeys ? Ashish Karalkar 11:18
SQL function ashok raj 12:05
Re: Block size with pg_dump? Jean-David Beyer 12:28
Re: Block size with pg_dump? Bruce Momjian 12:33
Re: [GENERAL] table column vs. out param [1:0] Tom Lane 15:07
Re: Block size with pg_dump? Jean-David Beyer 15:56
fetch first rows of grouped data Claudia Kosny 16:36
Re: fetch first rows of grouped data D'Arcy J.M. Cain 16:51
Re: fetch first rows of grouped data Joel Richard 17:34
Re: fetch first rows of grouped data Michael Glaesemann 18:12
Re: fetch first rows of grouped data D'Arcy J.M. Cain 18:15
Re: fetch first rows of grouped data Michael Glaesemann 18:20
Re: [GENERAL] table column vs. out param [1:0] Kristo Kaiv 19:02

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

Browse Archives

Prev | Next