pgsql-sql - May 2003

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

May 1, 2003

Thread Author Time
Re: [SQL] 7.3 analyze & vacuum analyze problem Tom Lane 00:10
Re: [SQL] 7.3 analyze & vacuum analyze problem Christopher Kings-Lynne 01:51
Re: PERFORM / FOUND, what's up? Tom Lane 01:53
Re: Stored Procedure Question Roberto Mello 02:16
How to write an query to get this result? Daniel Dunajsky 03:07
How to write a sql query to get this result? Daniel 03:31
Date Problem Ramesh PAtel 06:36
Re: How to write a sql query to get this result? Tomasz Myrta 06:40
Re: Date Problem Rajesh Kumar Mallah 08:51
Re: Date Problem Stuart 09:38
date use in for loop Ramesh PAtel 11:30
Re: How to write a sql query to get this result? Bruno Wolff III 12:38
Re: date use in for loop Josh Berkus 17:04

May 2, 2003

Thread Author Time
implied FROM Matt Mello 02:06
Re: differences between oracle,pgsql,sybase A.Bhuvaneswaran 04:45
Re: differences between oracle,pgsql,sybase Oliver Elphick 06:16
Re: implied FROM Tomasz Myrta 07:14
It's About field type array Yudha [ Inas_Husband ] Setiawan 08:22
Re: How to write an query to get this result? Richard Huxton 08:48
Re: Problem with old relation Andreas Schmitz 12:08
Problem with old relation Rado Petrik 12:20
Re: Problem with old relation A.Bhuvaneswaran 12:54
timeofday() and now() issue.. Rajesh Kumar Mallah 13:14
What is bad in this query ? Rado Petrik 13:21
Re: implied FROM Matt Mello 13:44
Re: What is bad in this query ? Rod Taylor 14:32
Re: timeofday() and now() issue.. Tom Lane 14:57
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 15:07
Re: timeofday() and now() issue.. Tom Lane 15:16
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 15:36
Re: implied FROM Bruno Wolff III 16:04
Re: implied FROM Josh Berkus 16:13
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 16:29
Re: implied FROM Stephan Szabo 16:33
Re: [SQL] 7.3 analyze & vacuum analyze problem Achilleus Mantzios 19:03
Re: What is bad in this query ? Achilleus Mantzios 19:07
Re: What is bad in this query ? Chris Gamache 20:46
How to increase precision? Katka a Daniel Dunajsky 21:38
Best way to delete time stamped data? Kyle 22:06
Re: How to increase precision? Steve Crawford 22:13
Re: How to increase precision? Josh Berkus 22:32
Time formating Katka a Daniel Dunajsky 22:33
Re: How to increase precision? Stephan Szabo 22:42
Re: Best way to delete time stamped data? Steve Crawford 22:51
Re: Time formating Stephan Szabo 23:11
Re: Best way to delete time stamped data? Josh Berkus 23:19

May 3, 2003

Thread Author Time
Re: timeofday() and now() issue.. A.Bhuvaneswaran 05:13
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 07:32
problem with max and not using index on PK pginfo 09:12
Re: problem with max and not using index on PK Philip Warner 12:04
Re: problem with max and not using index on PK pginfo 12:36

May 4, 2003

Thread Author Time
Re: timeofday() and now() issue.. Rajesh Kumar Mallah 10:47
Re: [SQL] Best way to delete time stamped data? Kyle 13:09
Re: [SQL] Best way to delete time stamped data? Jim C. Nasby 16:30
Re: [SQL] Best way to delete time stamped data? Jean-Luc Lachance 17:12

May 5, 2003

Thread Author Time
Re: Best way to delete time stamped data? Rajesh Kumar Mallah 09:56
Indices are not used by the optimizer Reiner Dassing 12:16
Re: Best way to delete time stamped data? Bruno Wolff III 13:32
Re: Indices are not used by the optimizer Rod Taylor 13:33
UNICODE and SQL Marco Roda 13:34
Re: UNICODE and SQL Ian Barwick 14:37
Re: Replication for a large database Ryan 16:16
Re: UNICODE and SQL Ian Barwick 16:48
Replication for a large database Michael A Nachbaur 16:52
Re: [SQL] Indices are not used by the optimizer Achilleus Mantzios 18:38
mnogosearch examples Alex Rice 18:59
2 simple SQL questions: optimizing aggegate query Alex Rice 18:59
Re: Replication for a large database Michael Teter 19:19
Re: UNICODE and SQL Achilleus Mantzios 19:22
Re: Replication for a large database Michael A Nachbaur 19:26
Re: Replication for a large database Michael A Nachbaur 19:28
Re: 2 simple SQL questions: optimizing aggegate query Bruno Wolff III 19:45
pgsql Replication Proxy (was Re: Replication for a large database) Michael A Nachbaur 19:57
Re: 2 simple SQL questions: optimizing aggegate query Alex Rice 20:03
Re: UNICODE and SQL Achilleus Mantzios 20:24
Re: Replication for a large database Jeff Eckermann 22:39

