Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
pgsql-sql - April 2002
Prev | Next
2002-04-01
- 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)
2002-04-02
- 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)
2002-04-03
- 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)
2002-04-04
- 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)
2002-04-05
- 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)
2002-04-06
- 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)
2002-04-07
- Re: Rule trouble (looks to me exactly like the example) Frank Joerdens (14:15)
2002-04-08
- 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)
2002-04-09
- 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)
2002-04-10
- 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)
2002-04-11
- 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)
2002-04-12
- 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)
2002-04-13
- 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)
2002-04-15
- 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)
2002-04-16
- please advise on column data type jack (01:25)
- Re: How slow is DISTINCT? Christopher Kings-Lynne (01:53)