pgsql-sql since 1999-11-15 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

Nov. 15, 1999

Thread Author Time
how can tell if a column is a primary key? Mark Stosberg 04:57
Re: [SQL] Verificate values in other table? Tom Lane 05:18
Re: [SQL] how can tell if a column is a primary key? Gary MacMinn 05:28
[SQL] Handling NULL Dates Gary MacMinn 05:43
Re: [SQL] nulls and datetime Tom Lane 06:10
Re: [SQL] Trying to move a 6.1 database to 6.5 Stoyan Genov 08:52
large objects over network connection oskar stuffer 11:49
Re: [SQL] how can tell if a column is a primary key? D'Arcy J.M. Cain 12:34
Re: [SQL] how can tell if a column is a primary key? Tom Lane 15:24
Re: [SQL] nulls and datetime Thomas Lockhart 15:29
Re: [SQL] nulls and datetime Tom Lane 15:41
Re: [SQL] nulls and datetime Thomas Lockhart 16:11
NULL Goran Thyni 19:07
Re: [SQL] NULL Bruce Momjian 19:23
Re: [SQL] NULL Bruce Stephens 19:57
Re: [SQL] how can tell if a column is a primary key? Howie 22:37
Re: [SQL] Verificate values in other table? Jan Wieck 23:36
Re: [SQL] NULL Jan Wieck 23:48

Nov. 16, 1999

Thread Author Time
Re: [SQL] NULL Tom Lane 00:50
Re: [SQL] how can tell if a column is a primary key? D'Arcy J.M. Cain 03:19
permanent deleting Roomi 07:26
Re: [SQL] NULL jose soares 13:37
Re: [SQL] NULL Jan Wieck 14:16
ODBC/Openlink/Delphi maxsbox 18:17
Updating datetime fields with NULL values Gary MacMinn 22:28
Re: [SQL] Updating datetime fields with NULL values John Ziniti 22:58
Re: [SQL] zombie postmasters [email protected] 23:00
zombie postmasters Hamid Khoshnevis 23:06
Re: [SQL] zombie postmasters Chad Miller 23:21
Re: [SQL] zombie postmasters Stephen J Lombardo 23:39

Nov. 17, 1999

Thread Author Time
Threaded PGSQL access (was Re: [SQL] zombie postmasters) Mathijs Brands 00:10
Re: [SQL] zombie postmasters Tom Lane 05:05
Re: [SQL] nulls and datetime Gary MacMinn 05:16
Re: [SQL] zombie postmasters Jan Wieck 08:26
Re: [SQL] zombie postmasters Zalman Stern 08:44
Re: [SQL] ODBC/Openlink/Delphi jose soares 13:34
Building "ON DELETE" rules to keep the referential integrity of a database Stoyan Genov 13:42
Re: [SQL] NULL jose soares 13:56
Re: [SQL] NULL Jan Wieck 18:31

Nov. 18, 1999

Thread Author Time
Antw: [SQL] Building "ON DELETE" rules to keep the referential integrity of a database Gerhard Dieringer 08:01
please help me on pl/pgsql triggers (fwd) Mario Olimpio de Menezes 09:49
Can't create an index on NUMERIC(x,y) secret 16:08
Re: [SQL] Can't create an index on NUMERIC(x,y) Jan Wieck 22:18
sql question: min remapped value Douglas Nichols 23:26

Nov. 19, 1999

Thread Author Time
Re: [SQL] sql question: min remapped value Tom Lane 00:43
Backend message type 0x45 arrived while idle Haris Susanto 07:24
Deleting rows with time 55 minutes less than max time Imtiaz. S. M 11:07
selecting from indexes Tim Joyce 14:22
Re: [SQL] selecting from indexes Tom Lane 15:21
Re: [SQL] selecting from indexes Tim Joyce 16:25
Re: [SQL] selecting from indexes Tom Lane 17:23
Re: [SQL] selecting from indexes Tim Joyce 20:06
Re: [SQL] selecting from indexes Tom Lane 22:18
Re: [SQL] selecting from indexes Tim Joyce 22:55

Nov. 20, 1999

Thread Author Time
Deleting indexes before vacuum? Matthew Hagerty 01:03
Re: [SQL] Deleting indexes before vacuum? Tom Lane 06:14
Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov 07:57
RE: [SQL] Deleting indexes before vacuum? Pham, Thinh 15:29
Re: [SQL] Deleting indexes before vacuum? Tom Lane 17:01
Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov 18:57
Re: [SQL] Deleting indexes before vacuum? Oleg Bartunov 19:44

Nov. 21, 1999

