pgsql-sql since 1999-03-09 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

March 9, 1999

Thread	Author	Time
time comparing	Remigiusz Sokolowski	12:48
Re: [SQL] time comparing	Patrik Kudo	12:54
Re: [SQL] time comparing	Remigiusz Sokolowski	13:09
How to optimize a query...	secret	18:32
help	Fernezelyi Marton	18:39
Re: [SQL] How to optimize a query...	Ross J. Reedstrom	18:56

March 10, 1999

Thread	Author	Time
Performance	Tim Perdue	01:33
Re: [SQL] Performance	Clark Evans	02:29
Re: [SQL] Performance	Karl Denninger	02:50
Re: [SQL] Performance	Brett W. McCoy	02:52
Re: [SQL] Performance	D'Arcy J.M. Cain	03:11
Re: [SQL] Performance	Tim Perdue	03:13
Re: [SQL] Performance	Jason Slagle	03:24
Re: [SQL] Performance	Karl Denninger	03:30
Re: [SQL] Performance	Tim Perdue	03:33
Re: [SQL] Performance	Brett W. McCoy	03:44
shared tables	Remigiusz Sokolowski	13:13
Re: How to optimize a query...	Tom Lane	15:27
Re: [SQL] Performance	Tom Lane	15:37
Re: [SQL] How to optimize a query...	secret	15:38
DISTINCT within aggregates.	Stuart Rison	17:01
Re: [SQL] Performance	Jason Slagle	18:27
Re: [SQL] Performance	Karl Denninger	18:35
Re: [SQL] Performance	Jason Slagle	18:39
Re: [SQL] Performance	G. Anthony Reina	18:44
Re: [SQL] Performance	Karl Denninger	18:46
Re: [SQL] Performance	Jason Slagle	18:51
HJ#####.#	pierre	19:03
Re: [SQL] Performance	Bruce Momjian	19:11
RE: [HACKERS] Bug on complex subselect (was: Bug on complex join)	Jackson, DeJuan	20:18
How match percent sign in SELECT using LIKE?	Dan Lauterbach	21:00
Re: [HACKERS] Bug on complex subselect (was: Bug on complex join)	Thomas Reinke	21:09
Recording Date,Time and UserId when a record is modified	Sue Hanen	21:49
How match percent sign in SELECT using LIKE?	Dan Lauterbach	21:58
Re: [SQL] Re: How to optimize a query... -- Extreme performance difference, same EXPLAIN	secret	21:59

March 11, 1999

