pgsql-sql since 1999-10-20 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. 20, 1999

Thread Author Time
unknown error Dirk Drechsel 10:10
Re: [SQL] Converting Data Howie 10:13
Re: [SQL] unknown error Herouth Maoz 10:35
Re: [SQL] unknown error Tom Lane 14:25
Re: [SQL] unknown error Dirk Drechsel 15:06

Oct. 21, 1999

Thread Author Time
Example of embbed SQL ? Eric Chow 02:55
Re: [SQL] bad select performance fixed by forbidding hash joins Nik Putnam 07:22
Re: [SQL] bad select performance fixed by forbidding hash joins Tom Lane 13:30
auto_increment? Rodrigo Bernardo Pimentel 15:44
Re: [SQL] auto_increment? David Rugge 16:12
Re: [SQL] auto_increment? Oleg Broytmann 16:12
RE: [SQL] auto_increment? Pham, Thinh 16:31
Search parameter optimization Bruce De Vries 17:42
Re: [SQL] Search parameter optimization Tom Lane 19:47

Oct. 22, 1999

Thread Author Time
Install PostgreSQL on Sparc Solaris 2.5.1 Haris Susanto 05:43
Re: [SQL] Install PostgreSQL on Sparc Solaris 2.5.1 Chairudin Sentosa Harjo 06:49
inheritance of functions Andrzej Mazurkiewicz 09:27
Adding a rule to update a last_changed field grant 15:03
Re: [SQL] Adding a rule to update a last_changed field Brook Milligan 15:36
Re: [SQL] Adding a rule to update a last_changed field Tom Lane 15:45
Re: [SQL] Adding a rule to update a last_changed field Grant Kaufmann 16:05
Re: [SQL] Adding a rule to update a last_changed field Grant Kaufmann 16:09
Re: [SQL] Adding a rule to update a last_changed field Brook Milligan 16:41
Re: [SQL] Adding a rule to update a last_changed field Tom Lane 18:49
Week of year function? Zot O'Connor 19:52
sum-function Christian Guenther 23:34

Oct. 23, 1999

Thread Author Time
Re: [SQL] sum-function Tom Lane 04:55
Can VACUUM, but cannot do VACUUM ANALYZE Albert REINER 07:18
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Oleg Broytmann 12:04
[No subject] Florian Baumert 12:07
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Oliver Elphick 13:59
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Tom Lane 16:18
Re: [SQL] sum-function Tom Lane 16:42
BUG in PgODBC found/fixed (win32) Sam O'Connor 22:10

Oct. 24, 1999

Thread Author Time
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Albert REINER 15:18
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Albert REINER 15:48
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Tom Lane 17:31
Stats on new tables Michael Richards 18:55
Re: [SQL] Stats on new tables Tom Lane 20:09

Oct. 25, 1999

Thread Author Time
Re: [INTERFACES] BUG in PgODBC found/fixed (win32) Byron Nikolaidis 01:03
possible bug? Clayton Cottingham 01:22
Re: [SQL] possible bug? Mathijs Brands 02:48
Re: [SQL] possible bug? Tom Lane 03:47
pg_dump for PGPLSQL Dipankar Chakrabarti 05:31
Limit doesn't work with select unions Postgres 08:27
Re: [SQL] possible bug? Peter Eisentraut 08:52
Re: [SQL] Limit doesn't work with select unions Oleg Bartunov 09:02
Vacuum takes more than 1 hr Postgres 10:52
modifying query results with a regex? KC 14:28
Re: [SQL] Vacuum takes more than 1 hr Tom Lane 14:45
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Albert REINER 15:09
Re: [SQL] Vacuum takes more than 1 hr Rich Ryan 15:36
Re: [SQL] Vacuum takes more than 1 hr Tom Lane 15:55
Index operator for money type Rich Ryan 16:01
unsubscribe BOUARD, Fabrice 16:21
Create index pretty slow Rich Ryan 16:39
Re: [SQL] Week of year function? Herouth Maoz 17:14
Re: [SQL] Week of year function? Moray McConnachie 19:04
different between || and && in a statement Christian Guenther 19:43
Re: [SQL] Week of year function? Zot O'Connor 19:47
Access and field sizes Andrew Perrin - Demography 23:49

Oct. 26, 1999

Thread Author Time
Re: [SQL] Stats on new tables Bruce Momjian 04:20
Re: [SQL] possible bug? Bruce Momjian 04:53
Re: [SQL] possible bug? Bruce Momjian 04:55
Re: [SQL] possible bug? Bruce Momjian 04:58
Re: [SQL] Week of year function? Zakkr 07:53
RE: [SQL] Access and field sizes John Ridout 08:24
Re: [SQL] Week of year function? Herouth Maoz 10:33
Re: pgsql-sql-digest V1 #393 Juarez Rudsatz 11:16
Re: [SQL] pg_dump for PGPLSQL Herouth Maoz 13:47
Re: [SQL] different between || and && in a statement Herouth Maoz 14:28
Re: [SQL] Week of year function? 📎 Kyle Bateman 15:19

