pgsql-sql since 2001-10-06 00:00

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Oct. 6, 2001

Thread Author Time
Re: challenging query Masaru Sugawara 09:54

Oct. 7, 2001

Thread Author Time
Re: temporary views Peter Eisentraut 17:54

Oct. 8, 2001

Thread Author Time
PlPerl Aasmund Midttun Godal 00:48
Re: PlPerl Alex Pilosov 02:49
Re: temporary views Tom Lane 02:53
Re: temporary views Bruce Momjian 03:23
Re: Problem with n to n relation Janning Vygen 08:30
Re: temporary views Tomasz Myrta 08:37
How to Return Unique Elements From An Array? Bhuvan A 08:46
Re: select 5/2??? BELLON Michel 09:31
Re: select 5/2??? Christopher Sawtell 10:39
Re: select 5/2??? Szabo Zoltan 10:40
Re: sql + C Haller Christoph 11:12
Re: select 5/2??? BELLON Michel 11:23
Re: SQL Syntax / Logic question Thurstan R. McDougle 12:36
PEAR Problem Gurudutt 12:37
Search by longitude/latitude Chris Ruprecht 12:58
Re: Search by longitude/latitude 📎 James Orr 13:42
Re: Search by longitude/latitude Colin 't Hart 14:13
Re: Search by longitude/latitude 📎 Joe Conway 15:33
Re: temporary views Bruce Momjian 16:05
Re: Problem with n to n relation Stephan Szabo 16:09
Re: How to Return Unique Elements From An Array? Haller Christoph 16:45
Re: Problem with n to n relation Janning Vygen 17:17
Re: Problem with n to n relation Stephan Szabo 17:33
Re: SQL-Programmer tool and field%type support Roberto Mello 18:09
Re: PEAR Problem Papp Gyozo 22:14
Re: SQL-Programmer tool and field%type support Josh Berkus 23:08

Oct. 9, 2001

Thread Author Time
ROUND function ?? Saurabh Mittal 03:45
Re: PEAR Problem Dan Wilson 04:04
Re: SQL-Programmer tool and field%type support Tom Lane 04:34
Re: ROUND function ?? Tom Lane 04:42
Re: ROUND function ?? Joe Conway 05:03
Re: Problem with n to n relation Janning Vygen 07:42
Re: Linking against null-fields. david 12:21
Linking against null-fields. Alexander Deruwe 13:24
Loading current_user and current_timestamp using COPY Herb Blacker 15:09
Re: Problem with n to n relation Stephan Szabo 15:38
Re: Problem with n to n relation Janning Vygen 15:55
Re: Linking against null-fields. Stephan Szabo 16:31
Re: Loading current_user and current_timestamp using COPY Josh Berkus 21:33
Re: Loading current_user and current_timestamp using COPY Josh Berkus 21:35
Re: ROUND function ?? Allan Engelhardt 23:16

Oct. 10, 2001

Thread Author Time
Why would this slow the query down so much? Stuart Grimshaw 12:35
SELECT FOR UPDATE CLAUSE Gerardo Perosio 13:06
Restricting access to Large objects Aasmund Midttun Godal 19:23
Restricting access to Large objects Aasmund Midttun Godal 20:18
VACUUM VERBOSE ANALYZE locking up?? Please help! Wilkinson Charlie E 20:46
Restricting access to large objects. Aasmund Midttun Godal 21:07
VARCHAR vs TEXT Aasmund Midttun Godal 23:32

Oct. 11, 2001

Thread Author Time
Re: VARCHAR vs TEXT Stephan Szabo 00:18
Re: [NOVICE] Loading current_user and current_timestamp using COPY 📎 Josh Berkus 04:20
Re: [NOVICE] Loading current_user and current_timestamp using COPY Tom Lane 05:11
BIGINT's and indexes. Alexander Deruwe 10:48
indexing and LIKE Patrik Kudo 12:28
SQL reference card Bob Vloon 15:43
Re: indexing and LIKE Stephan Szabo 20:01
Re: indexing and LIKE Ross J. Reedstrom 20:05
Re: indexing and LIKE Allan Engelhardt 20:22
count(*) and limit Orion 20:31
Re: Server crash caused by CHECK on child Bruce Momjian 20:38

Oct. 12, 2001

