pgsql-sql - July 1999

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 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

July 1, 1999

Thread Author Time
Re: [SQL] Beginner's headache of joins Chris Bitmead 02:13
Re: [SQL] begin/end/abort work for sequences? Bruce Momjian 03:26
Re: [SQL] String concat operator??? Bruce Momjian 03:41
Re: [SQL] begin/end/abort work for sequences? Kyle Bateman 14:24
Index on Type Numeric Steven Pennie 14:43
Re: [SQL] begin/end/abort work for sequences? Bruce Momjian 15:30
Re: [SQL] begin/end/abort work for sequences? D'Arcy J.M. Cain 16:26
RE: [SQL] Port? Clark Joel A1C AMC CSS 16:51
DISTINCT on multiple fields Matthew Hagerty 17:00
a little conversion problem. . . JT Kirkpatrick 18:18
Re: [SQL] DISTINCT on multiple fields (fwd) Fomichev Michael 20:37
problem creating table blackgr 21:17
Re: [SQL] begin/end/abort work for sequences? Kyle Bateman 23:29

July 2, 1999

Thread Author Time
Re: [SQL] Beginner's headache of joins webmaster 11:25
Tricky SQL (?) Peter Eisentraut 21:04

July 3, 1999

Thread Author Time
Re: [SQL] Tricky SQL (?) Chris Bitmead 02:39
Ascii null in varchars Thomas Mack 08:36
plpgsql function problems Thomas Mack 10:10
Re: [SQL] problem creating table Tom Lane 16:22

July 4, 1999

Thread Author Time
Re: [SQL] problem creating table Oliver Graf 09:58
Re: [SQL] Escaping w/i regular expressions Herouth Maoz 11:09
Re: [SQL] Tricky SQL (?) Herouth Maoz 11:59

July 5, 1999

Thread Author Time
Problems with jdbc & pgsql 6.5 timbert 12:54
Large Objects Eid, Bilal 23:57

July 6, 1999

Thread Author Time
Re: [SQL] Large Objects Chris Bitmead 00:17
PB creating view : DefineQueryRewrite: rule plan string too big Olivier Ertz 12:23
How to have the types definition table ? Olivier Ertz 14:32
Re: [SQL] How to have the types definition table ? secret 14:51
Large Objects Eid, Bilal 18:42
Type Conversion: int4 -> Money secret 18:49
Re: [SQL] problem creating table blackgr 21:08
Re: [GENERAL] sorting by date & time in descending order ?? Bob Dusek 23:55

July 7, 1999

Thread Author Time
Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian 02:42
Re: [SQL] How match percent sign in SELECT using LIKE? Bruce Momjian 02:43
Tips and tricks John Ridout 08:38
Re: [SQL] Type Conversion: int4 -> Money Herouth Maoz 11:57
RETURN VALUES ON INTEGERS Alessandro Rossi 12:20
RETURN VALUES ON INTEGERS Alessandro Rossi 12:24
Re: [SQL] RETURN VALUES ON INTEGERS Herouth Maoz 12:52
RE: [SQL] RETURN VALUES ON INTEGERS John Ridout 14:36
Good Optimization secret 14:56
Re: [SQL] Good Optimization Roderick A. Anderson 15:22
Re: [SQL] Good Optimization Tom Lane 15:42
Re: [SQL] Good Optimization Tom Lane 15:44
Re: [SQL] Good Optimization Roderick A. Anderson 16:10
Re: [SQL] Good Optimization Bruce Momjian 16:45
Re: [SQL] Good Optimization Jan Wieck 17:22
Re: [SQL] Good Optimization Bruce Momjian 18:00
Re: [SQL] Good Optimization Tom Lane 18:10
Index on TIMESTAMP Steven Bradley 18:11
Re: [HACKERS] spinlock freeze again Bruce Momjian 18:20
Re: [SQL] Oddities with NULL and GROUP BY Bruce Momjian 18:23
Re: [SQL] Good Optimization Bruce Momjian 19:09
Re: [SQL] Tips and tricks Chris Bitmead 23:49
RE: [HACKERS] spinlock freeze again Hiroshi Inoue 23:50

July 8, 1999

