pgsql-sql - November 2001

Discussion for users on SQL related matters.

Search the Archives

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

Browse Archives

Prev | Next

Nov. 1, 2001

Thread Author Time
Re: Recursive select --CELKO-- 01:14
Re: transposing data for a view Aasmund Midttun Godal 03:26
How to use BYTEA type? Christopher Sawtell 08:40
problem in group by Md Aminur Rashid 09:56
Re: How to use BYTEA type? Radu-Adrian Popescu 10:15
View consistency 📎 David M. Richter 14:20
Re: transposing data for a view Jeff Eckermann 15:47
Re: View consistency Tom Lane 15:48
Re: [SQL] View consistency Stephan Szabo 16:07
Re: transposing data for a view 📎 Josh Berkus 16:07
Re: View consistency 📎 David M. Richter 16:08
Re: transposing data for a view 📎 Josh Berkus 16:17
Re: transposing data for a view Jeff Eckermann 16:22
Re: How to use BYTEA type? Stephan Szabo 16:22
Re: transposing data for a view 📎 Josh Berkus 16:27
PL/pgSQL syntax for strings Edward Grabczewski 16:48
Re: transposing data for a view James Orr 16:54
Aggregate binary AND James Orr 17:16
Re: transposing data for a view Jeff Eckermann 17:44
Re: How to use BYTEA type? Joe Conway 18:08
Re: Aggregate binary AND Philip Hallstrom 18:09
Sorry for blocking email Bruce Momjian 18:49
Error 34526 - cache lookup failed Sandro Joel Eller 18:49
Re: Aggregate binary AND Tom Lane 19:01
Re: Error 34526 - cache lookup failed Stephan Szabo 19:38
Re: PL/pgSQL syntax for strings Roberto Mello 19:56
table permissions Oleg Lebedev 21:04
Re: table permissions Tom Lane 22:35
Re: table permissions Oleg Lebedev 23:13

Nov. 2, 2001

Thread Author Time
SELECT statement during transaction Bhuvan A 02:56
Re: PL/pgSQL syntax for strings Edward Grabczewski 03:45
debugging sharmad 04:05
debugging sharmad 04:05
select from a dynamic table name Jason Kwok 06:58
Re: View consistency 📎 David M. Richter 08:45
Re: View consistency Tom Lane 15:23
Help with a complex Update Orion 23:15

Nov. 3, 2001

Thread Author Time
Strange Problem As Type Casting Bhuvan A 03:39
Porting Web application written in Oracle 8 PL/SQL to Postgresql Andy 10:02
SQL FUNCTION return type on INSERT Edward Grabczewski 12:18
Re: SQL FUNCTION return type on INSERT Edward Grabczewski 14:12
Re: PL/pgSQL syntax for strings Edward Grabczewski 14:17
Re: Strange Problem As Type Casting Tom Lane 16:01
Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql Domingo Alvarez Duarte 18:16

Nov. 4, 2001

Thread Author Time
Re: SQL FUNCTION return type on INSERT Josh Berkus 01:39
Re: Strange Problem As Type Casting Josh Berkus 01:42
Book reviews are up Josh Berkus 01:53
Re: Recursive select knut.suebert 17:03

Nov. 5, 2001

Thread Author Time
Generating list of days in a given time interval Nikhil G. Daddikar 05:17
Possible to create a *really* virtual table ? Denis Bucher 14:02
Design Tool for postgresql Janning Vygen 14:58
Re: Help with a complex Update Ross J. Reedstrom 15:26
Re: [HACKERS] Porting Web application written in Oracle 8 Jean-Michel POURE 15:35
Re: Book reviews are up Robert J. Sanford, Jr. 16:08
design tool Janning Vygen 16:24
table permissions II Haller Christoph 16:38
Re: Book reviews are up Josh Berkus 16:38
Re: debugging Josh Berkus 16:44
Re: Porting Web application written in Oracle 8 PL/SQL Josh Berkus 16:49
Re: Help with a complex Update Josh Berkus 16:57
Left join error Ligia Pimentel 17:39
copy command with PSQL X 18:13
Re: select from a dynamic table name David Stanaway 23:07

Nov. 6, 2001