Thread Author Time
Re: indexing and LIKE Patrik Kudo 08:16
problem w/plpgsql proc leo 16:05
Re: indexing and LIKE Tom Lane 17:32
Re: indexing and LIKE Stephan Szabo 18:17
MEDIAN as custom aggregate? Josh Berkus 19:38
Indexes Aasmund Midttun Godal 20:37
Re: MEDIAN as custom aggregate? Allan Engelhardt 21:34
Re: MEDIAN as custom aggregate? Josh Berkus 22:08

Oct. 13, 2001

Thread Author Time
GROUPING Timothy J Hitchens 01:15
DROP VIEWS Oleg Lebedev 01:57
Re: DROP VIEWS Stephan Szabo 02:31
Re: Indexes Stephan Szabo 02:33
Re: VARCHAR vs TEXT Bruce Momjian 03:54
Re: GROUPING Stephan Szabo 05:26
Re: MEDIAN as custom aggregate? Tom Lane 05:31
Cenceptual help needed - periodic events Pat M 12:55
Re: Indexes Aasmund Midttun Godal 14:57
Re: MEDIAN as custom aggregate? Masaru Sugawara 15:19
Re: GROUPING Lee Harr 21:51

Oct. 14, 2001

Thread Author Time
Ordering by field using lower() speedboy 03:45
to_char()?? guard 04:07
Re: Ordering by field using lower() Tom Lane 05:16
referencial conlumn contraints and inheritance Stuart 11:28
Re: GROUPING Joel Burton 15:34
Re: referencial conlumn contraints and inheritance 📎 Josh Berkus 18:54
Re: to_char()?? Lee Harr 21:37
Re: referencial conlumn contraints and inheritance Stephan Szabo 23:08

Oct. 15, 2001

Thread Author Time
Re: to_char()?? guard 01:56
Re: to_char()?? Szabo Zoltan 14:05
Re: Why would this slow the query down so much? Tom Lane 15:12
Re: SQL reference card 📎 Josh Berkus 15:13
Re: problem w/plpgsql proc 📎 Josh Berkus 15:20
Re: problem w/plpgsql proc Tom Lane 15:20
system maintained keys Stefan Lindner 15:43
Re: VARCHAR vs TEXT Vivek Khera 16:03
Re: problem w/plpgsql proc Aasmund Midttun Godal 16:06
Re: Why would this slow the query down so much? Josh Berkus 16:55
index problem Szabo Zoltan 19:41
EXECUTE ... INTO? Josh Berkus 19:41
Re: to_char()?? Works for me. Christopher Sawtell 19:45
When will vacuum go away? Michael Richards 22:29
Re: MEDIAN as custom aggregate? Josh Berkus 22:44

Oct. 16, 2001

Thread Author Time
Re: Cenceptual help needed - periodic events Josh Berkus 00:12
Re: to_char()?? Ross J. Reedstrom 00:34
Re: to_char()?? Lee Harr 00:42
Text/Image, JSP tomcat. How can I operate the text and image type field in Postgresql? only in java/jsp Frank Zhu 03:41
Re: VARCHAR vs TEXT Frank Zhu 04:22
Re: When will vacuum go away? Tom Lane 04:57
Re: EXECUTE ... INTO? Oliver Elphick 08:37
Re: problem w/plpgsql proc Henshall, Stuart - WCP 10:57
Why are ftp mirrors out of sync? bpalmer 11:42
Triggers do not fire Reiner Dassing 12:48
Re: VARCHAR vs TEXT Bruce Momjian 12:56
Re: Why are ftp mirrors out of sync? Tom Lane 14:03
Re: Why are ftp mirrors out of sync? Vince Vielhaber 14:07
Re: VARCHAR vs TEXT Vivek Khera 14:08
Re: VARCHAR vs TEXT Frank Bax 15:46
Re: VARCHAR vs TEXT Bruce Momjian 15:55
Re: index problem Szabo Zoltan 15:57
Deleting obsolete values Haller Christoph 16:45
Re: Why would this slow the query down so much? Stuart Grimshaw 16:58
Multiple Parameters to an Aggregate Function Anthony Bouvier 18:23
Re: Triggers do not fire Aasmund Midttun Godal 19:43
Re: Triggers do not fire Stephan Szabo 20:02
Re: index problem Stephan Szabo 20:05
Re: VARCHAR vs TEXT Peter Eisentraut 20:13
Re: Restricting access to Large objects Christopher Sawtell 21:04
Re: index problem CoL 21:08
Re: Triggers do not fire Tom Lane 21:36
Re: index problem Stephan Szabo 22:56

Oct. 17, 2001

