pgsql-sql since 2004-02-13 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 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Feb. 13, 2004

Thread Author Time
Re: 7.4 - FK constraint performance Tom Lane 00:00
Re: 7.4 - FK constraint performance ow 00:25
Re: 7.4 - FK constraint performance Tom Lane 00:42
Re: 7.4 - FK constraint performance ow 01:03
Re: 7.4 - FK constraint performance Tom Lane 01:10
Re: 7.4 - FK constraint performance ow 01:22
nextval problem Ivo Anon 01:54
Index question David Witham 02:30
Re: 7.4 - FK constraint performance Rod Taylor 02:53
Re: 7.4 - FK constraint performance Tom Lane 04:25
Re: 7.4 - FK constraint performance Tom Lane 04:49
Re: How to avoid nulls while writing string for dynamic query Kumar 04:53
Re: Index question Tom Lane 05:38
Re: How to avoid nulls while writing string for dynamic query Kumar 05:41
Re: Index question David Witham 05:58
Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta 06:33
Re: How to avoid nulls while writing string for dynamic query Kumar 07:13
Re: 7.4 - FK constraint performance Richard Huxton 07:22
Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta 08:07
Re: How to avoid nulls while writing string for dynamic query Kumar 09:14
Re: How to avoid nulls while writing string for dynamic query Tomasz Myrta 09:28
arrays and polygons David 10:25
column alias and group by/having/order Tomasz Myrta 13:34
Re: 7.4 - FK constraint performance Rod Taylor 13:57
Re: 7.4 - FK constraint performance Rod Taylor 13:57
Re: column alias and group by/having/order Rod Taylor 14:09
Re: arrays and polygons Tom Lane 15:02
Re: 7.4 - FK constraint performance Stephan Szabo 15:02
Re: column alias and group by/having/order Tom Lane 15:15
Passing composite values to functions Jatinder Sangha 15:24
Re: 7.4 - FK constraint performance Tom Lane 15:27
Re: 7.4 - FK constraint performance Stephan Szabo 15:49
Re: 7.4 - FK constraint performance Tom Lane 15:56
Re: 7.4 - FK constraint performance Stephan Szabo 16:08
Re: arrays and polygons Joe Conway 16:33
Re: arrays and polygons David 17:00
How to unsubscribe Mona 17:45

Feb. 15, 2004

Thread Author Time
Re: [SQL] 7.4 - FK constraint performance Stephan Szabo 16:41
Re: Passing composite values to functions Tom Lane 18:38
Re: bytea or blobs? Dana Hudes 18:44
Re: ORDER BY TIMESTAMP_column ASC, NULL first Rod Taylor 19:02
Re: Function Stephan Szabo 19:36
Re: max timestamp Bruno Wolff III 19:51
Re: writing a dynamic sql Tomasz Myrta 19:53
Re: max timestamp Robert Creager 20:00
Re: max timestamp Tomasz Myrta 20:01
Re: ORDER BY TIMESTAMP_column ASC, NULL first Stephan Szabo 20:01
Re: max timestamp Stephan Szabo 20:03
Re: ORDER BY TIMESTAMP_column ASC, NULL first Tomasz Myrta 20:11
Re: returning multiple resultset? Tom Lane 21:21
Re: Unable to convert date to tm Tom Lane 22:02

Feb. 16, 2004

Thread Author Time
Re: umlimited arguments on function Robert Treat 02:45
CHAR(n) always trims trailing spaces in 7.4 news.postgresql.org 03:29
Re: ORDER BY TIMESTAMP_column ASC, NULL first Denis 07:57
Re: Function Sumita Biswas (sbiswas) 08:12
Re: max timestamp Denis 08:57
Getting the week of a date Kumar 12:10
Re: Getting the week of a date Robert Creager 12:43
Re: Getting the week of a date Richard Huxton 13:03
Date format problems Mark Roberts 13:06
Re: Getting the week of a date sad 13:08
Re: Getting the week of a date sad 13:23
Re: Date format problems Tom Lane 15:34
Re: Date format problems Mark Roberts 15:56
Tip: a function for creating a remote view using dblink Mark Gibson 16:05
SQL query seach + rearranging results lowdog 16:07
Re: Date format problems Tom Lane 16:30
Re: Function Stephan Szabo 17:39
Re: nextval problem Greg Patnude 17:51