Thread	Author	Time
Stored Procedure FAQ	Joe Shevland	04:56
unsubscribe	Vikrant Rathore	05:59
Re: [SQL] How match percent sign in SELECT using LIKE?	Ulf Mehlig	08:45
RE: [HACKERS] Bug on complex subselect (was: Bug on complex join)	Oleg Broytmann	12:48
Re: SQL92 standard conformance [was Re: [SQL] OUTER JOINS in 6.4.2?? Work around??	Herouth Maoz	14:22
Very disappointing performance -- All Indexes Ignored.	secret	17:02
Re: [SQL] Very disappointing performance -- All Indexes Ignored.	Bruce Momjian	17:36
Re: [SQL] Very disappointing performance -- All Indexes Ignored.	secret	19:30
Re: [SQL] Very disappointing performance -- All Indexes Ignored.	Bruce Momjian	20:17
Re: [SQL] Staus of Primary/Foreign key?	Bruce Momjian	20:33

March 12, 1999

Thread	Author	Time
Re: [SQL] sum gives different answer	George Moga	09:38
sum gives different answer	Chairudin Sentosa	11:28
sum gives different answer	Chairudin Sentosa	12:24
where can I get...	ZioBudda	13:03
sum gives different answer	Chairudin Sentosa	14:14
Re: Very disappointing performance -- All Indexes Ignored.	Tom Lane	15:57
Re: [SQL] Re: Very disappointing performance -- All Indexes Ignored.	secret	18:55
So what happens at 2GB?	Tim Perdue	23:35
Re: [SQL] So what happens at 2GB?	Karl Denninger	23:56

March 13, 1999

Thread	Author	Time
Backend closes caused by query on a view?!	Viktor A.	09:54
Re: [SQL] Backend closes caused by query on a view?!	Bruce Momjian	16:06
OT: Modeling Tools	Clark Evans	16:19
unsubscribe	Ana Badillo	18:04
Re: [SQL] So what happens at 2GB?	Brett W. McCoy	18:11
Re: [SQL] So what happens at 2GB?	Karl Denninger	20:17
Re: [SQL] So what happens at 2GB?	Brett W. McCoy	20:30

March 14, 1999

Thread	Author	Time
URGENT - "CANNOT EXTEND"	Tim Perdue	04:46
Re: [HACKERS] URGENT - "CANNOT EXTEND"	Bruce Momjian	05:07
Re: [HACKERS] URGENT - "CANNOT EXTEND"	Tim Perdue	05:57
install problem	Eric J McKeown	06:54
Re: [SQL] "typedef" in Pstgresql?	Clark Evans	09:07
Re: [HACKERS] URGENT - "CANNOT EXTEND"	Peter T Mount	10:03
Re: [HACKERS] URGENT - "CANNOT EXTEND" 📎	Peter T Mount	11:00
Re: [SQL] So what happens at 2GB?	Tom Lane	17:48
Re: sum gives different answer	Tom Lane	18:04
Re: [SQL] Re: sum gives different answer	Clark Evans	18:10

March 15, 1999

Thread	Author	Time
Mail about FOREIGN KEY	Vikrant Rathore	09:19
Re: [HACKERS] Re: [SQL] Functional Indexes	Bruce Momjian	14:53
Re: [SQL] install problem	Tom Lane	15:09
Re: [SQL] How match percent sign in SELECT using LIKE?	Bruce Momjian	15:45
Re: [SQL] install problem	Eric J McKeown	15:47

March 16, 1999

Thread	Author	Time
Re: [SQL] Re: [HACKERS] URGENT -	Tim Perdue	00:39
Re: [SQL] Re: [HACKERS] URGENT -	Bruce Momjian	01:51
Re: pgsql-sql-digest V1 #169	Jaap Willems	07:14
Re: [SQL] How match percent sign in SELECT using LIKE?	Herouth Maoz	11:52
Setting Next Value in Sequence	Tim Perdue	12:37
Re: [SQL] Setting Next Value in Sequence	Remigiusz Sokolowski	12:57
Re: [SQL] Setting Next Value in Sequence	Herouth Maoz	13:03
Re: [SQL] Setting Next Value in Sequence	Tim Perdue	13:06
Re: [SQL] Setting Next Value in Sequence	Patrik Kudo	13:22
Re: [SQL] Setting Next Value in Sequence	Herouth Maoz	13:23
Re: [SQL] Setting Next Value in Sequence	Remigiusz Sokolowski	13:25
Re: [SQL] Setting Next Value in Sequence	Tim Perdue	14:17
Re: [SQL] How match percent sign in SELECT using LIKE?	Bruce Momjian	20:24
Re: [SQL] How match percent sign in SELECT using LIKE?	Zalman Stern	20:51
Re: [SQL] How match percent sign in SELECT using LIKE?	Bruce Momjian	22:26
Re: [SQL] How match percent sign in SELECT using LIKE?	Zalman Stern	22:55
Re: [SQL] How match percent sign in SELECT using LIKE?	Bruce Momjian	23:03

March 17, 1999

Thread	Author	Time
Re: [SQL] How match percent sign in SELECT using LIKE?	Herouth Maoz	09:58
Problems with OUTER JOIN - UNION .....	Angelo CONFLITTI	13:34
Problems with OUTER JOIN - UNION ......	Angelo CONFLITTI	13:45
Problems with OUTER JOIN - UNION ... and so on ..	Angelo CONFLITTI	15:33
Re: [SQL] How match percent sign in SELECT using LIKE?	Bruce Momjian	16:30
unsubscribe	Bill Barber	23:02

March 18, 1999

Thread	Author	Time
[email protected]	Frederic Nourry	09:30
Vacuum	Tim Stoddard	14:41
Re: [SQL] Vacuum	Sascha Schumann	19:58
Re: [SQL] Vacuum	Bruce Momjian	20:14
Stuck on SQL - Any Takers?	Tim Perdue	23:44

March 19, 1999

Thread	Author	Time
Re: [SQL] Stuck on SQL - Any Takers?	Matthew Diesch	00:58
Re: [SQL] Stuck on SQL - Any Takers?	Tim Perdue	02:32
Re: [SQL] Stuck on SQL - Any Takers?	twm139	03:16
Re: [SQL] Stuck on SQL - Any Takers?	Tim Perdue	04:13
Re: Stuck on SQL - Any Takers?	Tom Lane	15:22
Re: [SQL] Re: Stuck on SQL - Any Takers?	David Martinez Cuevas	16:22
compound key	MESZAROS Attila	20:58
[No subject]	Ismail Kizir	21:28

March 20, 1999

Thread	Author	Time
Re: [SQL] compound key	Brett W. McCoy	00:07
string containing (')	Atika	11:38
Re: [SQL] string containing (')	Bruce Momjian	12:48
[SQL] Restore deleted records	Eugenia Bulakh	14:44
Re: [SQL] string containing (')	Brian Baquiran	16:06
[No subject]	Robert McArthur	22:40
[No subject]	Robert McArthur	22:42

March 22, 1999

Thread	Author	Time
Re: [SQL] string containing (')	Peter Garner	00:58
Re: [SQL] string containing (')	Herouth Maoz	12:35

March 23, 1999

Thread	Author	Time
Simple Optimization Problem	secret	15:32
transaction-lock?	Forgacs Tamas	18:06
DEFAULT TEXT 'now'	Roberto Joao Lopes Garcia	18:58

March 24, 1999

Thread	Author	Time
Re: [SQL] DEFAULT TEXT 'now'	Howie	07:09
Re: [SQL] DEFAULT TEXT 'now'	Anatoly K. Lasareff	07:10
Re: [SQL] transaction-lock?	Herouth Maoz	12:42
Re: [SQL] Use of 'default TEXT now()'	Rich Shepard	13:55
Re: [SQL] DEFAULT TEXT 'now'	Ross J. Reedstrom	16:26
Comparing Dates to Current Time	Jenny DiBartolomeo	18:49
Comparing Dates to Current Time	Jenny DiBartolomeo	19:08
Use of 'default TEXT now()'	Ing. Roberto Andrade	20:19
RE: [SQL] Comparing Dates to Current Time	Jackson, DeJuan	21:12
RE: [SQL] Use of 'default TEXT now()'	Jackson, DeJuan	21:14
RE: [SQL] Comparing Dates to Current Time	Michael Davis	21:18
RE: [SQL] Use of 'default TEXT now()'	Ing. Roberto Andrade	21:31
types and subtypes	Ingrith Andrea Correa Vargas	21:59
RE: [SQL] Use of 'default TEXT now()'	Jackson, DeJuan	21:59
RE: [SQL] types and subtypes	Jackson, DeJuan	22:27

March 25, 1999

Thread	Author	Time
Help with query	Oleg Bartunov	03:13
Undeliverable Message	MAILER-DAEMON	04:57
sql 92 support in postgres	Eric Enockson	06:38
subscribe	Eddie	16:23
[SQL] Subselect has too many or too few fields	Oleg Bartunov	16:52
Re: [SQL] sql 92 support in postgres	Ross J. Reedstrom	19:27
RE: [SQL] Subselect has too many or too few fields	Jackson, DeJuan	21:39

March 26, 1999

Thread	Author	Time
Odd "problem", not sure if there is a solution ....	The Hermit Hacker	03:46
Re: [GENERAL] Re: [SQL] sql 92 support in postgres	Oleg Broytmann	09:54
RE: [SQL] Odd "problem", not sure if there is a solution ....	Jackson, DeJuan	16:29
Re: [SQL] Odd "problem", not sure if there is a solution ....	secret	20:08
newbie question about type conversions	Andrew Douglas	21:13
newbie question about type conversions	Andrew Douglas	21:42

March 27, 1999

Thread	Author	Time
Determining if "in a text set"	Richi Plana	04:41

March 28, 1999

Thread	Author	Time
Re: [SQL] Odd "problem", not sure if there is a solution ....	Herouth Maoz	15:48
Re: [GENERAL] Determining if "in a text set"	Herouth Maoz	17:24
Re: [SQL] Re: [GENERAL] Determining if "in a text set"	Herouth Maoz	17:44
Re: [SQL] Re: [GENERAL] Determining if "in a text set"	Richi Plana	18:10
Re: [GENERAL] Determining if "in a text set"	Richi Plana	18:56
Re: [SQL] Re: [GENERAL] Determining if "in a text set"	Richi Plana	19:11

March 29, 1999

Thread	Author	Time
inheritance and selection	Francois TETE	08:29
inheritance and update	Francois TETE	08:34
Inheritance and selection	Francois TETE	08:41
Inheritance and update	Francois TETE	08:42
Re: [GENERAL] Determining if "in a text set"	Herouth Maoz	10:34
IIF..	Eduardo Noeda	10:49
Returning an integer from a date	Rick Dearman	10:51
pgsql and function results	erikp	11:02
Re: [GENERAL] Returning an integer from a date	Adriaan Joubert	11:22
Newbie question about datatype conversion	Andrew Douglas	13:47
Re: [GENERAL] Returning an integer from a date	Herouth Maoz	16:00
RE: [SQL] IIF..	Jackson, DeJuan	19:20
union on views	Gregory Holston	20:19
RE: [SQL] union on views	Jackson, DeJuan	20:30
Re: [SQL] IIF..	Clark Evans	21:34
Re: [SQL] union on views]	Bruce Momjian	22:59

March 30, 1999

Thread	Author	Time
Re: [SQL] IIF..	Clark Evans	00:01
RE: [SQL] IIF..	Jackson, DeJuan	00:31
SELECT (CASE ... ) gives copyObject error in current CVS build.	Clark Evans	02:43
indexing a datetime by date	Andrew Merrill	03:27
RE: [SQL] indexing a datetime by date	Jackson, DeJuan	04:07
Re: [SQL] indexing a datetime by date	Thomas Lockhart	06:14
Re: [GENERAL] Returning an integer from a date	Herouth Maoz	11:51
RE: [SQL] indexing a datetime by date	Herouth Maoz	11:59
sorting by date & time in descending order ??	Ralf Weidemann	13:38
Re: [GENERAL] sorting by date & time in descending order ??	Herouth Maoz	14:00
How to do this in SQL?	Chris Bitmead	14:45
Re: [GENERAL] sorting by date & time in descending order ??	Kollar Lajos	14:49
Re: [GENERAL] How to do this in SQL?	Herouth Maoz	14:59
Re: [GENERAL] How to do this in SQL?	Chris Bitmead	15:03
Re: [GENERAL] How to do this in SQL?	Herouth Maoz	15:13
Re: [GENERAL] How to do this in SQL?	Stuart Rison	15:50
Date operation efficiency	Oliver Smith	16:00
Re: [SQL] indexing a datetime by date	Tom Lane	16:31
RE: [SQL] indexing a datetime by date	Jackson, DeJuan	17:21
Re: [SQL] indexing a datetime by date	Andrew Merrill	17:25
RE: [SQL] indexing a datetime by date	Jackson, DeJuan	17:33
regexp strangeness	Andrew Merrill	17:44
Re: [SQL] indexing a datetime by date	Andrew Merrill	18:11
Selecting and deleting duplicate rows	Clark Evans	20:33

March 31, 1999

Thread	Author	Time
merging date and time	Marco.Iannacone	08:44

Browse Archives

Prev | Next