Thread Author Time
Re: [HACKERS] spinlock freeze again Bruce Momjian 01:09
RE: [HACKERS] spinlock freeze again Hiroshi Inoue 02:07
Re: [SQL] Escaping w/i regular expressions Bruce Momjian 02:18
Re: [HACKERS] spinlock freeze again Bruce Momjian 03:01
Re: [SQL] Index on Type Numeric Bruce Momjian 03:04
Re: [SQL] Good Optimization Patrik Kudo 08:09
concatenation varchar and float Eric BASIER 08:27
Re: [SQL] Good Optimization Jan Wieck 09:04
Re: [SQL] Good Optimization Patrik Kudo 09:23
Re: [SQL] Good Optimization Jan Wieck 10:24
unsubscribe Seb 11:07
Re: [SQL] Good Optimization Tom Lane 15:01
Re: [SQL] Good Optimization Bruce Momjian 15:40
Re: [SQL] Good Optimization Bruce Momjian 15:48
RewriteDefine.c : Rule size Olivier Ertz 16:15
Re: [SQL] RewriteDefine.c : Rule size Jan Wieck 16:30
Referential Integrity Gilson Costa 18:41
Re: [SQL] uncorrelated subqueries Tom Lane 19:30
offtopic: odbc C frontend for linux? Engard Ferenc 20:36
Re: [SQL] Referential Integrity Steven Bradley 20:38
Re: [SQL] offtopic: odbc C frontend for linux? Jan Wieck 21:52
[No subject] Anna Langer 23:42

July 9, 1999

Thread Author Time
subscribe Soon-Suk Kim 02:51
subscribe Soon-Suk Kim 03:02
Re: [SQL] RewriteDefine.c : Rule size Jim Rowan 04:25
Undeliverable Message MAILER-DAEMON 04:34
Re: [SQL] offtopic: odbc C frontend for linux? Stephen Boyle 05:53
uncorrelated subqueries Bruce Lowery 07:08
Bad date representation Roland_DUBOULOZ 09:25
RE: [SQL] Good Optimization Ansley, Michael 09:59
Good Optimization Ansley, Michael 10:15
RE: [SQL] Good Optimization John Ridout 10:56
Re: [SQL] RewriteDefine.c : Rule size Tom Lane 14:24
Re: Good Optimization Bruce Momjian 16:45
Re: [SQL] Good Optimization Bruce Momjian 16:47
Re: [SQL] RewriteDefine.c : Rule size Bruce Momjian 16:54
Re: [SQL] RewriteDefine.c : Rule size Bruce Momjian 16:56
RE: [SQL] offtopic: odbc C frontend for linux? Eid, Bilal 17:27
class as a table column? George Young 19:31
class as a table column? George Young 20:37
RE: [SQL] Re: Good Optimization Jackson, DeJuan 20:47
class as a table column George Young 20:56

July 10, 1999

Thread Author Time
Re: [SQL] Oddities with NULL and GROUP BY Tom Lane 20:03
SELECT DISTINCT question Oleg Bartunov 20:16
Re: [HACKERS] SELECT DISTINCT question Tom Lane 21:18
a problem of the postgresql .. welssen crow 23:00

July 11, 1999

Thread Author Time
Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Oleg Bartunov 06:09
Re: [SQL] uncorrelated subqueries Herouth Maoz 14:37
Re: [SQL] Bad date representation Herouth Maoz 14:57
Re: [SQL] Re: [HACKERS] SELECT DISTINCT question Tom Lane 15:38
accumulated statistics Oleg Bartunov 17:46
Aggregates qd 20:43

July 12, 1999

Thread Author Time
Re: [HACKERS] accumulated statistics Philip Warner 02:36
Stupid question about default time value Nikolay Mijaylov 08:21
SQL: Getting table structure John Bowden 13:35
calculating percentages Thomas Good 13:50
Re: [SQL] calculating percentages Thomas Good 14:50
Re: [SQL] calculating percentages Tiberiu Craciun 14:53
Re: [SQL] Stupid question about default time value Tom Lane 15:06
Re: [SQL] calculating percentages Tom Lane 15:06
Re: [SQL] calculating percentages Tom Lane 16:57
Re: [SQL] calculating percentages Thomas Good 16:57
Left joins Peter Eisentraut 18:25

July 13, 1999

Thread Author Time
variables in pgSQL? Heinz Hemken 02:18
create temp table Steven Bradley 02:31
variables in pgSQL? Heinz Hemken 02:41
Re: [SQL] variables in pgSQL? Chris Bitmead 03:12
Re: [SQL] create temp table Bruce Momjian 05:05
Using Indexes Mr. Poet 05:10
Re: [SQL] Using Indexes Chris Bitmead 05:53
Problem with timestamp and primary key. Esteban Chiner Sanz 07:14
Postgres ERROR Esteban Chiner Sanz 11:30
"quoting" column names Patrik Kudo 12:15
[No subject] JT Kirkpatrick 12:39
Re: [SQL] calculating percentages D'Arcy J.M. Cain 12:52
Re: [SQL] calculating percentages Thomas Good 13:30
Re: [SQL] Postgres ERROR Tom Lane 14:01
Re: [SQL] "quoting" column names Tom Lane 14:08
Re: [SQL] "quoting" column names Patrik Kudo 14:19
Re: [SQL] "quoting" column names Herouth Maoz 14:30
Re: [SQL] Problem with timestamp and primary key. Steven Bradley 15:24
[No subject] Hub.Org News Admin 15:39
[No subject] Hub.Org News Admin 15:39
Re: [SQL] Problem with timestamp and primary key. Herouth Maoz 16:06
Re: [SQL] Problem with timestamp and primary key. Bruce Momjian 16:57
Re: [SQL] Postgres ERROR Bruce Momjian 17:00
Re: [HACKERS] SELECT DISTINCT question Hannu Krosing 20:50
Re: [HACKERS] SELECT DISTINCT question Tom Lane 21:31
counting bools in a complex query Michael Richards 23:31