Thread Author Time
Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql Christopher Kings-Lynne 02:24
Re: design tool John Fabiani 08:43
Re: Possible to create a *really* virtual table ? Denis Bucher 12:21
Re: design tool Janning Vygen 16:05
Re: Left join error Josh Berkus 16:36
Re: copy command with PSQL Jeff Eckermann 16:38
Re: design tool Fernando Nasser 16:56
Re: copy command with PSQL Mark Nickel 17:08
trouble using FOR ... IN EXECUTE query LOOPs in PL/pgSQL Jon Obuchowski 17:57
Re: Left join error Josh Berkus 18:18
Re: copy command with PSQL Andrew Gould 18:35
Re: Left join error Tom Lane 19:14
Re: trouble using FOR ... IN EXECUTE query LOOPs in PL/pgSQL Alexander Kunz 19:29
Re: trouble using FOR ... IN EXECUTE query LOOPs in PL/pgSQL Alex Pilosov 19:44
Re: trouble using FOR ... IN EXECUTE query LOOPs in PL/pgSQL Tom Lane 20:19
Re: SQL99 Robert Sundstrm 20:53
Re: Design Tool for postgresql Christopher Sawtell 21:06
Re: SQL99 Josh Berkus 21:10
Re: Design Tool for postgresql [email protected] 22:58
Can't find docs on Postgresql.conf Josh Berkus 23:06
Re: design tool Reinoud van Leeuwen 23:39
Re: Can't find docs on Postgresql.conf Bruce Momjian 23:42

Nov. 7, 2001

Thread Author Time
Re: Can't find docs on Postgresql.conf Tom Lane 00:10
Re: Can't find docs on Postgresql.conf Tom Lane 00:17
Re: Can't find docs on Postgresql.conf Bruce Momjian 00:21
Re: Can't find docs on Postgresql.conf Tom Lane 00:26
Re: Can't find docs on Postgresql.conf Bruce Momjian 00:28
Re: Can't find docs on Postgresql.conf Tom Lane 00:45
Re: Can't find docs on Postgresql.conf Bruce Momjian 01:32
Re: Increasing MAX_ARGS Josh Berkus 01:34
Re: Can't find docs on Postgresql.conf Bruce Momjian 01:47
Re: Increasing MAX_ARGS Bruce Momjian 02:11
Single VIEW, and FUNCTION questions... wyatt 02:12
Re: Increasing MAX_ARGS Tom Lane 04:43
Re: Single VIEW, and FUNCTION questions... Josh Berkus 05:38
Re: Increasing MAX_ARGS Tom Lane 05:42
Re: Increasing MAX_ARGS Bruce Momjian 06:12
Re: Single VIEW, and FUNCTION questions... wyatt 06:47
Postgres+ISO8859-8 support? Josh 07:09
Re: Design Tool for postgresql Janning Vygen 08:49
Re: update in rule Radoslaw Stachowiak 10:52
Re: update in rule Sean K. Sell 12:43
Re: Porting Web application written in Oracle 8 PL/SQL to Postgresql Roberto Mello 13:57
Re: design tool Roberto Mello 14:00
Re: Design Tool for postgresql Tille, Andreas 14:17
Re: Postgres+ISO8859-8 support? Karel Zak 14:48
Need help with embedded CASEs Denis Bucher 15:58
RIGHT JOIN is only supported with mergejoinable join conditions Nick Fankhauser 16:16
help with sintaxis of quotes on function Ernesto Freyre 16:21
Re: Increasing MAX_ARGS Tom Lane 16:30
Re: Increasing MAX_ARGS Josh Berkus 16:35
Re: RIGHT JOIN is only supported with mergejoinable join Josh Berkus 16:49
Re: Need help with embedded CASEs John D. Rozeboom 16:53
Re: update in rule Stephan Szabo 17:07
Re: Need help with embedded CASEs Stephan Szabo 17:14
help with function and quotes qradius 17:37
Re: RIGHT JOIN is only supported with mergejoinable join conditions Tom Lane 17:38
Re: Need help with embedded CASEs Tom Lane 18:06
Re: RIGHT JOIN is only supported with mergejoinable join conditions Nick Fankhauser 18:29
Re: RIGHT JOIN is only supported with mergejoinable join conditions Tom Lane 19:06
Re: Design Tool for postgresql [email protected] 20:49
Can this query be optimized? Claus Heiko Niesen 21:00
Single VIEW, Everybody JOIN! wyatt 21:01
Re: RIGHT JOIN is only supported with mergejoinable join conditions Nick Fankhauser 22:22
Re: RIGHT JOIN is only supported with mergejoinable join conditions Tom Lane 22:48
Re: performance tuning Francisco Reyes 23:14
Re: performance tuning Jason Earl 23:55

Nov. 8, 2001

