pgsql-sql - April 2002

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

April 1, 2002

Thread Author Time
Statistics Hunter, Ray 16:15
Re: Statistics Bruce Momjian 16:24
Re: Statistics Hunter, Ray 16:25
optimyzing Mathieu Arnold 17:14
Re: Statistics Marin Dimitrov 17:35
Sub-Select in CASE Brian C. Doyle 17:47

April 2, 2002

Thread Author Time
selecting records from a date range Dan Langille 00:36
Re: selecting records from a date range Tom Lane 01:43
Re: selecting records from a date range Dan Langille 02:04
Re: selecting records from a date range Tom Lane 02:18
Re: About temporary table jack 03:41
Database Locations Keith Gray 08:16
Upgrading PostgreSQL to 7.1.3 Gordon Clarke 12:13
Re: optimyzing Masaru Sugawara 15:44
vacuum full fails: Parent tuple was not found[7.2] george young 16:46
Re: Database Locations Peter Eisentraut 17:08
Re: Database Locations Tom Lane 17:29
Re: vacuum full fails: Parent tuple was not found[7.2] Tom Lane 17:40
Old message Dan Langille 18:42
Re: procedure support in 7.2 Dan Langille 18:50

April 3, 2002

Thread Author Time
Re: Upgrading PostgreSQL to 7.1.3 Peter Eisentraut 01:41
16 parameter limit John Proctor 02:50
Update in trigger Iklódi Lajos 03:38
Date cristi 06:10
Date cristi69 06:12
bytea or large object Jean-Christophe FABRE 14:47
Re: bytea or large object Timothy_maguire 14:48
Logging option Samuel J. Sutjiono 14:59
Primary and foreign key from system tables Jan Oravec 15:07
Re: bytea or large object Joe Conway 16:12
Re: Primary and foreign key from system tables Stephan Szabo 16:39
Re: Update in trigger Jan Wieck 16:44
Re: [SQL] Logging option Bruce Momjian 19:07
Named column in a Function fails at ORDER BY (PgSQL 7.1) Bernd von den Brincken 19:15
Re: [SQL] Logging option Samuel J. Sutjiono 19:25
Re: [SQL] Logging option Bruce Momjian 19:34
date manipulation Travis Hoyt 20:15
FULL JOIN with 3 or more tables Michael Adler 20:58
Re: date manipulation Ewald Geschwinde 21:14
Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) Tom Lane 21:46
Re: date manipulation Josh Berkus 21:57

April 4, 2002

Thread Author Time
Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) Bernd von den Brincken 00:28
Re: Cleaning up template 1 -> template0 cloning Josh Berkus 01:45
Re: Cleaning up template 1 -> template0 cloning Josh Berkus 01:58
Re: Cleaning up template 1 -> template0 cloning Tom Lane 03:33
Re: Update in trigger Iklódi Lajos 03:41
Re: [SQL] bytea or large object Frank Joerdens 07:00
Re: bytea or large object Frank Joerdens 09:40
Re: bytea or large object Frank Joerdens 10:36
Re: [SQL] bytea or large object Martín Marqués 11:08
Re: FULL JOIN with 3 or more tables Masaru Sugawara 15:01
Re: Update in trigger Jan Wieck 15:05
md5 auth Kovacs Zoltan 16:33
Re: Date Jan Wieck 16:41
Re: Rvsd. / Re: Named column in a Function fails at ORDER BY (PgSQL 7.1) Tom Lane 17:03
Re: md5 auth Tom Lane 17:09
Rule trouble (looks to me exactly like the example) Frank Joerdens 17:17
Re: 16 parameter limit Josh Berkus 17:20
Re: Rule trouble (looks to me exactly like the example) Tom Lane 19:29

April 5, 2002

Thread Author Time
Re: 16 parameter limit Bruce Momjian 02:40
Re: Rule trouble (looks to me exactly like the example) Tom Lane 05:59
Re: Rule trouble (looks to me exactly like the example) Frank Joerdens 10:08
LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Magnus Enbom 14:08
Re: FULL JOIN with 3 or more tables Michael Adler 14:28
Re: Rule trouble (looks to me exactly like the example) Tom Lane 15:42
Re: 16 parameter limit Josh Berkus 16:30
Re: 16 parameter limit Josh Berkus 16:46
Re: 16 parameter limit Tom Lane 18:21
Re: 16 parameter limit Josh Berkus 22:29
intersect performance (PG 7.1.3 vs 7.2) d_nardini 22:39
Re: 16 parameter limit Tom Lane 23:18
Re: 16 parameter limit Josh Berkus 23:26
Re: 16 parameter limit Tom Lane 23:33
Re: intersect performance (PG 7.1.3 vs 7.2) Tom Lane 23:50
Re: 16 parameter limit Josh Berkus 23:51

