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

Sept. 13, 2001

Thread Author Time
query time Esteban Gutierrez Abarzua 15:44
Re: query time Peter Eisentraut 17:18
Re: group by weirdness Joseph Shraibman 21:31
Re: group by weirdness Joseph Shraibman 21:53

Sept. 14, 2001

Thread Author Time
trigger trouble -- procedure not found Kevin Way 04:26
Re: trigger trouble -- procedure not found Bhuvan A 04:59
Re: trigger trouble -- procedure not found Stephan Szabo 05:16
Re: trigger trouble -- procedure not found Kevin Way 06:30
Urgent: How to set autocommit off in postgres......... Advid@newgen 09:36
SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY 10:11
[No subject] Bhuvan A 11:53
Number the lines Yoann 12:05
How to Get Timestamp From SECONDS? Bhuvan A 13:25
Re: Peter Eisentraut 14:10
Re: group by weirdness --CELKO-- 15:18
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 📎 Josh Berkus 15:18
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Andre Schnabel 15:29
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY 17:31
Re: Number the lines Jeff Eckermann 18:50
Checking for table existence Julester 18:58
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Josh Berkus 19:19
I could do with some guidance David. E. Goble 19:36
Re: How do I extract ONE particular field, when multiple table Patrik Kudo 20:34
Re: How do I extract ONE particular field, when multiple table contain the same field name? Christof Glaser 21:05
Re: How do I extract ONE particular field, when multiple table contain the same field name? Jeff Eckermann 21:35
Re: group by weirdness Carl van Tast 22:26

Sept. 15, 2001

Thread Author Time
Re: Which SQL query makes it possible to optain the 3 greatest values of an interger list ? Wei Weng 00:08
Re: Which SQL query makes it possible to optain the 3 greatest Patrik Kudo 00:11
How to see the definition of an existing table? ke wang 00:35
Re: Number the lines Lee Harr 03:12
Re: To query many tables. Andre Schnabel 07:47
Re: Checking for table existence Hans-Juergen Schoenig 08:48
Re: How to Get Timestamp From SECONDS? Hans-Juergen Schoenig 08:56

Sept. 16, 2001

Thread Author Time
Re: optimizing queries and indexes... Tom Lane 04:34
Intentional, or bug? Kovacs Baldvin 14:14
Correction for the previous letter: Kovacs Baldvin 15:00
Re: Intentional, or bug? Tod McQuillin 15:04
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Tom Lane 19:11
Re: Intentional, or bug? Tom Lane 19:31
Re: Intentional, or bug? Stephan Szabo 19:44
Re: optimizing queries and indexes... 📎 Josh Berkus 20:36
Part 2 of "Intentional, or a bug".... Kovacs Baldvin 22:02
Re: Part 2 of "Intentional, or a bug".... Tom Lane 23:06

Sept. 17, 2001

Thread Author Time
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY 07:45
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY 08:15
Re: SQL request change when upgrade from 7.0.2 to 7.1.3 Richard NAGY 08:27
Re: Part 2 of "Intentional, or a bug".... Kovacs Baldvin 08:47
functions returning 📎 Tomasz Myrta 08:56
Re: Number the lines Kovacs Baldvin 12:54
Re: Number the lines Haller Christoph 14:15
Re: Checking for table existence Stephan Szabo 14:57
Re: I could do with some guidance Josh Berkus 15:27
Out of free buffers... HELP! Diehl, Jeffrey 15:36
PL/PGSQL Regexe rdear 15:41
Re: group by weirdness Carl van Tast 18:07
Implicit v Explicit joins... [email protected] 18:41
Stored prosedure last run Pasha 18:49

Sept. 18, 2001