Oct. 27, 1999

Thread Author Time
Re: [SQL] Date comparisons omid omoomi 05:29
Date comparisons Rich Ryan 06:46
Re: [SQL] Date comparisons Tom Lane 14:28

Oct. 28, 1999

Thread Author Time
Setting default row value after select into table Rich Ryan 06:34
Re: [SQL] Date comparisons Haris Susanto 09:46
SQL Problem Imtiaz. S. M 10:47
Re: [SQL] SQL Problem Peter Eisentraut 10:58
Change of a field in a table 📎 Dirk Drechsel 11:01

Oct. 29, 1999

Thread Author Time
Problem with datetime Holm Tiffe 08:14
trivial problem Frank Joerdens 12:55
Re: Re: [SQL] SQL Problem Imtiaz. S. M 13:18
Re :Setting default row value after select into table Imtiaz. S. M 13:36
Re: [SQL] Problem with datetime Tom Lane 13:44
Re: [SQL] trivial problem Oleg Bartunov 14:27
Re: [SQL] trivial problem Mathijs Brands 14:32
Re: [SQL] trivial problem Roderick A. Anderson 17:07
Re: [SQL] trivial problem [email protected] 18:12
tuning large selects Werner Reisberger 19:36
Re: [SQL] trivial problem Moray McConnachie 20:02
Re: [SQL] trivial problem Bruce Momjian 20:19
random query Oleg Bartunov 20:31
Combining Two Tables Andrew Patterson 20:44
Re: [SQL] random query Oleg Bartunov 20:47
Decimal precsion? Zot O'Connor 22:26
Numeric Bug? Zot O'Connor 23:23
Re: [SQL] trivial problem Tom Lane 23:37

Oct. 30, 1999

Thread Author Time
Re: [SQL] Decimal precsion? Bruce Momjian 00:01
Re: [SQL] trivial problem Bruce Momjian 00:19
Re: [SQL] Decimal precsion? Bruce Momjian 00:30
Re: [SQL] tuning large selects Tom Lane 04:11
Re: [SQL] Decimal precsion? Jan Wieck 15:43
Re: [SQL] Decimal precsion? Bruce Momjian 15:55
Re: [SQL] Decimal precsion? Jan Wieck 16:37

Oct. 31, 1999

Thread Author Time
DISTINCT ON, when you want it, you're glad it's there Robert Forsman 01:38
subscribe Mario Simeone 09:51
Re: [SQL] Decimal precsion? Bruce Momjian 13:18
auto datetime update on UPDATE? Tulassay Zsolt 15:45
auto datetime update on UPDATE? Tulassay Zsolt 15:54
Re: [SQL] auto datetime update on UPDATE? Christophe Labouisse 19:52

Nov. 1, 1999

Thread Author Time
Rule plan string too big is overcome, but... Baris Ulu 07:04
Re: [SQL] auto datetime update on UPDATE? Darrin Crook 14:46
query with subquery abnormally slow? Oskar Liljeblad 18:47
Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad 19:05
Re: [SQL] query with subquery abnormally slow? Moray McConnachie 19:59
Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad 20:10
Re: [SQL] query with subquery abnormally slow? Bill Brandt 20:35
Re: [SQL] query with subquery abnormally slow? Oskar Liljeblad 20:36
Re: [SQL] query with subquery abnormally slow? Tom Lane 22:10

Nov. 2, 1999

Thread Author Time
Re: Antw: [SQL] query with subquery abnormally slow? omid omoomi 00:42
SQL Info Chris Griffin 00:51
Antw: [SQL] query with subquery abnormally slow? Gerhard Dieringer 06:45
ERROR: btree: lost page Roomi 07:21
Re: [SQL] query with subquery abnormally slow? Zalman Stern 08:42
Redhat 6.0 Link Error: Undefined Reference to crypt Klein, Robert 15:34
Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt Tom Lane 19:09
why don't this create table work? User & 22:59

Nov. 3, 1999

Thread Author Time
timestamps David Rugge 02:51
Re: [SQL] why don't this create table work? Mathijs Brands 04:00
Re: [SQL] why don't this create table work? User & 05:04
Re: [SQL] why don't this create table work? Tom Lane 05:35
Re: [SQL] timestamps Tom Lane 05:48
Re: [SQL] why don't this create table work? User & 07:31
unsubscribe Joel Fischer 13:24
Optimizing a query through its syntax and indices Stoyan Genov 15:45
Re: [SQL] Optimizing a query through its syntax and indices Jan Wieck 17:16

