pgsql-sql since 2001-10-30 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. 30, 2001

Thread Author Time
Re: SQL99 Jason Watkins 00:04
Re: table permissions Stephan Szabo 00:07
Re: table permissions Aasmund Midttun Godal 00:09
Re: table permissions Oleg Lebedev 00:23
Re: table permissions Oleg Lebedev 00:44
Re: table permissions Oleg Lebedev 01:00
Re: table permissions Aasmund Midttun Godal 03:20
error in postgresql 📎 sharmad 10:00
efficient deletes on subqueries postgresql 15:33
Re: efficient deletes on subqueries Tom Lane 16:48
Re: SQL99 Jochem van Dieten 17:01
Re: challenging query Masaru Sugawara 17:57
Re: postgresql error Tom Lane 20:34
Strange loop Torbj=?ISO-8859-1?B?9g==?=rn Andersson 21:05
Re: error in postgresql Tom Lane 21:46
Re: Strange loop Aasmund Midttun Godal 22:12
Re: Strange loop Tom Lane 22:20

Oct. 31, 2001

Thread Author Time
transposing data for a view H Jeremy Bockholt 00:36
Re: postgresql error sharmad 05:42
Re: transposing data for a view Arian Prins 07:51
Primary key with oid + name : error, which solution ? Stéphane Chomat 09:06
Re: transposing data for a view H Jeremy Bockholt 18:27
Re: transposing data for a view James Orr 19:59
Re: Primary key with oid + name : error, which solution ? Roberto Mello 20:15
Re: transposing data for a view Josh Berkus 20:42
Re: Primary key with oid + name : error, which solution ? Stephan Szabo 22:08
Re: Primary key with oid + name : error, which solution ? Stéphane Chomat 22:21
Re: Primary key with oid + name : error, which solution ? Stephan Szabo 22:40

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

Browse Archives

Prev | Next