pgsql-sql since 2001-09-21 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

Sept. 21, 2001

Thread Author Time
Re: getting some tech skills? Andy Hibbins 00:22
LEFT OUTER JOIN problem Ludek Finstrle 13:32
select is fast, update based on same where clause is slow Jeff Barrett 14:44
Re: select is fast, update based on same where clause is slow Stephan Szabo 15:34
Re: select is fast, update based on same where clause is slow Josh Berkus 16:21
Re: select is fast, update based on same where clause is slow Jeff Barrett 16:27
Re: Selecting latest value II Thurstan R. McDougle 16:31
Re: Q on "Re: select is fast, update based on same where clause is slow " Josh Berkus 23:53

Sept. 22, 2001

Thread Author Time
more information on JOINs postgresql 12:11
Re: more information on JOINs Francesco Casadei 15:40
Re: more information on JOINs postgresql 16:00
Re: more information on JOINs Stephan Szabo 16:49

Sept. 23, 2001

Thread Author Time
Simple Query HELP!!! Paolo Colonnello 02:18
Re: Simple Query HELP!!! Bob Barrows 03:12
confounding, incorrect constraint error Kevin Way 07:09
Re: Simple Query HELP!!! Paolo Colonnello 17:49
Re: confounding, incorrect constraint error Kevin Way 20:54
Request for book reviews/comments 📎 Josh Berkus 21:14
Bug?: Update on ancestor for a row of a child Kovacs Baldvin 23:55

Sept. 24, 2001

Thread Author Time
outer joins strangeness Alex Pilosov 01:29
problem loading array Frederick Klauschen 02:41
Re: Bug?: Update on ancestor for a row of a child Kevin Way 02:51
loading array_iterator.so does not work with Postgresql 7.0.3/7.1.3 Frederick Klauschen 02:55
How to enter lists into database. Frederick Klauschen 03:01
Re: Simple Query HELP!!! --CELKO-- 03:49
Re: outer joins strangeness Stephan Szabo 04:57
Re: [SQL] outer joins strangeness Alex Pilosov 05:09
Re: loading array_iterator.so does not work with Postgresql Oleg Bartunov 05:54
Server crash caused by CHECK on child Kovacs Baldvin 08:01
How to get BLOB size? Oleg Olenin 09:08
Problem in connection using .odbc.ini meghana mande 09:27
Re: Server crash caused by CHECK on child Kevin Way 11:42
Re: How to enter lists into database. 📎 Josh Berkus 15:07
Re: Request for book reviews/comments 📎 Josh Berkus 15:08
Re: Bug?: Update on ancestor for a row of a child 📎 Josh Berkus 15:11
Re: [SQL] outer joins strangeness Stephan Szabo 16:07
Re: Server crash caused by CHECK on child Stephan Szabo 16:09
Re: How to enter lists into database:Example. 📎 Josh Berkus 16:10
Re: Bug?: Update on ancestor for a row of a child Kevin Way 16:11
Re: [HACKERS] Server crash caused by CHECK on child Kevin Way 16:18
Re: How to enter lists into database. Oleg Bartunov 16:27
Re: [SQL] outer joins strangeness Alex Pilosov 17:00
Re: confounding, incorrect constraint error Jan Wieck 18:12
CHECK problem really OK now... Kovacs Baldvin 18:38
Re: CHECK problem really OK now... Josh Berkus 19:18
Re: CHECK problem really OK now... Jan Wieck 19:23
[HACKERS] not on .hackers August Zajonc 20:38
Re: [HACKERS] not on .hackers Colin 't Hart 20:51

Sept. 25, 2001

Thread Author Time
explain command Esteban Gutierrez Abarzua 00:09
Re: getting some tech skills? Jimi Thompson 03:43
Re: [SQL] outer joins strangeness Tom Lane 04:19
Re: CHECK problem really OK now... Roberto Mello 04:49
Re: Request for book reviews/comments Rick Robino 06:52
HP-UX 11.0 postgres compile error! Youn-Oh, Jung 07:32
A bug in triggers PG 7.1.3 or misunderstand ? Domingo Alvarez Duarte 08:34
TEXT in select Michael Remme 09:25
how can i return multiple values from a function srinivas 11:35
Re: [HACKERS] not on .hackers Tony Reina 18:59

Sept. 26, 2001

Thread Author Time
PgAdmin Keith Gray 00:40
A simple join question that may stump you Ross Smith 03:01
Re: PgAdmin 📎 Josh Berkus 04:27
Re: A simple join question that may stump you A. Prins 08:11
Re: A simple join question that may stump you Thurstan R. McDougle 12:26
Subquery with IN or EXISTS A. Mannisto 14:24
is it possible to get the number of rows of a table? Frederick Klauschen 15:14
Re: is it possible to get the number of rows of a table? Wei Weng 16:56
Re: plpgsql function case statement Masaru Sugawara 17:27
Re: How to enter lists into database: Problems with solution. Josh Berkus 17:40
Re: [SQL] CHECK problem really OK now... Tom Lane 18:36
Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. Frederick Klauschen 18:45
Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. Josh Berkus 19:09
PARSER ERROR Frederick Klauschen 20:24
Re: Query does not work: parse ERROR, Re: How to enter lists into database: Problems with solution. Carl van Tast 22:21
Aggregate Aggravation Robin's PG-SQL List 22:43
Re: Subquery with IN or EXISTS Carl van Tast 22:45

Sept. 27, 2001

Thread Author Time
Re: is it possible to get the number of rows of a table? Haller Christoph 09:17
Re: Subquery with IN or EXISTS A. Mannisto 09:49
How to get BLOB length? Oleg Olenin 10:04
PARSER ERROR persists .... Frederick Klauschen 15:19
Re: HP-UX 11.0 postgres compile error! Tom Lane 15:26
Re: A simple join question that may stump you 📎 Josh Berkus 15:32
Re: PARSER ERROR persists .... Tom Lane 16:25
Re: A bug in triggers PG 7.1.3 or misunderstand ? Tom Lane 16:32
Re: Aggregate Aggravation Tom Lane 17:31
Re: LEFT OUTER JOIN problem Stephan Szabo 17:49
simple question! Esteban Gutierrez Abarzua 18:13
Re: LEFT OUTER JOIN problem Josh Berkus 18:22
format timestamp Laurette Cisneros 20:56
Re: simple question! Josh Berkus 23:43

Sept. 28, 2001

Thread Author Time
Re: Aggregate Aggravation Robin's PG-SQL List 06:33
Re: A bug in triggers PG 7.1.3 or misunderstand ? Domingo Alvarez Duarte 08:28
[No subject] sreedhar 13:29
faster and faster!! bpalmer 14:02
Re: TEXT in select Haller Christoph 14:11
Re: TEXT in select Michael Remme 14:46
What is wrong? Wei Weng 19:45

Sept. 29, 2001

Thread Author Time
Re: What is wrong? Stephan Szabo 06:19
Entering data in serial column Devrim GUNDUZ 10:23
Re: Entering data in serial column david 13:59
Function return rows? Pat M 16:17

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

Browse Archives

Prev | Next