pgsql-sql - September 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 4 5 8 9 10 11 12 14 15 16 17 18 19 21 22 23 24 25 26 27 30

Sept. 1, 2008

Thread Author Time
MAY I HAVE YOUR ASSISTANCE James Kitambara 07:03
Re: MAY I HAVE YOUR ASSISTANCE Scott Marlowe 07:28
Re: MAY I HAVE YOUR ASSISTANCE D'Arcy J.M. Cain 14:08
Re: MAY I HAVE YOUR ASSISTANCE Gary Chambers 14:31
Re: MAY I HAVE YOUR ASSISTANCE Fernando Hevia 15:42
Re: MAY I HAVE YOUR ASSISTANCE Gary Chambers 18:36

Sept. 2, 2008

Thread Author Time
order of rows in update Achilleas Mantzios 09:58
Re: order of rows in update Richard Broersma 14:24
How do I get min and max from an array of floating point values pw 21:14
seemingly slow for-loop in plpgsql Claus Guttesen 22:27
Re: seemingly slow for-loop in plpgsql Tom Lane 22:47

Sept. 3, 2008

Thread Author Time
Re: order of rows in update Achilleas Mantzios 06:56
Re: seemingly slow for-loop in plpgsql Claus Guttesen 07:20
Re: How do I get min and max from an array of floating point values Pavel Stehule 07:43
Re: order of rows in update Richard Broersma 12:28
Re: How do I get min and max from an array of floating point values Yura Gal 12:42
Case-insensitive string prefix matching with parameterized query Christopher Maier 13:38
Re: order of rows in update Achilleas Mantzios 15:21

Sept. 4, 2008

Thread Author Time
Syntax help please Ruben Gouveia 19:36
Re: Syntax help please Fernando Hevia 19:49
Re: Syntax help please Ruben Gouveia 19:55
Dynamic SQL Syntax help please Ruben Gouveia 20:41
Re: Dynamic SQL Syntax help please Ivan Sergio Borgonovo 21:00
Re: Dynamic SQL Syntax help please Ruben Gouveia 21:07
Correct Insert SQL syntax? Ruben Gouveia 22:16
Re: Correct Insert SQL syntax? Yura Gal 22:49
Re: Correct Insert SQL syntax? Ruben Gouveia 22:56

Sept. 5, 2008

Thread Author Time
Re: Correct Insert SQL syntax? Bart Degryse 06:57
Re: Correct Insert SQL syntax? Lennin Caro 16:11
Re: Correct Insert SQL syntax? Scott Marlowe 16:16
variables with SELECT statement Kevin Duffy 19:50
Re: variables with SELECT statement Frank Bax 20:07
Re: variables with SELECT statement Kevin Duffy 20:31
Re: variables with SELECT statement Frank Bax 20:44
Re: variables with SELECT statement Kevin Duffy 21:03
Re: variables with SELECT statement Frank Bax 21:13
Re: variables with SELECT statement Tom Lane 21:26
Re: variables with SELECT statement Kevin Duffy 21:28
Re: variables with SELECT statement Kevin Duffy 21:33
Re: variables with SELECT statement Scott Marlowe 21:34
Re: variables with SELECT statement Kevin Duffy 21:50
Re: variables with SELECT statement Frank Bax 21:55

Sept. 8, 2008

Thread Author Time
psql: FATAL: Ident authentication failed for user "postgres" VG 10:09
Re: psql: FATAL: Ident authentication failed for user "postgres" Filip Rembiałkowski 10:22
Re: psql: FATAL: Ident authentication failed for user "postgres" Milen A. Radev 11:07
problem with pg_stat_activity view Sofer, Yuval 11:29
Re: problem with pg_stat_activity view Tom Lane 12:54
Re: psql: FATAL: Ident authentication failed for user "postgres" Devrim GÜNDÜZ 12:59
PL/pgSQL function syntax question? Ruben Gouveia 21:40
Re: PL/pgSQL function syntax question? Adrian Klaver 21:47
Re: PL/pgSQL function syntax question? imad 23:28

Sept. 9, 2008

Thread Author Time
Re: PL/pgSQL function syntax question? Lennin Caro 14:36
Function syntax ? Ruben Gouveia 17:55
Re: Function syntax ? Pavel Stehule 18:05
Re: Function syntax ? Scott Marlowe 18:07
Re: Function syntax ? Ruben Gouveia 18:11
Re: Function syntax ? Richard Huxton 18:15
Re: Function syntax ? Scott Marlowe 18:15
Re: Function syntax ? Ruben Gouveia 18:16
Re: Function syntax ? Ruben Gouveia 19:24
How to provide password to pg_dump command ? Emi Lu 20:07
Re: How to provide password to pg_dump command ? Milen A. Radev 20:16
Function Syntax involving pipes and ' marks? Ruben Gouveia 23:20

