pgsql-sql since 2007-08-11 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 20 21 22 23 24 25 26 27 28 29 30 31

Aug. 11, 2007

Thread Author Time
Re: Best Fit SQL query statement Rodrigo De León 01:13
Re: Performance on writable views Heikki Linnakangas 07:42
Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 07:43
Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 07:45
Re: Trigger Procedure Error: NEW used in query that is not in a rule Pavel Stehule 08:16
Re: Best Fit SQL query statement hubert depesz lubaczewski 09:06
Re: Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 09:22
Re: Performance on writable views Joshua D. Drake 13:58
Re: Trigger Procedure Error: NEW used in query that is not in a rule Tom Lane 15:50
Re: Trigger Procedure Error: NEW used in query that is not in a rule Pavel Stehule 16:10
Re: Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 18:45
Re: Index usage in order by with multiple columns in order-by-clause hubert depesz lubaczewski 19:05
Re: Trigger Procedure Error: NEW used in query that is not in a rule hubert depesz lubaczewski 19:07
Re: Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 19:45
Re: Index usage in order by with multiple columns in order-by-clause Tom Lane 19:55
Re: Index usage in order by with multiple columns in order-by-clause Andreas Joseph Krogh 20:14

Aug. 12, 2007

Thread Author Time
Re: Trigger Procedure Error: NEW used in query that is not in a rule Lew 11:33

Aug. 13, 2007

Thread Author Time
Re: Install two different versions of postgres which should run in parallel Loredana Curugiu 08:19
Re: Install two different versions of postgres which should run in parallel Giuseppe Sacco 09:11
Re: Install two different versions of postgres which should run in parallel Gerardo Herzig 13:14
Re: [NOVICE] Install two different versions of postgres which should run in parallel Tom Lane 13:37
Comparing two slices within one table efficiently Ken Simpson 17:58
Re: Comparing two slices within one table efficiently chester c young 18:45
Re: Comparing two slices within one table efficiently Andrew Kroeger 19:25
how to moce back in refcursor Christian Kindler 19:29
Re: Comparing two slices within one table efficiently Christian Kindler 19:34
Re: Comparing two slices within one table efficiently Tom Lane 19:37
Re: Comparing two slices within one table efficiently Ken Simpson 19:42
Re: how to moce back in refcursor Tom Lane 19:55
Getting pk of the most recent row, in a group by Bryce Nesbitt 20:05
Re: Getting pk of the most recent row, in a group by Rodrigo De León 20:16
Re: Getting pk of the most recent row, in a group by Michael Glaesemann 20:19
Re: Performance on writable views Jim Nasby 22:17
Re: Getting pk of the most recent row, in a group by Terry Fielder 23:19

Aug. 14, 2007

Thread Author Time
Re: how to move back in refcursor Christian Kindler 06:17
Re: [NOVICE] Install two different versions of postgres which should run in parallel Loredana Curugiu 07:37
Re: Authentification failed Bryce Nesbitt 08:30
Re: Authentification failed Terry Fielder 11:40
Re: Best Fit SQL query statement Fernando Hevia 13:59
When is a shared library unloaded? Jon Horsman 18:42
Re: When is a shared library unloaded? Tom Lane 19:34

Aug. 15, 2007

Thread Author Time
Re: populate value of column Phillip Smith 03:15
Re: Install two different versions of postgres which should run in parallel Markus Schaber 11:58
Re: [JDBC] Install two different versions of postgres which should run in parallel Loredana Curugiu 12:42
Re: When is a shared library unloaded? Jon Horsman 13:16
Re: Trigger Procedure Error: NEW used in query that is not in a rule Decibel! 18:28
Boolean without default declared Jon Collette 18:46
Re: Boolean without default declared Richard Broersma Jr 19:23
Re: Boolean without default declared Richard Broersma Jr 19:36
Problem with phone list. Mike Diehl 20:28
Re: Problem with phone list. Rodrigo De León 20:49
Re: Problem with phone list. Fernando Hevia 20:58
Re: Problem with phone list. Richard Broersma Jr 21:00
Re: Problem with phone list. Michael Glaesemann 21:04
Re: Boolean without default declared Tom Lane 21:48

Aug. 16, 2007

Thread Author Time
Re: Trigger Procedure Error: NEW used in query that is not in a rule Javier Fonseca V. 00:05
Re: Problem with phone list. Mike Diehl 06:11
Re: [SQL] Embedded C++ with ecpg? Jean-David Beyer 13:05
Starting autovacuum in postgresql-8.1.9 Jean-David Beyer 13:20
Re: Starting autovacuum in postgresql-8.1.9 Alvaro Herrera 13:28
Re: Problem with phone list. Fernando Hevia 13:56
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Michael Glaesemann 15:35
SUPERUSER vs CREATEUSER causes foul 'code smell' Joshua_Kramer 15:36
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Rodrigo De León 15:41
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Peter Eisentraut 15:47
Re: SUPERUSER vs CREATEUSER causes foul 'code smell' Tom Lane 16:43

Aug. 17, 2007

Thread Author Time
Limited number of polygon function arguments Franz Mühlbauer 17:07
Sequences problem Judith 21:33
Re: Sequences problem Andrew Sullivan 21:49
Re: Sequences problem Scott Marlowe 21:50

Aug. 18, 2007

Thread Author Time
Re: Limited number of polygon function arguments Tom Lane 05:15
Join query help novice 05:35
Join query help Raj A 06:11
Re: Limited number of polygon function arguments Franz Mühlbauer 09:26
there is already a transaction in progress ? Jean-David Beyer 12:16
Re: there is already a transaction in progress ? Jean-David Beyer 16:36

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

Browse Archives

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