pgsql-sql since 1999-06-30 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

June 30, 1999

Thread Author Time
begin/end/abort work for sequences? Kyle 04:11
RE: pgsql-sql-digest V1 #276 Ansley, Michael 07:24
Beginner's headache of joins webmaster 08:10
Oracle greatest() and nvl() equivalent? Petter Reinholdtsen 08:53
Re: [SQL] begin/end/abort work for sequences? José Soares 12:08
More fun with random selects Darren Greer 12:27
[SQL] Port? 📎 Dirk Drechsel 12:49
Re: [SQL] Port? 📎 Dirk Drechsel 12:53
String concat operator??? webmaster 13:16
Re: [PORTS] Port Bug Report: parse error not detected on unterminated quote Thomas Lockhart 13:31
Re: [SQL] String concat operator??? Herouth Maoz 13:35
Re: [SQL] Port? Jeff MacDonald 13:56
Re: [SQL] String concat operator??? Tom Lane 14:18
Re: [PORTS] Port Bug Report: parse error not detected on unterminated quote Herouth Maoz 14:19
Re: [SQL] More fun with random selects Tom Lane 14:28
Re: [PORTS] Port Bug Report: parse error not detected onunterminated quote Kyle Bateman 14:36
Re: [SQL] Beginner's headache of joins Tom Lane 14:43
Re: [PORTS] Port Bug Report: parse error not detected onunterminated quote Thomas Lockhart 15:16
User defined functions through ODBC Hostmaster - Internet au Virtuel Inc. 17:07
Escaping w/i regular expressions Peter Eisentraut 18:07

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