Thread Author Time
Re: Need help with embedded CASEs Peter Eisentraut 00:25
Re: Can't find docs on Postgresql.conf Roberto Mello 00:40
ISO SQL 92/99 paper? Roberto Mello 00:42
Re: Can't find docs on Postgresql.conf Bruce Momjian 02:36
Solution found ! Re: Need help with embedded CASEs Denis Bucher 11:06
Re: Can this query be optimized? Tom Lane 14:30
Re: Design Tool for postgresql Tille, Andreas 14:45
Re: Increasing MAX_ARGS Josh Berkus 16:34
Re: help with sintaxis of quotes on function Stephan Szabo 16:37
Re: help with function and quotes Josh Berkus 16:44
Re: Can this query be optimized? Josh Berkus 16:49
Re: Can this query be optimized? Claus Heiko Niesen 19:11
Re: Can this query be optimized? Claus Heiko Niesen 19:19
Re: Can this query be optimized? Ross J. Reedstrom 20:00
Optimizing Jeff Sack 21:54
substring replacement Oleg Lebedev 22:45

Nov. 9, 2001

Thread Author Time
Re: Can this query be optimized? [email protected] 00:26
Re: Design Tool for postgresql [email protected] 00:32
Re: Increasing MAX_ARGS Tom Lane 00:48
Re: Increasing MAX_ARGS Josh Berkus 05:35
Optimization, etc Jeff Sack 06:42
Re: Design Tool for postgresql Tille, Andreas 14:46
Re: Optimizing Josh Berkus 15:54
Re: Optimization, etc Stephan Szabo 15:57
Re: Increasing MAX_ARGS Roberto Mello 15:58
Re: substring replacement Jeff Eckermann 16:35
Re: Optimization, etc Jason Earl 18:22
Re: Design Tool for postgresql [email protected] 21:30

Nov. 10, 2001

Thread Author Time
postgresql 7.2beta can't support "distributed databases " guard 00:50
Re: Single VIEW, Everybody JOIN! Masaru Sugawara 15:11

Nov. 11, 2001

Thread Author Time
Re: Increasing MAX_ARGS Peter Eisentraut 15:39
Re: error in postgresql Sharmad Naik 15:43
Re: error in postgresql Tom Lane 17:00
Re: [SQL] RIGHT JOIN is only supported with mergejoinable join conditions Tom Lane 19:37

Nov. 12, 2001

Thread Author Time
Re: Optimizing Steve Brett 13:40
no cond returns diff res than cond or !cond Markus Bertheau 14:26
Re: no cond returns diff res than cond or !cond Stephan Szabo 14:39
integer attribute 1672 != 1672 Markus Bertheau 14:47
Re: integer attribute 1672 != 1672 Tom Lane 15:35
Re: no cond returns diff res than cond or !cond Haller Christoph 15:46
Re: integer attribute 1672 != 1672 Markus Bertheau 15:52
Re: integer attribute 1672 != 1672 Markus Bertheau 15:55
Re: integer attribute 1672 != 1672 Tom Lane 15:59
Re: integer attribute 1672 != 1672 Haller Christoph 16:05
Funny Parse Error on Insert Orion 19:12
problem: index on number not honoured Ilker Egilmez 20:06
Re: Funny Parse Error on Insert Orion 20:37

Nov. 13, 2001

Thread Author Time
Is this a bug? Jack Gao 05:20
Joins!! Gurudutt 05:45
Help with RULE Otakar Kleps 08:28
Re: SQL99 Robert Sundstrm 09:27
INSERT question Brian 09:30
Re: Joins!! Haller Christoph 09:35
Re: Is this a bug? Carl van Tast 10:26
Help with INSERT into 2 tables Gintas 13:42
Insert values from one existing table into a new table. Jason 16:43
Re: Is this a bug? Jack Gao 18:07
how do I update or insert efficently in postgres Marc Spitzer 18:18
Re: how do I update or insert efficently in postgres Josh Berkus 19:42
Full text search Jocelyn Callier 20:26
Re: how do I update or insert efficently in postgres Tom Lane 21:04
Re: Insert values from one existing table into a new table. Wilco Boschman 21:33
Re: Full text search Josh Berkus 21:33
Re: Full text search Jason Earl 21:46
Re: INSERT question Wilco Boschman 21:51
Re: how do I update or insert efficently in postgres Marc Spitzer 22:27
Optimization with dates Jean-Christophe Boggio 23:56

Nov. 14, 2001

Thread Author Time
Re: Optimization with dates Stephan Szabo 00:17
Re: Optimization with dates Josh Berkus 00:19
Re: Optimization with dates Jason Earl 00:44

Browse Archives

Prev | Next