Sept. 10, 2008

Thread Author Time
Re: Function Syntax involving pipes and ' marks? Alvaro Herrera 00:58
FW: Help- post gress sql error Kota, Prasoona 13:57
Re: FW: Help- post gress sql error Tom Lane 16:04
Re: Function Syntax involving pipes and ' marks? Bricklen Anderson 18:24
Re: Function Syntax involving pipes and ' marks? Bricklen Anderson 18:36
Re: Function Syntax involving pipes and ' marks? Ruben Gouveia 18:38
Re: Function Syntax involving pipes and ' marks? Tom Lane 18:45
Re: Function Syntax involving pipes and ' marks? Ruben Gouveia 19:08
pg_restore in java connection (auto_commit = false) Emi Lu 21:13
Aggregates in WHERE clause? Ruben Gouveia 23:11
Re: Aggregates in WHERE clause? Stephan Szabo 23:19
Re: Aggregates in WHERE clause? Richard Broersma 23:59

Sept. 11, 2008

Thread Author Time
Re: pg_restore in java connection (auto_commit = false) Craig Ringer 02:14
Re: Aggregates in WHERE clause? Tom Lane 12:03
Re: Aggregates in WHERE clause? Igor Neyman 12:43
Re: pg_restore in java connection (auto_commit = false) Emi Lu 13:48
DIfference between max() and greatest() ? Ruben Gouveia 17:33

Sept. 12, 2008

Thread Author Time
Re: DIfference between max() and greatest() ? Bart Degryse 07:10
Re: DIfference between max() and greatest() ? Peter Eisentraut 07:24
Pls Hlp: SQL Problem 📎 Hengky Lie 09:22
Re: Pls Hlp: SQL Problem Richard Huxton 10:23
Re: DIfference between max() and greatest() ? Ruben Gouveia 16:47
Doubts about FK Rafael Domiciano 18:14
Re: Pls Hlp: SQL Problem 📎 Hengky Lie 18:50
Re: Pls Hlp: SQL Problem Scott Marlowe 20:04
Re: Doubts about FK Scott Marlowe 20:07
Re: Pls Hlp: SQL Problem Fernando Hevia 22:01
Re: Pls Hlp: SQL Problem Scott Marlowe 23:50

Sept. 14, 2008

Thread Author Time
selecting current UTC time davidn 10:10
Re: selecting current UTC time Frank Bax 12:55
a simple transform Karl Grossner 23:59

Sept. 15, 2008

Thread Author Time
select from two tables Claus Guttesen 10:04
Re: select from two tables Andreas Kretschmer 12:01
Re: Pls Hlp: SQL Problem Fernando Hevia 20:14
Re: Pls Hlp: SQL Problem Scott Marlowe 20:18
surrogate vs natural primary keys Seb 22:02
Re: surrogate vs natural primary keys Scott Marlowe 22:45
Re: surrogate vs natural primary keys Seb 22:56

Sept. 16, 2008

Thread Author Time
Simple Problem ? Hengky Lie 05:01
Re: Simple Problem ? Guillaume Lelarge 06:32
Re: Simple Problem ? Guillaume Lelarge 07:32
Re: Simple Problem ? Hengky Lie 09:23
Re: Simple Problem ? Guillaume Lelarge 09:39
Re: a simple transform Frank Bax 13:37
Re: surrogate vs natural primary keys Richard Broersma 14:59
Re: surrogate vs natural primary keys Andrew Sullivan 15:17
Re: a simple transform Richard Broersma 15:30

Sept. 17, 2008

Thread Author Time
Re: surrogate vs natural primary keys Seb 00:10
Re: surrogate vs natural primary keys Scott Marlowe 02:34
Insert a space between each character Nicholas I 06:19
Re: Insert a space between each character A. Kretschmer 06:39
Re: Insert a space between each character Michael Toews 06:50
May I have an assistance on CREATE TABLE Command James Kitambara 06:50
Re: May I have an assistance on CREATE TABLE Command Bart Degryse 08:36
Re: May I have an assistance on CREATE TABLE Command James Kitambara 09:13
Re: May I have an assistance on CREATE TABLE Command Richard Huxton 09:18
Re: May I have an assistance on CREATE TABLE Command Bart Degryse 11:01
Re: surrogate vs natural primary keys Seb 13:20
Re: surrogate vs natural primary keys Scott Marlowe 14:45
Re: Trigger Procedure Error: NEW used in query that is not in a rule Raphael Bauduin 15:08
Re: surrogate vs natural primary keys Richard Broersma 16:20
Re: Trigger Procedure Error: NEW used in query that is not in a rule Raphael Bauduin 17:09
prepared query plan did not update Emi Lu 18:54
Re: prepared query plan did not update Igor Neyman 19:28
Re: prepared query plan did not update Emi Lu 19:41
Re: prepared query plan did not update Stephan Szabo 20:09
Re: prepared query plan did not update Emi Lu 20:12
Re: prepared query plan did not update Stephan Szabo 20:38
Re: May I have an assistance on CREATE TABLE Command Robert Edwards 23:28

