pgsql-sql since 2002-04-11 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
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 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
Re: please advise on column data type Josh Berkus 02:51
Re: [SQL] 16 parameter limit 📎 Bruce Momjian 02:58
Re: [PATCHES] [SQL] 16 parameter limit Rod Taylor 03:19
Re: [SQL] 16 parameter limit Josh Berkus 03:25
Re: [PATCHES] [SQL] 16 parameter limit Alvaro Herrera 03:34
Re: [SQL] 16 parameter limit Peter Eisentraut 03:34
Re: [SQL] 16 parameter limit Christopher Kings-Lynne 03:35
Re: [PATCHES] [SQL] 16 parameter limit Neil Conway 03:42
Re: [PATCHES] [SQL] 16 parameter limit Bruce Momjian 03:44
Re: [PATCHES] [SQL] 16 parameter limit Christopher Kings-Lynne 03:49
Re: [SQL] 16 parameter limit Neil Conway 03:52
Re: [SQL] 16 parameter limit Christopher Kings-Lynne 03:57
Re: [SQL] 16 parameter limit Bruce Momjian 03:57
Re: [SQL] 16 parameter limit Josh Berkus 04:06
Re: [SQL] 16 parameter limit Tom Lane 04:13
Re: [PATCHES] [SQL] 16 parameter limit Peter Eisentraut 04:36
Re: please advise on column data type Tom Lane 04:47
Re: [SQL] 16 parameter limit John Proctor 04:49
Re: [SQL] 16 parameter limit Josh Berkus 04:50
Re: [PATCHES] [SQL] 16 parameter limit Tom Lane 05:01
Re: [PATCHES] [SQL] 16 parameter limit Bruce Momjian 05:06
help - JOIN problem KeithR 14:10
Re: [SQL] 16 parameter limit Neil Conway 16:04
Re: [PATCHES] [SQL] 16 parameter limit Hannu Krosing 19:12

April 17, 2002

Thread Author Time
Re: help - JOIN problem Josh Berkus 04:32
Re: [SQL] 16 parameter limit John Proctor 06:22
My is degraded after two weeks Fernando Carvalho 11:10
Need some help in dates Stéphane DEWITTE 11:58
Need some help with dates Stéphane DEWITTE 12:33
How to reset sequences on pre-7.1 Matteo Beccati 12:44
Re: Need some help with dates Gautham S. Rao 13:00
Re: Need some help with dates Stéphane DEWITTE 13:01
Re: Need some help with dates Stéphane DEWITTE 13:33
Re: Need some help with dates Gautham S. Rao 13:49
Re: [SQL] 16 parameter limit Christopher Kings-Lynne 14:29
Re: [SQL] 16 parameter limit Larry Rosenman 14:41
Re: Need some help with dates Miguel Carvalho 14:53
Re: How to reset sequences on pre-7.1 Tom Lane 15:25
Re: [SQL] 16 parameter limit Josh Berkus 16:08
Re: Need some help with dates Josh Berkus 16:16
Help with conversions (suite) Stéphane DEWITTE 16:18
Re: My is degraded after two weeks Stephan Szabo 16:27
Re: [SQL] A bug in gistPageAddItem()/gist_tuple_replacekey() ??? Bruce Momjian 21:58
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 22:07

April 18, 2002

Thread Author Time
Re: LIMIT 1 FOR UPDATE or FOR UPDATE LIMIT 1? Bruce Momjian 03:43
Migrating Oracle to PostgreSQL Makarov Gera x8521 05:24
SQL Query Optimization Dav Coleman 05:30
[No subject] fredrik.samuelsson 07:12
Re: now() does not change within a transaction Karel Zak 12:41
Re: [GENERAL] Migrating Oracle to PostgreSQL Leif Jensen 13:21
Re: Migrating Oracle to PostgreSQL Karel Zak 13:26
now() does not change within a transaction Christoph Haller 14:04
DISTINCT ON ... without distinct null values ? Albrecht Berger 14:43
Re: SQL Query Optimization Josh Berkus 15:43
Re: now() does not change within a transaction Bruce Momjian 15:50
Re: SQL Query Optimization Tom Lane 16:15
Re: SQL Query Optimization Dav Coleman 16:35
Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck 16:43
Re: SQL Holiday Calculations Josh Berkus 17:19
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 17:22
Re: call the same pl/pgsql procedure twice in the same connection Richard Huxton 17:22
Re: SQL Query Optimization Josh Berkus 17:38
Re: SQL Query Optimization Richard Huxton 17:38
Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck 18:49
Re: DISTINCT ON ... without distinct null values ? Fduch the Pravking 23:30