May 6, 2003

Thread Author Time
Re: 2 simple SQL questions: optimizing aggegate query Bruno Wolff III 01:28
Re: mnogosearch examples Rajesh Kumar Mallah 06:37
Cast type int2vector/array_field to character Mr.F 08:04
Re: UNICODE and SQL Marco Roda 09:05
Problem with Attribute. Rado Petrik 09:17
Re: Problem with Attribute. Popeanga Marian 09:50
Re: Problem with Attribute. Victor Yegorov 09:55
pg_ ? Popeanga Marian 12:02
VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 SZŰCS Gábor 12:22
Re: pg_ ? Rajesh Kumar Mallah 12:59
Re: pg_ ? A.Bhuvaneswaran 13:22
Re: pg_ ? A.Bhuvaneswaran 13:36
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 SZUCS Gabor 13:52
Re: Cast type int2vector/array_field to character Achilleus Mantzios 13:56
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Stephan Szabo 14:32
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Tom Lane 14:35
Re: Problem with Attribute. Achilleus Mantzios 15:01
pg_stat_activity IP address alexandre :: aldeia digital 15:55
UNIQUE boolean: only one row may be "true" Randall Lucas 16:01
Re: pgsql Replication Proxy (was Re: Replication for a Diehl, Jeffrey 16:28
Re: UNIQUE boolean: only one row may be "true" Michael Teter 17:13
Re: UNIQUE boolean: only one row may be "true" Bruno Wolff III 17:23
Re: UNIQUE boolean: only one row may be "true" chester c young 17:26
Re: pgsql Replication Proxy (was Re: Replication for a Michael A Nachbaur 17:40
Re: pgsql Replication Proxy (was Re: Replication for a Diehl, Jeffrey 17:45
Re: pg_ ? Achilleus Mantzios 17:48
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Achilleus Mantzios 17:53
Re: pgsql Replication Proxy (was Re: Replication for a Mendola Gaetano 17:54
Re: pgsql Replication Proxy (was Re: Replication for a Michael A Nachbaur 18:16
Utils/case for create relation db under Linux Rado Petrik 18:24
Re: UNIQUE boolean: only one row may be "true" Randall Lucas 18:46
Re: pg_ ? Achilleus Mantzios 18:46
Re: pgsql Replication Proxy (was Re: Replication for a Wei Weng 19:10
Re: 2 simple SQL questions: optimizing aggegate query Alex Rice 19:28
Re: VACUUM FULL and ALTER TABLE do *nothing* in 7.3.2 Achilleus Mantzios 19:32
Re: pgsql Replication Proxy (was Re: Replication for a Michael A Nachbaur 20:01
Date Anomaly?? Thomas Good 20:05
Re: pgsql Replication Proxy (was Re: Replication for a Steve Crawford 20:42
Re: Date Anomaly?? Ian Barwick 21:19
"deadlock detected" documentation Matt Mello 21:48

May 7, 2003

Thread Author Time
Re: UNIQUE boolean: only one row may be "true" Tom Lane 03:00
Re: "deadlock detected" documentation Tom Lane 04:46
Re: "deadlock detected" documentation A.Bhuvaneswaran 04:58
Re: UNIQUE boolean: only one row may be "true" Ries van Twisk 07:34
SQl query Abdul Wahab Dahalan 08:20
Re: SQl query Matthew Horoschun 08:34
Re: SQl query Victor Yegorov 08:57
Re: SQl query DIB Walid 09:00
Re: SQl query A.Bhuvaneswaran 09:21
Re: pgsql Replication Proxy (was Re: Replication for a Mendola Gaetano 09:26
Re: pg_ ? Popeanga Marian 11:35
Re: Date Anomaly?? Thomas Good 13:14
Re: An unresolved performance problem. Hannu Krosing 13:40
Re: Date Anomaly?? Tom Lane 14:31
index fragmentation Wei Weng 14:47
ERROR: pg_atoi: error in "NULL": can't parse "NULL" Rado Petrik 14:57
Re: Date Anomaly?? Thomas Good 15:04
array in a reference Ries van Twisk 15:07
Re: An unresolved performance problem. Josh Berkus 15:26
Re: [SQL] An unresolved performance problem. Mendola Gaetano 15:36
Re: Date Anomaly?? Josh Berkus 15:36
Re: ERROR:Â pg_atoi: error in "NULL": can't parse "NULL" Josh Berkus 15:37
Re: Date Anomaly?? Bruno Wolff III 15:39
Re: An unresolved performance problem. scott.marlowe 15:42
Re: ERROR:   pg_atoi: error in "NULL": can't Jean-Luc Lachance 15:47
Re: Date Anomaly?? Stephan Szabo 15:52
Re: array in a reference Stephan Szabo 15:53
help database corruption mdc 15:56
Re: Date Anomaly?? Thomas Good 16:02
Re: Date Anomaly?? Tom Lane 16:13
An unresolved performance problem. Achilleus Mantzios 16:33
PostgreSQL Qs Jon Earle 16:35
index defragmentation Wei Weng 16:47
Re: Unanswered Questions WAS: An unresolved performance problem. Josh Berkus 16:57
Re: index defragmentation D'Arcy J.M. Cain 17:17
Re: index defragmentation Josh Berkus 17:21
Re: index defragmentation Richard Huxton 17:21
Re: PostgreSQL Qs Richard Huxton 17:32
"too clever" when creating SQL functions SZŰCS Gábor 17:51
Re: [GENERAL] PostgreSQL Qs mallah 18:01
help database corruption mdc 18:12
help database corruption mdc 18:12
Re: PostgreSQL Qs Jonathan Bartlett 18:16
Re: [GENERAL] PostgreSQL Qs Jon Earle 18:33
Re: An unresolved performance problem. Manfred Koizar 18:42
Re: help database corruption Wei Weng 18:57
Re: An unresolved performance problem. Achilleus Mantzios 19:09
Re: "too clever" when creating SQL functions Richard Huxton 19:10
Re: help database corruption Stephan Szabo 19:16
[No subject] mdc 19:34
Re: [SQL] An unresolved performance problem. Bernd von den Brincken 19:57
Re: PostgreSQL Qs Karsten Hilbert 20:02
Re: PostgreSQL Qs Oliver Elphick 20:03
Re: Stephan Szabo 20:14
Re: PostgreSQL Qs Jon Earle 20:19
Re: PostgreSQL Qs Oliver Elphick 21:40
Re: [GENERAL] PostgreSQL Qs Robert Treat 21:44
PROBLEM WITH UPDATE COMMAND Mario Alberto Soto Cordones 23:21
Re: [SQL] Unanswered Questions WAS: An unresolved performance problem. Randall Lucas 23:52

May 8, 2003

Thread Author Time
Type coercion on column in a query Kenny Mok 00:59
Re: Replication for a large database The Hermit Hacker 01:28
insert rowtype Bryan Klimt 02:23
Timestamp index not used david 03:56
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. Tom Lane 04:13
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. Sean Chittenden 04:57
Re: Timestamp index not used Tom Lane 05:26
seeing type defination.. Rajesh Kumar Mallah 06:15
A minute in timestamp David Loh 06:40
Re: A minute in timestamp Richard Huxton 07:24
Re: A minute in timestamp Victor Yegorov 07:50
Array dimension as integer 📎 Victor Yegorov 09:57
Re: "too clever" when creating SQL functions SZŰCS Gábor 11:15
Re: An unresolved performance problem. Andrew Sullivan 11:20
Re: [SQL] An unresolved performance problem. Achilleus Mantzios 12:09
Re: An unresolved performance problem. Achilleus Mantzios 12:48
Re: PostgreSQL Qs Bruno Wolff III 13:22
insert rowtype Bryan Klimt 13:58
Re: seeing type defination.. Tom Lane 14:14
Re: PostgreSQL Qs Jon Earle 14:18
Re: An unresolved performance problem. Tom Lane 14:42
Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. johnnnnnn 14:47
Re: "too clever" when creating SQL functions Stephan Szabo 14:53
Re: seeing type defination.. mallah 15:02
Calculating Percentages David Siegal 15:02

Browse Archives

Prev | Next