Thread Author Time
How to optimize this simple query :-( marten 11:12

Nov. 22, 1999

Thread Author Time
RE: [SQL] Deleting indexes before vacuum? Hiroshi Inoue 01:53
Re: [SQL] Deleting indexes before vacuum? Tom Lane 03:18
Parameterised ADOCommand object Vs Exec SQL CHAITANYANC 04:24
RE: [SQL] Deleting indexes before vacuum? Hiroshi Inoue 05:52
unsubscribe Drinks, Ivan - ITD 17:07

Nov. 23, 1999

Thread Author Time
soporte Liliana Pineda 11:06
[No subject] Stefano Lixi 18:49
Re: [SQL] Store multi-media with Postgres? Mathijs Brands 21:05
Store multi-media with Postgres? Duncan Kinder 21:43
[No subject] Christopher Sawtell 21:56

Nov. 24, 1999

Thread Author Time
Info on SQL Parsing required CHAITANYANC 03:39
Re: [SQL] Info on SQL Parsing required neko 10:22
Re: [SQL] NULL Bruce Stephens 15:08
Re: pgsql-sql-digest V1 #422 maxsbox 18:14

Nov. 25, 1999

Thread Author Time
recursive 📎 Julien Cadiou 01:09
recursion 📎 Julien Cadiou 01:15
very slow connection Szucs Laszlo 12:21
pqReadData() error Dipankar Chakrabarti 12:23
Re: [SQL] pqReadData() error Jan Wieck 12:37
Re: [SQL] Re: pgsql-sql-digest V1 #422 Fabrice Scemama 22:03
Re: [SQL] Info on SQL Parsing required Peter Eisentraut 23:43

Nov. 26, 1999

Thread Author Time
Re: pgsql-sql-digest V1 #424 Dipankar Chakrabarti 05:42
Backend dies (6.5.3-1) on SELECT from 6 row table Emils Klotins 14:35
national character once again Artur Kokoszka 15:52
Re: [SQL] Backend dies (6.5.3-1) on SELECT from 6 row table Tom Lane 16:20
DISTINCT & COUNT Moray McConnachie 16:35
6.5.3 - backend closes if wrong parameters to NULLIF, CASE Emils Klotins 17:48
Re: [SQL] DISTINCT & COUNT Stuart Rison 18:00
Re: [SQL] 6.5.3 - backend closes if wrong parameters to NULLIF, CASE Tom Lane 18:06
Re: [SQL] DISTINCT & COUNT Tom Lane 18:19
TEST MESSAGE - PLEASE IGNORE Zodiac Speaker 19:56
Re: [SQL] national character once again Jan Wieck 23:26

Nov. 27, 1999

Thread Author Time
Numeric format for currency Rich Shepard 01:23
Usage of index in "ORDER BY" operations Matthias Ackermann 15:32
Re: [SQL] Usage of index in "ORDER BY" operations Tom Lane 17:18
Design Question Andy Lewis 18:25
Re: [SQL] Design Question Rich Shepard 18:41
Re: [SQL] Design Question Andy Lewis 18:49
Re: [SQL] Design Question 📎 Julien Cadiou 22:50
recusrion Julien Cadiou 23:00

Nov. 28, 1999

Thread Author Time
Re: [SQL] Design Question De Moudt Walter 19:23
Re: [SQL] Design Question Andy Lewis 20:56

Nov. 29, 1999

Thread Author Time
create view on union -- workaround? Brian Haney 08:13
Your query ... S S Mani 09:14
Your Query... S S Mani 09:28
Re: [SQL] recusrion Stoyan Genov 09:38
[No subject] Alexey V. Meledin 17:00

Nov. 30, 1999

Thread Author Time
Re: [SQL] NULL Bruce Momjian 03:13
unixtime -> datetime Thilo Mezger 08:07
found a way to update a table with data from another one Patrick JACQUOT 12:07
Re: [SQL] found a way to update a table with data from another one Tom Lane 15:22
Re: [SQL] NULL Ross J. Reedstrom 16:12
Re: [SQL] NULL Peter Eisentraut 16:27
Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) Emils Klotins 16:43
Re: [SQL] NULL Ross J. Reedstrom 17:48
Re: [SQL] NULL Tom Lane 18:07
Re: [SQL] NULL Ross J. Reedstrom 19:09
date function questions... Zsolt Varga 19:15
Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) Oliver Elphick 22:04
Re: [SQL] Addendum: PG6.5.3: CASE w. diff THEN types -- prob with Linux(?) Tom Lane 22:56
slow sort for simple join Mark Kirkwood 23:14

Dec. 1, 1999

Thread Author Time
RestrictionClauseSelectivity Frank Bax 01:35
RestrictionClauseSelectivity Frank Bax 02:45
Re: [SQL] RestrictionClauseSelectivity Bruce Momjian 03:07
Many booleans Chris Griffin 03:26
VACUUM PROBLEM Dipankar Chakrabarti 05:40
Antw: [SQL] Many booleans Gerhard Dieringer 08:34
Re: [SQL] found a way to update a table with data from another one Patrick JACQUOT 09:32
Partial Search pez 14:07
Antw: [SQL] Partial Search Gerhard Dieringer 14:50
do queries from strings in pgplsql Virgilio Sanz 16:04
Re: [SQL] VACUUM PROBLEM Tom Lane 16:19
Re: [SQL] Partial Search Wim Ceulemans 17:03
Except operation Satyajeet Seth 18:40
arrays Marcin Mazurek - Multinet SA - Poznan 22:34

