pgsql-sql since 2002-10-27 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

Oct. 27, 2002

Thread Author Time
Re: datediff? Josh Berkus 18:23
Re: datediff? Josh Berkus 19:49

Oct. 28, 2002

Thread Author Time
Accumulated sums in SQL query Kabai Jzsef 08:13
Re: Accumulated sums in SQL query Christoph Haller 08:20
Re: Accumulated sums in SQL query Kabai Jzsef 09:07
Re: Accumulated sums in SQL query Christoph Haller 12:27
Re: multiple databases Roberto Mello 14:21
Re: CoreReader Roberto Mello 14:21
Re: CoreReader John Ragan 14:38
Re: Accumulated sums in SQL query Kabai Jzsef 14:55
Re: Accumulated sums in SQL query Marek Bartnikowski 14:57
Re: VACUUM and locking Tom Lane 18:39
psql history [email protected] 19:57
Re: subscrip out of range Chad Thompson 21:22

Oct. 29, 2002

Thread Author Time
BOOLEAN question Josh Berkus 01:06
Re: BOOLEAN question Stephan Szabo 01:26
Re: BOOLEAN question Josh Berkus 01:29
Re: BOOLEAN question Stephan Szabo 03:53
Creating Stored Procedures Philip Van Hoof 18:23
Re: BOOLEAN question Tom Lane 18:27
Re: [SQL] Creating Stored Procedures Stephan Szabo 18:36
Re: BOOLEAN question Josh Berkus 20:32
Re: BOOLEAN question Peter Eisentraut 22:19
Selecting * from the base table but getting the inheriteds columns James Adams 22:37

Oct. 30, 2002

Thread Author Time
Re: BOOLEAN question Bruno Wolff III 02:22
Database Design tool Viacheslav N Tararin 06:45
Re: Selecting * from the base table but getting the inheriteds Tomasz Myrta 08:05
Re: Creating Stored Procedures Kabai Jzsef 08:07
Re: Creating Stored Procedures Jonas Wouters 09:08
Re: Database Design tool Bhuvan A 09:15
Re: Selecting * from the base table but getting the inheriteds James Adams 09:25
Re: Creating Stored Procedures Adam Witney 09:42
Re: [SQL] Database Design tool Tomasz Myrta 09:44
Re: Database Design tool Diogo Biazus 13:37
Re: [SQL] Database Design tool Johannes Lochmann 14:35
Re: [SQL] Database Design tool Dan Hrabarchuk 15:30
Re: BOOLEAN question Jean-Luc Lachance 16:26
Re: BOOLEAN question Jean-Luc Lachance 16:38
unnecessary updates chester c young 16:42
Re: unnecessary updates Andrew Perrin 18:02
How do I get rid of these messages? Wei Weng 18:28
Re: [SQL] Database Design tool Kevin Old 20:42
Re: Database Design tool Wei Weng 23:07
Re: Database Design tool Josh Berkus 23:43
Re: Database Design tool Wei Weng 23:52
Re: Database Design tool Josh Berkus 23:56

Oct. 31, 2002

Thread Author Time
Re: Database Design tool Reinoud van Leeuwen 00:12
time limit of a database connection jack 06:44
Re: time limit of a database connection Achilleus Mantzios 08:14
Re: How do I get rid of these messages? Bhuvan A 08:58
Re: psql history Robert Treat 14:50
Returning a recordset and filling datatable in a .NET applicatio n Jonas Wouters 15:33
Re: [SQL] Returning a recordset and filling datatable in a .NET Achilleus Mantzios 16:07
How do you write this query? Wei Weng 18:21
Re: How do you write this query? Richard Huxton 19:09
Re: How do you write this query? Jean-Luc Lachance 20:38

Nov. 1, 2002

