pgsql-sql since 2004-02-16 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. 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
Re: Compiling pl/pgsql functions Josh Berkus 19:34

Feb. 23, 2004

Thread Author Time
Re: User defined types -- Social Security number... Greg Patnude 00:45
Re: Postgres DB Sumita Biswas 02:54
Re: Postgres DB Tom Lane 03:29
Re: Error Number in Function Sumita Biswas 03:33
Re: User defined types -- Social Security number... Christopher Browne 04:07
Input Arguments Sumita Biswas 06:21
DATEADD Sumita Biswas 08:17
EXECUTing QUERY: Sumita Biswas 08:33
unicode(utf-8) problem ! john 08:44
Re: Postgres DB Sumita Biswas 08:54
plpgsql function returning SETOF RECORD Question jbduffy 13:21

Feb. 24, 2004

Thread Author Time
BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() PostgreSQL Bugs List 01:26
Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() Bruno Wolff III 02:11
Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() Tom Lane 05:37
Re: BUG #1083: Insert query reordering interacts badly with Martin Langhoff (Catalyst IT) 06:46
Re: BUG #1083: Insert query reordering interacts badly with NEXTVAL()/CURRVAL() Tom Lane 06:51
Enterprice support in PostgreSQL George A.J 10:02
Re: BUG #1083: Insert query reordering interacts badly with Martin Langhoff 10:47
CURSORS - Please help urgent. Sumita Biswas (sbiswas) 11:51
Execute Query in Postgres Function Sumita Biswas (sbiswas) 15:35
Materialized View Summary Jonathan M. Gardner 16:11
Re: [SQL] Materialized View Summary Richard Huxton 17:11
Re: [HACKERS] [SQL] Materialized View Summary Hans-Jürgen Schönig 17:40
tsearch2 trigger alternative Chris Gamache 18:58
Re: [HACKERS] [SQL] Materialized View Summary Robert Treat 21:48
Re: [HACKERS] [SQL] Materialized View Summary Jonathan Gardner 22:19

Feb. 25, 2004

Thread Author Time
PLSQL Question regarding multiple inserts Humble Geek 03:56
Re: [HACKERS] [SQL] Materialized View Summary Jonathan M. Gardner 08:19
Re: [HACKERS] Materialized View Summary Mark Gibson 11:35
Last day of month Kumar 12:35
Re: [HACKERS] [SQL] Materialized View Summary Robert Treat 15:46
Scalar in a range (but textual not numeric) Richard Huxton 19:18
Re: Scalar in a range (but textual not numeric) Richard Huxton 20:36
Re: Scalar in a range (but textual not numeric) Joe Conway 20:56
Re: Scalar in a range (but textual not numeric) Tom Lane 21:32
Re: Scalar in a range (but textual not numeric) Richard Huxton 22:08
Re: Scalar in a range (but textual not numeric) Richard Huxton 22:10
Re: Scalar in a range (but textual not numeric) Tom Lane 22:32
Re: Scalar in a range (but textual not numeric) Tom Lane 22:37

Feb. 26, 2004

Thread Author Time
updating remote database Kenneth Gonsalves 02:54
Re: Last day of month Greg Sabino Mullane 03:07
Re: Last day of month Joe Conway 04:27
Re: Last day of month Joe Conway 04:30
Unicode Support Sumita Biswas (sbiswas) 05:51
Re: Scalar in a range (but textual not numeric) Richard Huxton 08:03
Re: updating remote database Richard Huxton 08:15
Re: updating remote database Olivier Hubaut 09:51
Field list from table Jan Pips 09:51
Re: updating remote database Achilleus Mantzios 09:55
Triggers Philip J. Boonzaaier 10:18

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