Dec. 2, 1999

Thread Author Time
Re: [SQL] arrays Karel Zak - Zakkr 10:20
Re: [SQL] arrays Marcin Mazurek - Multinet SA - Poznan 11:01
Re: [SQL] arrays Karel Zak - Zakkr 11:11
PL/PgSQL: selects into strings Virgilio Sanz 15:16
Logical and for int4? Chris Griffin 18:09
How to avoid "Out of memory" using aggregate functions? Mark Dalphin 19:30
PHP/Postgres dieing in random but consistent place. Zot O'Connor 20:18
A search SQL query Tom Techoueyres 20:51
RE: [SQL] A search SQL query Tom Techoueyres 21:38
Re: [SQL] A search SQL query kaiq 22:27
SQLState Rini Dutta 22:52
RE: [SQL] A search SQL query kaiq 22:53
Re: [SQL] A search SQL query Tom Lane 23:05
Re: [SQL] How to avoid "Out of memory" using aggregate functions? Tom Lane 23:32

Dec. 3, 1999

Thread Author Time
Re: [SQL] Logical and for int4? Chris Griffin 03:16
Another Date question Andy Lewis 03:56
Re: [SQL] A search SQL query [email protected] 05:56
Re: [SQL] Another Date question kaiq 06:13
the book and sql92 kaiq 06:46
Re: [SQL] the book and sql92 Bruce Momjian 07:56
Re: [SQL] Another Date question Stoyan Genov 08:32
Re: [SQL] PL/PgSQL: selects into strings Jan Wieck 10:01
Datetime operators (was: Re: [SQL] Another Date question) Karel Zak - Zakkr 12:23
[No subject] jdibartolomeo 13:00
Re: pgsql-sql-digest V1 #431 Mitch Golden 13:46
Howto to force NULL rows at the bottom ? Dirk Lutzebaeck 13:57
Re: [SQL] Another Date question Andy Lewis 14:04
Wierd stuff Mario Jorge Nunes Filipe 15:24
Re: Datetime operators (was: Re: [SQL] Another Date question) Thomas Lockhart 15:48
Re: Datetime operators (was: Re: [SQL] Another Date question) Karel Zak - Zakkr 15:50
Re: [SQL] Wierd stuff Jan Wieck 16:33
Re: [SQL] Wierd stuff Mario Jorge Nunes Filipe 16:46
Re: [SQL] Wierd stuff Mario Jorge Nunes Filipe 17:23
Re: [SQL] Howto to force NULL rows at the bottom ? Bruce Momjian 17:28
Re: [SQL] Wierd stuff Mario Jorge Nunes Filipe 17:28
Re: Datetime operators (was: Re: [SQL] Another Date question) kaiq 19:43
Re: Datetime operators (was: Re: [SQL] Another Date question) Andy Lewis 19:43
Re: Datetime operators (was: Re: [SQL] Another Date question) Thomas Lockhart 20:03
Re: Datetime operators (was: Re: [SQL] Another Date question) Thomas Lockhart 20:06
Re: Datetime operators (was: Re: [SQL] Another Date question) kaiq 20:48
Re: Datetime operators (was: Re: [SQL] Another Date question) kaiq 21:01
Re: Datetime operators (was: Re: [SQL] Another Date question) Tom Lane 22:35
Re: [SQL] Wierd stuff Tom Lane 23:00

Dec. 4, 1999

Thread Author Time
Re: [SQL] arrays Peter Eisentraut 02:23
Re: [SQL] arrays Stephen Davies 09:31
Re: [SQL] arrays John M. Flinchbaugh 14:02
Re: [SQL] arrays neko 15:05
Re: [SQL] arrays Tom Lane 17:41
Two serial fields, PK identity Alexey V. Meledin 19:23
Re: [SQL] arrays kaiq 19:45
Postgres Date/Time Special Constants Alexey V. Meledin 20:25

Dec. 5, 1999

Thread Author Time
Re: [SQL] Postgres Date/Time Special Constants kaiq 01:49
group by [email protected] 03:49
Re: [SQL] group by Tom Lane 05:47
Re: [SQL] Howto to force NULL rows at the bottom ? Stoyan Genov 11:53
Accent Marks Jonathan Karlen 15:39
Re: [SQL] Accent Marks [email protected] 18:03
Re: [SQL] Howto to force NULL rows at the bottom ? Peter Eisentraut 22:56

Dec. 6, 1999

Thread Author Time
Re: [SQL] Howto to force NULL rows at the bottom ? Tom Lane 00:51
RE: [SQL] Howto to force NULL rows at the bottom ? Hiroshi Inoue 02:06
Re: [SQL] Howto to force NULL rows at the bottom ? Tom Lane 03:08
Re: [SQL] Howto to force NULL rows at the bottom ? Bruce Momjian 03:34
(no subject) cristiv 03:38

Browse Archives

Prev | Next