Nov. 4, 1999

Thread Author Time
Re: [SQL] Copying databases omid omoomi 01:28
Copying databases Hamid Khoshnevis 05:54
Accessing other database... Frederic boucher 07:36
Re: [SQL] Optimizing a query through its syntax and indices Stoyan Genov 12:59
Tracking depth question Zot O'Connor 17:39
Remove Drinks, Ivan - ITD 22:19

Nov. 5, 1999

Thread Author Time
arrays of numeric? Vince Gonzalez 01:55
Re: [SQL] Redhat 6.0 Link Error: Undefined Reference to crypt De Moudt Walter 03:59
Re: [SQL] Accessing other database... Frederic boucher 05:16
Re: [SQL] Tracking depth question Zalman Stern 06:48
Re: [SQL] Accessing other database... Frederic boucher 07:09
create table with default value... Frederic boucher 08:38
Re: [SQL] Accessing other database... Stoyan Genov 08:46
type conversions Baris Ulu 10:10
Re: [SQL] create table with default value... Frederic boucher 10:25
Re: [SQL] create table with default value... Frederic boucher 10:33
insert with "Fred's car!" Frederic boucher 11:51
Oracle database import Miroslaw Budzanowski 13:52
Re: [SQL] Accessing other database... Jim Seach 14:13
Re: [SQL] create table with default value... Stuart Rison 18:07
Re: [SQL] insert with "Fred's car!" Bruce Momjian 20:41
calulating with money type impossible ? De Moudt Walter 21:58
showing the DEFAULT of a field Klaus Woelfel 22:15

Nov. 6, 1999

Thread Author Time
subscribe pgsql-sql José A. Navarro =?iso-8859-1?Q?Ram=F3n?= 02:03
Re: [SQL] Accessing other database... Frederic boucher 09:45
pg_dump and "archive = none" ?? Heiko Wilms 10:28
How to get last 10 rows in a table on a large database? Alex 10:37
Re: [SQL] How to get last 10 rows in a table on a large database? Stoyan Genov 11:36
Re: [SQL] pg_dump and "archive = none" ?? Stoyan Genov 11:44
Re: [SQL] showing the DEFAULT of a field Stoyan Genov 12:01
Re: [SQL] Accessing other database... Stoyan Genov 12:13
Re: [SQL] arrays of numeric? Peter Eisentraut 14:26
Re: [SQL] calulating with money type impossible ? Peter Eisentraut 14:48
Re: [SQL] pg_dump and "archive = none" ??8 Bruce Momjian 16:45
Re: [SQL] How to get last 10 rows in a table on a large database? Tom Lane 18:12
Re: [SQL] How to get last 10 rows in a table on a large database? Tom Lane 18:16
Re: [SQL] How to get last 10 rows in a table on a large database? 📎 Oleg Bartunov 19:09

Nov. 7, 1999

Thread Author Time
Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov 10:25
Re: [SQL] Accessing other database... Stoyan Genov 10:50
unsubscribe Adrian Alb 12:23
Re: [SQL] arrays of numeric? Vince Gonzalez 19:59

Nov. 8, 1999

Thread Author Time
RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue 00:32
Specifying currency using a numeric data type Rich Shepard 01:29
Re: [SQL] type conversions De Moudt Walter 04:16
Creating a index with a timestamp? Oliver Fischer 06:58
Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Stoyan Genov 09:27
parser :parse error Frederic boucher 11:37
Creating a index with a timestamp? Oliver Fischer 13:27
Declare Cursor... Baris Ulu 14:32
about the subselect query Oskar Liljeblad 17:19
Re: [SQL] Declare Cursor... Jan Wieck 17:57
newbie outer-join Matlack, Brad 20:06
Re: [SQL] parser :parse error Bruce Momjian 20:39
Re: [SQL] newbie outer-join Peter Eisentraut 21:26
Re: [SQL] parser :parse error Peter Eisentraut 21:32
Re: [SQL] parser :parse error Jacob Christen 21:37
DISTINCT raptor 21:52
Problem with a PL/pgSQL function Eric Prevost-Dansereau 22:38
Re: [SQL] parser :parse error Moray McConnachie 22:42

Nov. 9, 1999

Thread Author Time
Re: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) 📎 Hiroshi Inoue 00:26
RE: [SQL] Move forward all (Was Re: How to get last 10 rows in a table on a large database?) Hiroshi Inoue 04:36
Re: [SQL] parser :parse error Frederic boucher 05:28
Is this a bug? Imtiaz. S. M 05:43

Browse Archives

Prev | Next