April 6, 2002

Thread Author Time
Re: 16 parameter limit Barry Lind 05:35
Re: intersect performance (PG 7.1.3 vs 7.2) d_nardini 09:49
Re: intersect performance (PG 7.1.3 vs 7.2) Tom Lane 15:45

April 7, 2002

Thread Author Time
Re: Rule trouble (looks to me exactly like the example) Frank Joerdens 14:15

April 8, 2002

Thread Author Time
JOINS and non use of indexes Ian Cass 12:35
Re: JOINS and non use of indexes Ian Cass 12:44
best method for select within all dimensions of an array Jaume Teixi 14:28
Re: JOINS and non use of indexes Christopher Kings-Lynne 14:33
Re: JOINS and non use of indexes Ian Cass 14:41
Re: JOINS and non use of indexes Tom Lane 14:46
Re: JOINS and non use of indexes Ian Cass 15:12
Re: JOINS and non use of indexes Ian Cass 15:16
Re: JOINS and non use of indexes Tom Lane 15:21

April 9, 2002

Thread Author Time
Scadinavian characters in regular expressions Søren Vainio 08:51
Re: Scadinavian characters in regular expressions Andreas Joseph Krogh 09:53
Re: How slow is DISTINCT? Michael Contzen 10:15
Re: Scadinavian characters in regular expressions Søren Vainio 11:28
Re: Scadinavian characters in regular expressions Andreas Joseph Krogh 11:49
replace NULL Kancha . 12:00
Re: replace NULL Andreas Joseph Krogh 12:14
Re: Hierarchical Queries Christopher Kings-Lynne 13:01
Hierarchical Queries Gautham S. Rao 13:04
Re: Scadinavian characters in regular expressions Tom Lane 13:33
Re: Scadinavian characters in regular expressions Søren Vainio 14:21
Re: Hierarchical Queries Roberto Mello 15:34
type conversion? Peter Atkins 17:08
Re: type conversion? Stephan Szabo 17:48
Re: type conversion? Jean-Luc Lachance 17:51
Yes! Thank you! Michael Teter 19:48
Is there any Faster workaround ?? Rajesh Kumar Mallah 19:54
Help To Out Isaac Mesa Florez 20:16
Re: Is there any Faster workaround ?? David Stanaway 20:19
Re: Is there any Faster workaround ?? Jean-Luc Lachance 21:02
Thank you ! Re: Is there any Faster workaround ?? Rajesh Kumar Mallah 21:32
new problem! Is there any Faster workaround ?? Rajesh Kumar Mallah 21:46

April 10, 2002

Thread Author Time
Re: Scadinavian characters in regular expressions Tatsuo Ishii 01:06
Re: Help To Out Christopher Kings-Lynne 02:08
How to use an index on a bigint column Pierre-Andre Michel 07:48
Re: replace NULL Gaetano Mendola 10:03
Optimizer for IN (..) ? / Re: Thank you ! Re: Is there any Faster workaround ?? Bernd von den Brincken 10:24
oid and oidvector Camila Rocha 11:19
Postgresql goes into recovery mode .... Rajesh Kumar Mallah 11:25
Re: replace NULL Torbj=?ISO-8859-1?B?9g==?=rn Andersson 11:42
Re: new problem! Is there any Faster workaround ?? Jeff Eckermann 15:44
Re: Postgresql goes into recovery mode .... Jeff Eckermann 15:51
How to use an index on a bigint column Pierre-Andre Michel 16:29
How to use an index on a bigint column Pierre-Andre Michel 16:29
Re: Postgresql goes into recovery mode .... Jean-Luc Lachance 16:30
View INSERTs not returning OID in Postgres 7.2.1 Damon Cokenias 21:40

April 11, 2002