Feb. 17, 2004

Thread Author Time
Re: Getting the week of a date Kumar 05:10
Re: Getting the week of a date Kumar 05:46
Re: Tip: a function for creating a remote view using dblink Karsten Hilbert 09:08
Re: Trace for postgreSQL Andrew Sullivan 13:35
Re: Unique Constraint with foreign Key Jan Wieck 14:41
FW: Function Sumita Biswas (sbiswas) 14:41
Re: bytea or blobs? Jan Wieck 15:08
Ok, what am I doing wrong here? Karl Denninger 16:02
Re: Ok, what am I doing wrong here? Marc G. Fournier 16:20
Re: Ok, what am I doing wrong here? Stephan Szabo 16:29
Re: Ok, what am I doing wrong here? Tomasz Myrta 16:34
Re: Ok, what am I doing wrong here? Karl Denninger 16:58
Re: bytea or blobs? Jeremy Smith 17:00
Re: Unique Constraint with foreign Key Greg Patnude 17:22
need help with os x objects into a db Theodore Petrosky 17:41
Re: Tip: a function for creating a remote view using dblink Josh Berkus 18:05
Re: bytea or blobs? Jan Wieck 18:50
searching polygons David 19:01
Re: FW: Function Richard Huxton 19:26
Return relation table data in a single value CSV terry 20:05
Re: SQL query seach + rearranging results Richard Huxton 20:26
Re: Return relation table data in a single value CSV Richard Huxton 21:04
Re: Function scott.marlowe 22:46
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 23:10
Re: CHAR(n) always trims trailing spaces in 7.4 elein 23:17
Re: Return relation table data in a single value CSV Tom Lane 23:33
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 23:40
Re: CHAR(n) always trims trailing spaces in 7.4 elein 23:56

Feb. 18, 2004

Thread Author Time
Re: CHAR(n) always trims trailing spaces in 7.4 scott.marlowe 00:07
Re: CHAR(n) always trims trailing spaces in 7.4 terry 00:23
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 00:25
Re: CHAR(n) always trims trailing spaces in 7.4 elein 00:27
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 03:53
Indexes and statistics David Witham 04:43
Re: Indexes and statistics Tom Lane 05:10
Disabling constraints Kumar 05:13
Re: bytea or blobs? sad 06:14
Re: Indexes and statistics David Witham 06:23
Re: bytea or blobs? Dana Hudes 06:44
Re: bytea or blobs? Achilleus Mantzios 07:18
Re: Return relation table data in a single value CSV Richard Huxton 09:29
Re: CHAR(n) always trims trailing spaces in 7.4 Richard Huxton 09:40
Re: bytea or blobs? Richard Huxton 09:44
Re: bytea or blobs? Dana Hudes 15:17
Re: Indexes and statistics Tom Lane 15:21
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 15:56
Re: [SQL] 7.4 - FK constraint performance Stephan Szabo 16:03
Re: bytea or blobs? Richard Huxton 16:08
Re: [SQL] 7.4 - FK constraint performance Tom Lane 17:27
Re: CHAR(n) always trims trailing spaces in 7.4 Jeremy Smith 18:06
Inserting NULL into Integer column Jeremy Smith 19:25
Re: Inserting NULL into Integer column scott.marlowe 19:43
Re: CHAR(n) always trims trailing spaces in 7.4 elein 20:05
Re: Inserting NULL into Integer column Jeremy Smith 20:15
Re: Inserting NULL into Integer column scott.marlowe 20:19
Re: Inserting NULL into Integer column Jeremy Smith 20:43
Re: Inserting NULL into Integer column scott.marlowe 20:44
Re: Inserting NULL into Integer column Rod Taylor 20:53
Re: Inserting NULL into Integer column scott.marlowe 20:58
SQL / Join Help FastEddie 21:15
Re: Inserting NULL into Integer column Rod Taylor 21:29
Re: Inserting NULL into Integer column scott.marlowe 21:50

Feb. 19, 2004

