pgsql-sql - October 2001

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

Oct. 1, 2001

Thread Author Time
PostgreSQL downloads Miguel González 17:37
strange query execution times Markus Bertheau 17:52
Re: PostgreSQL downloads Philip Hallstrom 18:08
7.0.3 and 7.1.3 different results? Joel Mc Graw 21:14

Oct. 2, 2001

Thread Author Time
Re: On Differing Optimizer Choices ( Again) Oleg Lebedev 00:45
Re: Calling Functions 📎 Josh Berkus 04:16
using SQL to evaluate arbitrary expressions? Markus Wagner 04:32
Re: using SQL to evaluate arbitrary expressions? Tom Lane 05:07
Stupid Question Rebekah Kirk 09:55
Re: Stupid Question Nils Zonneveld 10:30
Question about indexing! 11:45
Re: 7.0.3 and 7.1.3 different results? Tom Lane 14:56
Re: faster and faster!! Tom Lane 15:37
Re: Stupid Question Devrim GUNDUZ 15:40
Re: strange query execution times Tom Lane 15:49
aggregate functions, COUNT Kevin Way 16:11
Re: Question about indexing! Stephan Szabo 16:32
Re: aggregate functions, COUNT Stephan Szabo 16:47
Indexing behavior Josh Berkus 16:47
Re: aggregate functions, COUNT Tom Lane 17:59
Re: Question about indexing! 19:09
jdbc driver Esteban Gutierrez Abarzua 23:42

Oct. 3, 2001

Thread Author Time
Re: jdbc driver Barry Lind 01:18
Re: aggregate functions, COUNT Kevin Way 02:54
[No subject] postgresql 13:55
ORDER BY case insensitive? Bob Swerdlow 14:06
Re: ORDER BY case insensitive? Jeff Boes 14:17
Re: 7.0.3 and 7.1.3 different results? 📎 Josh Berkus 14:48
Re: Question about indexing! Stephan Szabo 15:28
Re: 7.0.3 and 7.1.3 different results? Stephan Szabo 15:36
select 5/2??? guard 17:04
Re: 7.0.3 and 7.1.3 different results? Josh Berkus 17:07
challenging query Chris Ruffin 17:33
to_date/to timestamp going to BC jason.servetar 20:22
Re: to_date/to timestamp going to BC Tom Lane 21:14
Re: to_date/to timestamp going to BC jason.servetar 21:36

Oct. 4, 2001

Thread Author Time
Re: select 5/2??? Lee Harr 00:23
SubQuery cnliou 01:06
EXISTS Keyword cnliou 01:18
Re: SubQuery Stephan Szabo 01:24
Re: EXISTS Keyword Bruce Momjian 01:59
maximum parameters limit to function & manipulating array in plpgsql Advid@newgen 03:47
Re: to_date/to timestamp going to BC Karel Zak 08:41
Re: Christopher Sawtell 12:46
Re: Need Help!! Heather Johnson 14:17
SQL Syntax / Logic question Michael D. Harlan 14:27
Re: to_date/to timestamp going to BC 📎 Josh Berkus 14:44
Re: maximum parameters limit to function & manipulating array in plpgsql 📎 Josh Berkus 14:51
Re: to_date/to timestamp going to BC Karel Zak 14:56
Re: SQL Syntax / Logic question 📎 Josh Berkus 15:02
Why the weak key is created as unique Marat Khairullin 15:08
temporary views Tomasz Myrta 15:51
Beginner's List 📎 Josh Berkus 16:09
Re: Beginner's List Stephan Szabo 16:37
Re: temporary views Bruce Momjian 17:43
Re: Simple Query HELP!!! Paolo Colonnello 18:16
Re: Beginner's List Tom Lane 19:21
Re: ORDER BY case insensitive? Jason Earl 19:47
Re: to_date/to timestamp going to BC jason.servetar 19:59
Re: how can i return multiple values from a function Allan Engelhardt 20:30
Re: Function return rows? Allan Engelhardt 20:33
Re: ORDER BY case insensitive? Bob Swerdlow 20:55
Why the weak key is created as unique Marat Khairullin 21:02
Re: ORDER BY case insensitive? Jason Earl 21:22
Re: ORDER BY case insensitive? Stephan Szabo 22:20
Re: Need Help!! Ross J. Reedstrom 22:33
SQL CONSTRAINTS - Constraining time values from two attributes on a table. Maher, Christopher W 22:53
Alias Join Table Keith Gray 23:47
Re: Beginner's List Keith Gray 23:50
Re: ORDER BY case insensitive? Keith Gray 23:56

Oct. 5, 2001

Thread Author Time
Re: ORDER BY case insensitive? Tom Lane 00:32
Re: Indexing behavior Ross J. Reedstrom 00:49
Re: Alias Join Table Josh Berkus 01:01
Re: strange query execution times Markus Bertheau 06:48
Problem with n to n relation Janning Vygen 10:39
getting OID from PL/PgSQL AFTER trigger Vladimir Vukicevic 11:06
Re: challenging query Haller Christoph 11:48
Re: Problem with n to n relation Morgan Curley 12:30
COPY COMMAND -- Hanging Bhuvan A 12:59
COPY COMMAND -- Hanging Bhuvan A 13:28
SQL-Programmer tool and field%type support Mourad EL HADJ MIMOUNE 13:37
Re: Need Help!! Papp Gyozo 13:42
Re: temporary views Tomasz Myrta 15:17
Re: challenging query Haller Christoph 17:03
Re: [SQL] Why the weak key is created as unique Stephan Szabo 18:49
sql + C Esteban Gutierrez Abarzua 19:45
Re: SQL CONSTRAINTS - Constraining time values from two attributes on a table. 📎 Josh Berkus 20:31
Re: temporary views Bruce Momjian 20:42
Re: temporary views Alex Pilosov 21:01
Re: SQL CONSTRAINTS - Constraining time values from two Peter Eisentraut 21:12
Quotes and spaces Oleg Lebedev 22:28
Re: Quotes and spaces 📎 Josh Berkus 22:51
Re: SQL CONSTRAINTS - Constraining time values from two attributes on Lee Harr 23:01
Re: Quotes and spaces Stephan Szabo 23:31
Re: Quotes and spaces Oleg Lebedev 23:54

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

Browse Archives

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