April 19, 2002

Thread Author Time
Re: [DOCS] [GENERAL] Migrating Oracle to PostgreSQL Roberto Mello 01:41
count different values in column? Thorsten Wenzlaff 09:27
count different values in column Albrecht Berger 09:30
Re: count different values in column Tod McQuillin 09:40
Re: count different values in column Fduch the Pravking 09:55
Re: count different values in column Gautham S. Rao 10:00
how to get index scan at work? Rajesh Kumar Mallah 11:10
Re: how to get index scan at work? 📎 Thomas Swan 11:23
Re: count different values in column Christoph Haller 11:46
Re: [SQL] MAX(column1),MAX(column2),... Bjarte Aagnes 13:00
How to log outputs from pl/pgsql into a file ? Stéphane DEWITTE 14:39
Re: how to get index scan at work? Rajesh Kumar Mallah 16:33
Re: how to get index scan at work? Stephan Szabo 17:12
Re: How to log outputs from pl/pgsql into a file ? Jie Liang 18:32
Query Praise! Matthew Hagerty 19:24
Trying to get query to work Brian Kosick 20:07
Trying to get query to work. Brian Kosick 20:10

April 20, 2002

Thread Author Time
accept AD35- 6FA9 -9515 tulasi 07:01
Re: count different values in column? Rajesh Kumar Mallah 17:23
OpenFTS/tsearch and Postgresql 7.2.1 Rajesh Kumar Mallah 19:00
postgresql query to XML result Rishabh Gupta 21:01

April 21, 2002

Thread Author Time
Re: accept AD35- 6FA9 -9515 Peter Eisentraut 04:45
Re: [OpenFTS-general] OpenFTS/tsearch and Postgresql 7.2.1 Oleg Bartunov 05:02
Re: Trying to get query to work Stephan Szabo 06:04
Is this a BUG? Is there anyone has the same problem? jack 13:39
Re: accept AD35- 6FA9 -9515 postgresql 14:10
Re: Is this a BUG? Is there anyone has the same problem? Tom Lane 15:13

April 22, 2002

Thread Author Time
Identity not disvoered by planner? Daniel Lundin 11:34
Is this a BUG? Is there anyone has the same problem? jack 11:36
Re: Is this a BUG? Is there anyone has the same problem? Tom Lane 16:35
Re: Is this a BUG? Is there anyone has the same problem? David Stanaway 17:36
Re: Is this a BUG? Is there anyone has the same problem? Tom Lane 17:47
efficient query help Laurette Cisneros 18:10
calling a pl/pgsql function with array in argument Ruben Vivas 20:05
Re: efficient query help Clinton Adams 21:23

April 23, 2002

Thread Author Time
How to discover foreign keys (without pulling hair out) Ian Morgan 06:54
Cannot get to use index scan on a big table! Rajesh Kumar Mallah 07:48
Date indexing Ian Cass 09:35
Re: Date indexing Dima Tkach 12:56
Re: Date indexing Tom Lane 13:56
Re: Date indexing Ian Cass 14:03
Re: Date indexing Ian Cass 14:07
Re: Cannot get to use index scan on a big table! Stephan Szabo 15:01
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 16:15
Re: call the same pl/pgsql procedure twice in the same connection Jan Wieck 16:31

April 24, 2002

Thread Author Time
Re: call the same pl/pgsql procedure twice in the same connection Bruce Momjian 00:36
Re: Upgrading PostgreSQL to 7.1.3 Rajesh Kumar Mallah 05:30
Re: Cannot get to use index scan on a big table! Rajesh Kumar Mallah 05:57
Proper quoting of \e Helge Kreutzmann 13:12
BLOB Feature Limits Bullock, Dempsey 14:04
Re: efficient query help Joel Burton 14:06
Re: efficient query help Joel Burton 14:47
Re: BLOB Feature Limits Ian Morgan 18:10
Connection authentication Oleg Lebedev 19:32

April 25, 2002

Thread Author Time
Pl/pgSQL Question. Bruno Ricardo Sacco 04:34
Pl/pgSQL Question. Bruno Ricardo Sacco 04:44
SELECT in a function != SELECT ? Ian Morgan 05:44
Re: SELECT in a function != SELECT ? Joe Conway 06:13
Database Server in Recovery mode! Rajesh Kumar Mallah 06:52

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