Sept. 18, 2008

Thread Author Time
Re: surrogate vs natural primary keys Steve Midgley 04:10
inserting boolean values in dynamic queries Raphael Bauduin 09:49
Re: Doubts about FK Rafael Domiciano 11:49
Re: inserting boolean values in dynamic queries Tom Lane 12:35
Re: inserting boolean values in dynamic queries Raphael Bauduin 13:53
Re: inserting boolean values in dynamic queries Tom Lane 14:06
Re: Doubts about FK Scott Marlowe 19:47

Sept. 19, 2008

Thread Author Time
ORDER BY collation order Joe 00:48
Re: ORDER BY collation order Scott Marlowe 02:26
Re: ORDER BY collation order Joe 04:35
Re: surrogate vs natural primary keys Steve Midgley 06:56
Re: ORDER BY collation order Petr Jelinek 08:03
pg_dump in windows Ramasubramanian 10:18
Re: pg_dump in windows Richard Huxton 10:37
Re: ORDER BY collation order Petr Jelinek 13:59
Re: ORDER BY collation order Scott Marlowe 14:26

Sept. 21, 2008

Thread Author Time
Re: ORDER BY collation order Joe 14:58

Sept. 22, 2008

Thread Author Time
varchar::timezone conversion Marc Mamin 10:55
exclusion query Louis-David Mitterrand 14:34
Re: exclusion query Louis-David Mitterrand 14:45
Re: exclusion query Mark Roberts 16:39
Multi-line text fields Mike Toews 21:56
Special grouping on sorted data. Nicolas Beuzeboc 22:49

Sept. 23, 2008

Thread Author Time
Re: Special grouping on sorted data. Tom Lane 03:40
Re: Multi-line text fields Craig Ringer 03:54
Re: Special grouping on sorted data. Craig Ringer 04:27
Re: exclusion query Louis-David Mitterrand 08:18
Resp.: Multi-line text fields Osvaldo Kussama 15:57
Re: Special grouping on sorted data. Nicolas Beuzeboc 17:59
Re: Special grouping on sorted data. Nicolas Beuzeboc 18:12

Sept. 24, 2008

Thread Author Time
Re: Special grouping on sorted data. Tom Lane 02:25

Sept. 25, 2008

Thread Author Time
Re: exclusion query Oliveiros Cristina 13:11
Re: exclusion query Louis-David Mitterrand 20:06

Sept. 26, 2008

Thread Author Time
Problem with pg_connect() in PHP James Kitambara 05:21
Re: Problem with pg_connect() in PHP Robert Edwards 05:27
Re: pg_dump in windows James Kitambara 10:51
Re: Problem with pg_connect() in PHP Edward W. Rouse 17:23
Finding sequential records Steve Midgley 17:39
Re: Finding sequential records Richard Broersma 18:02
Re: Finding sequential records Oliveiros Cristina 18:09
Re: Problem with pg_connect() in PHP ries van Twisk 18:27
Re: Problem with pg_connect() in PHP Lennin Caro 18:47
Re: Finding sequential records Richard Broersma 19:12
Re: Finding sequential records Steve Midgley 22:25

Sept. 27, 2008

Thread Author Time
Re: Finding sequential records Oliveiros Cristina 00:38
Re: Finding sequential records Richard Broersma 01:08

Sept. 30, 2008

Thread Author Time
Re: Finding sequential records Steve Midgley 02:48
Re: Finding sequential records Richard Broersma 04:50
Re: Finding sequential records Steve Midgley 06:05
optimizing a query over tree-like structure az 08:32
Can COPY update or skip existing records? Glenn Gillen 12:16
Re: optimizing a query over tree-like structure Oliveiros Cristina 12:21
Re: Finding sequential records Richard Broersma 14:02
Re: optimizing a query over tree-like structure az 14:24
Re: optimizing a query over tree-like structure Oliveiros Cristina 17:01

Browse Archives

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