Thread Author Time
Re: How do you write this query? Achilleus Mantzios 07:51
7.2.3: tuple is too big (max 8136) pilsl 13:33
Re: 7.2.3: tuple is too big (max 8136) Doug McNaught 13:50
Different size in the DATA directory Maurício Sessue Otta 14:09
Re: Different size in the DATA directory Maurício Sessue Otta 14:25
FIFO Queue Problems Chris Gamache 14:56
Re: Different size in the DATA directory dima 15:22
Re: Different size in the DATA directory Stephan Szabo 15:32
Re: Different size in the DATA directory Tim Perdue 16:02
Re: FIFO Queue Problems Richard Huxton 16:20
Re: Selecting * from the base table but getting the inheriteds Ross J. Reedstrom 16:37
Re: FIFO Queue Problems Tom Lane 16:51
Re: FIFO Queue Problems Bruno Wolff III 16:54
HA PostgreSQL Charles H. Woloszynski 18:26
Re: FIFO Queue Problems Wei Weng 19:18
Re: FIFO Queue Problems Tom Lane 19:47
Re: FIFO Queue Problems Bruno Wolff III 19:56
Does this matter? Wei Weng 20:18
Re: Does this matter? Josh Berkus 20:23
Re: Does this matter? Wei Weng 20:52
Re: Does this matter? Philip Hallstrom 20:53
Re: Does this matter? Andrew Sullivan 21:10
Re: unnecessary updates Ross J. Reedstrom 21:27
select syntax question Wei Weng 21:33
Re: select syntax question Bruno Wolff III 21:59
Re: Does this matter? Josh Berkus 22:00
Re: Does this matter? Curtis Faith 22:00
Re: Does this matter? Josh Berkus 22:01
Re: making queries more effecient Chad Thompson 22:04
Subtracting time fields Kevin Old 22:05
Re: making queries more effecient Josh Berkus 22:09
Re: HA PostgreSQL Robert Treat 22:12
making queries more effecient Peter T. Brown 22:24
Re: Subtracting time fields Bruno Wolff III 22:30
Re: making queries more effecient Josh Berkus 22:36

Nov. 2, 2002

Thread Author Time
Re: How do I get rid of these messages? Bruce Momjian 01:47
Re: Different size in the DATA directory Bruce Momjian 03:48
Re: select syntax question Bruce Momjian 04:07
Timezone issue with date_part Ken Kennedy 06:56
Re: Timezone issue with date_part Tom Lane 14:17
Re: Different size in the DATA directory Alexander M. Pravking 14:33
Re: Timezone issue with date_part Ken Kennedy 20:55
Re: Timezone issue with date_part Josh Berkus 21:21

Nov. 3, 2002

Thread Author Time
Re: Different size in the DATA directory 📎 Bruce Momjian 01:20
uniqueidentifier datatype for 7.3.X Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков 09:53
Re: Different size in the DATA directory Alexander M. Pravking 12:19
Re: uniqueidentifier datatype for 7.3.X Tom Lane 16:08

Nov. 4, 2002

Thread Author Time
Re: 7.2.3: tuple is too big (max 8136) pilsl 00:11
Re: 7.2.3: tuple is too big (max 8136) Doug McNaught 00:19
Re: 7.2.3: tuple is too big (max 8136) Stephan Szabo 00:38
Re: 7.2.3: tuple is too big (max 8136) Tom Lane 02:19
Re: Does this matter? Neil Conway 04:08
Re: [PERFORM] Does this matter? Wei Weng 04:33
Re: uniqueidentifier datatype for 7.3.X Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков 06:33
Comparing Numeric and Double Precision (float8).. Terry Yapt 08:11
Re: Comparing Numeric and Double Precision (float8).. Bruno Wolff III 13:45
Re: Comparing Numeric and Double Precision (float8).. Terry Yapt 14:35
Problem with Auto Increment Ben Kassel 18:29
Re: Problem with Auto Increment Stephan Szabo 20:45
Re: [SQL] Database Design tool Patrick Bakker 21:00
Re: [SQL] Database Design tool Larry Rosenman 21:01
counting text matches - any recipes? Ross J. Reedstrom 22:53
Re: counting text matches - any recipes? Josh Berkus 23:26
Referential integrity Freeze Rudi Starcevic 23:37

Nov. 5, 2002

Thread Author Time
Re: Referential integrity Freeze Stephan Szabo 00:05
Re: Referential integrity Freeze Rudi Starcevic 00:16
query optimization question terry 00:19
owner of type 'mmm' apperars to be invalid cristi 05:57
Re: owner of type 'mmm' apperars to be invalid Richard Huxton 10:57
Re: [GENERAL] Database Design tool Michael Ansley (UK) 11:46
Re: owner of type 'mmm' apperars to be invalid cristi 13:03
Re: owner of type 'mmm' apperars to be invalid Richard Huxton 13:21
Copying a rowtype variable. Rison, Stuart 13:33
Re: [GENERAL] Database Design tool Thomas Good 14:00
Re: [GENERAL] Database Design tool tony 14:24
Re: owner of type 'mmm' apperars to be invalid cristi 14:32
Re: owner of type 'mmm' apperars to be invalid Richard Huxton 14:51
Re: [GENERAL] Database Design tool Josh Berkus 16:33
Re: [GENERAL] Database Design tool Robert Treat 16:50
Re: [SQL] Copying a rowtype variable. Josh Berkus 16:55
Re: [GENERAL] Database Design tool Josh Berkus 18:19
Re: [GENERAL] Database Design tool Kaare Rasmussen 20:16
Re: [GENERAL] Database Design tool Robert Treat 21:17