Thread Author Time
Functions in Postgres gordoncl 00:35
Re: Functions in Postgres Peter Eisentraut 00:55
crypt question (search mail list) Keith Gray 01:51
Re: crypt question (search mail list) jeff fitzmyers 02:04
Re: View INSERTs not returning OID in Postgres 7.2.1 Tom Lane 02:10
Re: Postgresql goes into recovery mode .... Rajesh Kumar Mallah 06:34
Re: new problem! Is there any Faster workaround ?? Rajesh Kumar Mallah 06:46
Date format cristi 07:00
Date format cristi69 07:04
Re: Date format Tubagus Nizomi 07:20
REPOST: Trouble with SQL conversion Richard Ellerbrock 09:49
Problem With A Rule cnliou 11:09
Transactional vs. Read-only (Retrieval) database Samuel J. Sutjiono 13:14
Re: REPOST: Trouble with SQL conversion Christopher Kings-Lynne 13:28
using output of a subselect in LIKE/ILIKE Rajesh Kumar Mallah 14:04
Re: REPOST: Trouble with SQL conversion Richard Ellerbrock 14:08
Re: Transactional vs. Read-only (Retrieval) database Jean-Michel POURE 14:25
Re: Postgresql goes into recovery mode .... Jeff Eckermann 14:46
Re: using output of a subselect in LIKE/ILIKE Jeff Eckermann 14:48
Re: Problem With A Rule Tom Lane 14:52
Re: REPOST: Trouble with SQL conversion Richard Ellerbrock 15:16
Re: using output of a subselect in LIKE/ILIKE Rajesh Kumar Mallah 15:17
Re: REPOST: Trouble with SQL conversion Christopher Kings-Lynne 15:36
Re: REPOST: Trouble with SQL conversion Richard Ellerbrock 15:48
Re: Functions in Postgres Gordon Clarke 20:59
Inserting values into numeric fields Eric Carpenter 22:16
Re: [SQL] Transactional vs. Read-only (Retrieval) database Josh Berkus 23:16

April 12, 2002

Thread Author Time
Re: Inserting values into numeric fields Jason Earl 00:00
How to get more detailed error messages? Markus Wagner 06:11
how to get more detailed error messages? Markus Wagner 07:04
Problem With A Rule (clear version) cnliou 10:50
Re: [SQL] Transactional vs. Read-only (Retrieval) database Samuel J. Sutjiono 14:51
PL/PGSQL question on transactions Dan Schwitalla 15:50
Re: PL/PGSQL question on transactions Christopher Kings-Lynne 15:58
Re: Functions in Postgres Peter Eisentraut 16:24
Re: PL/PGSQL question on transactions Jie Liang 16:34
Re: Functions in Postgres Tom Lane 17:11
Re: Transactional vs. Read-only (Retrieval) database Josh Berkus 17:12
Re: Problem With A Rule (clear version) Tom Lane 17:32
Re: [SQL] how to get more detailed error messages? Tom Lane 17:40
Re: [SQL] how to get more detailed error messages? Alvaro Herrera 18:05
Re: Functions in Postgres Jan Wieck 18:07
Re: Functions in Postgres Jan Wieck 18:16
Re: [SQL] how to get more detailed error messages? Richard Emberson 18:20
Re: [SQL] how to get more detailed error messages? Josh Berkus 18:26
Re: Functions in Postgres Tom Lane 18:28
Proposal: New Mailing List Josh Berkus 18:30
Re: Functions in Postgres Jan Wieck 18:46
Re: Functions in Postgres Tom Lane 18:58
Re: Functions in Postgres Jan Wieck 19:12

April 13, 2002

Thread Author Time
Re: Problem With A Rule (clear version) cnliou 01:16
Re: Proposal: New Mailing List Rajesh Kumar Mallah 06:15
deletions on master table takes for ever... Rajesh Kumar Mallah 10:07
Re: deletions on master table takes for ever... Stephan Szabo 14:57
to_char problem postgresql 16:57
Re: to_char problem Tom Lane 17:00

April 15, 2002

Thread Author Time
data order problem jack 03:19
Re: data order problem Josh Berkus 04:53
Re: data order problem Tom Lane 04:55
Re: data order problem jack 06:40
case statement in group by clause Dorian Taylor 10:44
Re: case statement in group by clause Tom Lane 14:35
Re: How slow is DISTINCT? Tom Lane 14:49
Re: Thank you ! Re: Is there any Faster workaround ?? Roberto Mello 15:23
Re: data order problem Josh Berkus 15:46
Large or Small tables? Edipo Elder Fernandes de Melo 17:38
Re: data order problem Stephan Szabo 17:45
MAX(column1),MAX(column2),... Bjarte Aagnes 18:38
Re: oid and oidvector Bruce Momjian 19:13
Re: MAX(column1),MAX(column2),... Josh Berkus 19:34
Re: MAX(column1),MAX(column2),... Travis Hoyt 20:17
Re: oid and oidvector Tom Lane 20:36
Re: oid and oidvector Bruce Momjian 20:39
Re: oid and oidvector Tom Lane 20:47

April 16, 2002

Thread Author Time
please advise on column data type jack 01:25
Re: How slow is DISTINCT? Christopher Kings-Lynne 01:53

Browse Archives

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