Thread Author Time
Need some help with crafting a query to do major update Sean Shanny 00:51
Re: Need some help with crafting a query to do major update Stephan Szabo 03:11
Re: Indexes and statistics Iain 03:44
Distributed Transactions George A.J 03:46
Re: Distributed Transactions Josh Berkus 04:39
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 04:58
Compiling pl/pgsql functions Rodrigo Sakai 12:44
Re: Compiling pl/pgsql functions Viorel Dragomir 14:01
Re: Function Sumita Biswas 15:10
crosstabs Philippe Lang 16:02
Re: Compiling pl/pgsql functions Stephan Szabo 16:20
postgresql multiple insert slow Michael L. Hostbaek 16:32
Re: Distributed Transactions scott.marlowe 16:38
Re: Compiling pl/pgsql functions Rod Taylor 16:48
Re: Compiling pl/pgsql functions Rodrigo Sakai 17:05
Re: [SQL] crosstabs daq 17:23
Re: crosstabs Richard Huxton 17:26
Re: crosstabs Philippe Lang 17:28
DISTINCT ON troubles Jeremy Smith 18:10
Re: CHAR(n) always trims trailing spaces in 7.4 elein 18:55
Re: crosstabs Joe Conway 18:58
Re: Compiling pl/pgsql functions Joe Conway 19:00
Re: Compiling pl/pgsql functions Josh Berkus 19:26
Re: DISTINCT ON troubles Josh Berkus 19:28
Re: DISTINCT ON troubles Jeremy Smith 19:34
Re: CHAR(n) always trims trailing spaces in 7.4 Tom Lane 20:06
Re: Compiling pl/pgsql functions Jan Wieck 20:09
Re: Compiling pl/pgsql functions Richard Huxton 20:49
Re: Date / interval question Gnugeek 21:04
Re: DISTINCT ON troubles Brian Knox 21:06
Re: DISTINCT ON troubles scott.marlowe 21:39
Re: DISTINCT ON troubles scott.marlowe 21:51
Re: Distributed Transactions Tom Lane 22:38
Help refining/eliminating recursive selects Edmund Bacon 23:09
Re: Help refining/eliminating recursive selects Stephan Szabo 23:52

Feb. 20, 2004

Thread Author Time
Re: Help refining/eliminating recursive selects Yudie 00:16
Row counts/data changes. Any catalog table that has this info? David B 02:35
pg_restore - don´t restore. Why? 2000info 03:24
Re: Function Sumita Biswas 06:39
Re: [SQL] Row counts/data changes. Any catalog table that has this info? daq 07:44
Re: Function Sumita Biswas 08:43
transaction block causing trouble Fabian 09:56
Problem with FOR SELECT in plpgsql function Plant Thomas 10:07
Re: Problem with FOR SELECT in plpgsql function Richard Huxton 11:09
Re: pg_restore - don?t restore. Why? Andrew Sullivan 12:14
Re: bytea or blobs? Igor Shevchenko 12:42
create function atof? Mark Tabash 14:01
create function atof? mark 14:04
Re: create function atof? Achilleus Mantzios 14:24
Re: create function atof? Tom Lane 14:54
date format in 7.4 Silke Trissl 14:58
Binary retrieval - *Best practice* recommendations... beyaNet Consultancy 15:22
Re: date format in 7.4 scott.marlowe 15:27
Re: date format in 7.4 Tom Lane 15:32
Creating constraint sometime fail in a transaction Olivier Hubaut 15:49
Re: date format in 7.4 Richard Huxton 15:57
Re: Creating constraint sometime fail in a transaction Tom Lane 16:37
Re: Row counts/data changes. Any catalog table that has this info? Josh Berkus 18:53
Re: Date Foo. Brian Knox 20:25
Re: Date Foo. scott.marlowe 21:18

Feb. 21, 2004

Thread Author Time
User defined types -- Social Security number... Greg Patnude 02:31
Re: Function V i s h a l Kashyap @ [Sai Hertz And Control Systems] 08:12
Re: Function V i s h a l Kashyap @ [Sai Hertz And Control Systems] 08:12
Re: postgresql multiple insert slow Christopher Browne 15:03
Re: postgresql multiple insert slow Tom Lane 16:03
Re: Function Tom Lane 16:10

Feb. 22, 2004

Thread Author Time
Re: searching polygons elein 02:12
Re: [SQL] crosstabs joseph speigle 18:54
Re: User defined types -- Social Security number... Josh Berkus 19:32

Browse Archives

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