Thread Author Time
Re: Checking for table existence Roberto Mello 00:12
Re: How to see the definition of an existing table? Lee Harr 00:37
Re: Checking for table existence 📎 Kovacs Baldvin 01:11
Re: Checking for table existence 📎 Josh Berkus 03:54
Re: Out of free buffers... HELP! Diehl, Jeffrey 07:07
Re: How to see the definition of an existing table? Haller Christoph 11:19
Re: Out of free buffers... HELP! D'Arcy J.M. Cain 11:22
Re: Out of free buffers... HELP! Haller Christoph 13:17
Re: Out of free buffers... HELP! Tom Lane 13:45
Re: Checking for table existence Kovacs Baldvin 14:41
Re: Out of free buffers... HELP! Kovacs Baldvin 14:45
Re: Out of free buffers... HELP! 📎 Josh Berkus 15:26
Holiday Calculations? 📎 Josh Berkus 15:31
Selecting latest value Patrik Kudo 16:22
URGENT ! Nouveau virus Denis Bucher 17:07
Registring a C function in PostgreSQL Miguel González 18:06
URGENT ! Nouveau virus Denis Bucher 18:30
Re: URGENT ! Nouveau virus Denis Bucher 19:55
Re: Number the lines Christopher Sawtell 22:54
Re: Holiday Calculations? Philip Hallstrom 23:21
Re: Stored prosedure last run Stephan Szabo 23:21
Re: Out of free buffers... HELP! Tom Lane 23:26

Sept. 19, 2001

Thread Author Time
Re: Holiday Calculations? Brett Schwarz 00:28
PHP session issue Peter 00:50
Re: Out of free buffers... HELP! Mark kirkwood 05:55
Re: Registring a C function in PostgreSQL Peter Eisentraut 08:09
Re: Registring a C function in PostgreSQL Haller Christoph 10:24
Re: Registring a C function in PostgreSQL Miguel González 10:41
Re: PL/PGSQL Regexe Tom Lane 14:20
Re: Registring a C function in PostgreSQL II Haller Christoph 14:41
Re: Stored prosedure last run Josh Berkus 15:50
Re: Checking for table existence (fwd) Kovacs Baldvin 16:55
Re: Registring a C function in PostgreSQL II Miguel González 18:23
Creating a boolean function Miguel González 18:55
Re: Holiday Calculations? Brett Schwarz 19:01
Re: Creating a boolean function Stephan Szabo 19:36
Re: Creating a boolean function Jeff Eckermann 19:54
Re: Creating a boolean function Tom Lane 20:19
Re: Out of free buffers... HELP! Diehl, Jeffrey 20:55
Re: Out of free buffers... HELP! Diehl, Jeffrey 21:00
Re: Holiday Calculations? clayton cottingham 21:49
Re: Creating a boolean function Kovacs Baldvin 22:03
Re: Holiday Calculations? clayton cottingham 22:39
Re: Out of free buffers... HELP! Tom Lane 23:38

Sept. 20, 2001

Thread Author Time
Re: Out of free buffers... HELP! Josh Berkus 00:35
Re: Out of free buffers... HELP! Tom Lane 06:55
Trigger Problem Mohammad Faisal 07:58
Re: PL/PGSQL Regexe rdear 09:45
Re: Registring a C function in PostgreSQL II Haller Christoph 10:29
table restruction 📎 David M. Richter 10:34
Re: Trigger Problem Andreas Joseph Krogh 10:56
Re: Selecting latest value Haller Christoph 11:11
Re: table restruct... Kovacs Baldvin 13:40
Re: Selecting latest value Patrik Kudo 13:57
Re: table restruct... 📎 David M. Richter 14:31
Re: table restruct... Stephan Szabo 14:46
Re: Selecting latest value Stephan Szabo 14:49
Re: Selecting latest value Tom Lane 15:07
Re: Selecting latest value Patrik Kudo 15:12
Re: table restruct... Thurstan R. McDougle 15:23
Re: Selecting latest value II Chris Ruprecht 15:25
Re: Selecting latest value II Haller Christoph 16:02
Re: Selecting latest value II Thurstan R. McDougle 16:30
Re: Out of free buffers... HELP! Diehl, Jeffrey 18:49
Re: Out of free buffers... HELP! Diehl, Jeffrey 19:06
Re: Selecting latest value II Carl van Tast 19:47
Re: Out of free buffers... HELP! Josh Berkus 19:50
Re: Out of free buffers... HELP! Diehl, Jeffrey 20:02

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

Browse Archives

Prev | Next