Thread Author Time
Re: Why are ftp mirrors out of sync? Marc G. Fournier 00:27
Variables. Aasmund Midttun Godal 01:00
nvl() function Steven Dahlin 03:10
Performance problems - Indexes and VACUUM 📎 Josh Berkus 03:29
Re: Restricting access to Large objects Tom Lane 03:56
Re: nvl() function Andre Schnabel 06:11
Re: Performance problems - Indexes and VACUUM Kusuma 06:48
Re: referencial conlumn contraints and inheritance Stuart 13:04
Re: Why would this slow the query down so much? Masaru Sugawara 14:21
Re: Performance problems - Indexes and VACUUM Tom Lane 14:30
Re: Performance problems - Indexes and VACUUM 📎 Josh Berkus 15:21
Re: Triggers do not fire Reiner Dassing 15:29
Re: Performance problems - Indexes and VACUUM Tom Lane 15:31
Re: Triggers do not fire Tom Lane 15:34
Re: Performance problems - Indexes and VACUUM 📎 Josh Berkus 15:40
Re: Variables. 📎 Josh Berkus 15:44
Identifying obsolete values Haller Christoph 17:17
update in rule Nicolas KOWALSKI 17:24
Re: index problem Stephan Szabo 17:47
Re: Multiple Parameters to an Aggregate Function Joel Burton 17:51
Re: nvl() function Joel Burton 17:53
Re: Triggers do not fire Jason Earl 18:20
Re: update in rule Stephan Szabo 19:04
SQL parser and/or optimizer Oleg Lebedev 22:32

Oct. 18, 2001

Thread Author Time
Re: Indexes on functions Michael Richards 01:52
Re: Deleting obsolete values Henshall, Stuart - WCP 13:28
Re: Text/Image, JSP tomcat. How can I operate the text and image Henshall, Stuart - WCP 13:40
Replication Hunter, Ray 14:59
Doing a regexp-based search/replace? Steve Frampton 16:03
Re: Replication Josh Berkus 17:12
Privileges on Functions in Postgres 7.1.3 Sushil Kumar 17:14
Re: Replication clayton cottingham 17:33
Re: update in rule Dmitry Morozovsky 17:49
Re: Doing a regexp-based search/replace? Brett Schwarz 18:30
Re: Doing a regexp-based search/replace? Tom Lane 18:52
Re: update in rule Stephan Szabo 19:14
Re: Doing a regexp-based search/replace? Stephan Szabo 19:25
COUNT func Oleg Lebedev 19:37
Granting database level permissions... Thomas Swan 19:45
Re: [ADMIN] update in rule Oleg Lebedev 20:40
Re: Doing a regexp-based search/replace? Josh Berkus 22:09
Re: COUNT func Stephan Szabo 22:39
Re: COUNT func Oleg Lebedev 23:04

Oct. 19, 2001

Thread Author Time
index question Joseph Shraibman 00:25
Re: When will vacuum go away? Joseph Shraibman 01:25
Re: When will vacuum go away? Tom Lane 01:30
Re: index question Tom Lane 01:39
Diferent databases on same query... Douglas Rafael da Silva 01:45
Access to functions Aasmund Midttun Godal 01:51
Table Constraints with NULL values David Allardyce 02:56
oid's in views. Aasmund Midttun Godal 03:01
Need a VIEW without SUB-SELECT Bhuvan A 06:01
Re: COUNT func Bhuvan A 06:20
Re: Table Constraints with NULL values Tom Lane 06:53
Re: Need a VIEW without SUB-SELECT Aasmund Midttun Godal 07:42
Can't postgres join tables on varchar fields ? <EOM> Gurudutt 08:09
Re: Granting database level permissions... Steve Brett 08:32
Re: Deleting obsolete values Pat M 12:56
Re: oid's in views. 📎 Josh Berkus 15:07
Re: system maintained keys Josh Berkus 17:46
Re: system maintained keys Jason Earl 18:57
Re: Diferent databases on same query... Andre Schnabel 19:05
Re: oid's in views. Aasmund Midttun Godal 19:10
Re: system maintained keys Joel Burton 20:34
Re: oid's in views. Josh Berkus 22:38
Re: Diferent databases on same query... chrup 22:53

Oct. 20, 2001

Thread Author Time
Re: Table Constraints with NULL values David Allardyce 02:14
Re: Table Constraints with NULL values Tom Lane 03:51
Re: oid's in views. Aasmund Midttun Godal 11:15

Browse Archives

Prev | Next