Nov. 6, 2002

Thread Author Time
Problem: Referential Integrity Constraints lost Achilleus Mantzios 12:41
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 12:53
Re: query optimization question terry 13:56
FW: query optimization question terry 14:01
Re: [SQL] Problem: Referential Integrity Constraints lost: Correction Achilleus Mantzios 14:10
primary keys Huub 14:18
Re: FW: query optimization question Richard Huxton 15:11
Re: query optimization question Christoph Haller 15:58
Re: FW: query optimization question Stephan Szabo 16:22
Re: [SQL] Problem: Referential Integrity Constraints lost Stephan Szabo 16:25
Re: FW: query optimization question terry 16:36
Re: FW: query optimization question Stephan Szabo 16:44
Re: query optimization question Masaru Sugawara 16:44
Re: query optimization question terry 17:10
Re: query optimization question Masaru Sugawara 17:11
Re: Copying a rowtype variable. Rison, Stuart 21:30
Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Josh Berkus 22:27

Nov. 7, 2002

Thread Author Time
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 07:33
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 07:57
Re: query optimization question Christoph Haller 08:57
how to get the source table & field name of a view field Prime Ho 09:12
Re: [pgsql-sql] Daily Digest V1 #983 vist 09:27
Weird NULL behavior Ludwig Lim 11:41
Generating a cross tab (pivot table) Christoph Haller 11:47
Re: Generating a cross tab (pivot table) Richard Huxton 12:15
cast lo to oid Nekta Katz 12:22
Re: primary keys terry 13:54
Re: primary keys Rachel.Vaudron 14:01
Re: how to get the source table & field name of a view field Christoph Haller 14:06
Re: how to get the source table & field name of a view field Achilleus Mantzios 14:25
Re: primary keys Achilleus Mantzios 14:28
Re: primary keys Huub 14:29
PLpgSQL FOR IN EXECUTE question Christoph Haller 14:35
Re: primary keys Bruno Wolff III 14:35
Re: primary keys Tomasz Myrta 14:49
Re: [SQL] Problem: Referential Integrity Constraints lost Tom Lane 14:55
Re: how to get the source table & field name of a view field Ken Kennedy 15:08
Re: primary keys Sangeetha Rao 15:12
Re: cast lo to oid Tom Lane 15:16
Re: PLpgSQL FOR IN EXECUTE question Richard Huxton 16:13
Re: Copying a rowtype variable. Jean-Luc Lachance 16:28
Re: [SQL] Problem: Referential Integrity Constraints lost Achilleus Mantzios 16:38
Re: Weird NULL behavior Stephan Szabo 16:41
Re: Copying a rowtype variable. Rison, Stuart 16:51
Re: Generating a cross tab (pivot table) Joe Conway 17:25
Re: PLpgSQL FOR IN EXECUTE question Tom Lane 18:01
Quartile (etc) ranking in a SQL statement? Jeff Boes 18:16
Re: Weird NULL behavior Tom Lane 19:09
pg_dump, no inserts but \copy? Joost Witteveen 19:20
Re: Weird NULL behavior Stephan Szabo 19:35
Re: Weird NULL behavior Tom Lane 20:00
Re: Quartile (etc) ranking in a SQL statement? Jean-Luc Lachance 20:50
Re: PLpgSQL FOR IN EXECUTE question Josh Berkus 21:30
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Neil Conway 21:56
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL Josh Berkus 22:57
Re: query optimization question terry 23:18

Nov. 8, 2002

Thread Author Time
Re: cast lo to oid Nekta Katz 00:11
Re: cast lo to oid Nekta Katz 00:24
Re: Cannot assign ROWTYPE, RECORD variables in PL/pgSQL elein 03:11
get source table.field name from view's field Prime Ho 05:17
Delete cascade for multi tables? Zhidian Du 05:36

Browse Archives

Prev | Next