July 14, 1999

Thread Author Time
OFF-TOPIC: Postgresql for NT? Johann Spies 04:58
WHERE clause? Jim Rowan 05:17
Few questions about my slow query webmaster 08:52
Re: Few questions about my slow query webmaster 09:12
Re: [SQL] counting bools in a complex query Herouth Maoz 09:43
SQL query to check size of database webmaster 12:52
Re: [SQL] SQL query to check size of database Tom Lane 13:35
Re: [SQL] WHERE clause? Tom Lane 14:00
Prolem wiht long query? Jérome Knöbl 14:31
Re: [SQL] Few questions about my slow query Tom Lane 14:41
Re: [SQL] Prolem wiht long query? Tom Lane 15:20
Re: [SQL] WHERE clause? Steven Bradley 15:50
SELECT using arrays Evan Klinger 21:05
How big can a transaction query be? Kyle Bateman 23:03

July 15, 1999

Thread Author Time
Re: [SQL] How big can a transaction query be? Tom Lane 00:27
Re: [HACKERS] Counting bool flags in a complex query Tom Lane 15:07
Foreign keys Esteban Chiner Sanz 17:14
RE: [SQL] Foreign keys Jackson, DeJuan 17:58
query length limits [email protected] 19:13

July 16, 1999

Thread Author Time
query length limits [email protected] 01:17
RE: query length limits Ansley, Michael 07:06
Re: [HACKERS] Counting bool flags in a complex query Michael Richards 08:37
RE: [HACKERS] Counting bool flags in a complex query Ansley, Michael 09:18
RE: [HACKERS] Counting bool flags in a complex query Ansley, Michael 10:01
Stored Procedures and other stuffs Ademir Mazer Jr 13:13
Re: [HACKERS] Counting bool flags in a complex query Tom Lane 14:35
Re: [HACKERS] Counting bool flags in a complex query Michael Richards 21:19
Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Tom Lane 21:56
user defined function speeds [email protected] 22:24

July 17, 1999

Thread Author Time
Fix up for BTP_CHAIN problems Wayne Piekarski 03:40

July 18, 1999

Thread Author Time
Re: [SQL] Stored Procedures and other stuffs Stephen Boyle 07:37

July 19, 1999

Thread Author Time
Re: [HACKERS] Fix up for BTP_CHAIN problems Vadim Mikheev 01:56
Re: [SQL] SELECT using arrays Herouth Maoz 11:48
Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Herouth Maoz 12:11
Re: [SQL] Good Optimization secret 14:02
Re: [SQL] Good Optimization secret 14:15
Re: [SQL] Good Optimization Bruce Momjian 14:37
Large text novikov 14:47
Re: [SQL] Re: [HACKERS] Counting bool flags in a complex query Tom Lane 14:48
Re: [SQL] Good Optimization Tom Lane 15:14
RE: pgsql-sql-digest V1 #281 Dionisio Barrantes 17:16

July 20, 1999

Thread Author Time
Re: [SQL] how to determine table? Chris Bitmead 02:41
[No subject] Vikrant Rathore 04:30
bad select performance for where (x=1 or x=3) George Young 14:02
Re: [SQL] bad select performance for where (x=1 or x=3) Tom Lane 14:53
Can I prevent my sequence to increment if an insert is rejected? Frederic De Leersnijder 16:54
Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? [email protected] 19:01
Bad update performance? Gunnar Ingvi Thorisson 23:06

July 21, 1999

Thread Author Time
Tool for generating entity relation diagrams. GrooveRipper 01:36
Re: [SQL] Bad update performance? [email protected] 02:28
RE: Tool for generating entity relation diagrams. Ansley, Michael 07:44
how to add users in group Jonathan davis 08:57
Re: [SQL] Can I prevent my sequence to increment if an insert is rejected? Herouth Maoz 09:15
Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Chris Bitmead 09:36
Re: [SQL] Can I prevent my sequence to increment if an insert isrejected? Herouth Maoz 09:45
pb with pg_group Jonathan davis 09:46

Browse Archives

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