pgsql-sql before 2002-07-01 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

June 17, 2002

Thread	Author	Time
template1 - recreate	Rudi Starcevic	06:17
join question - requesting for a simple C program where it can INSERT data into database as reference	Christoph Haller	13:46
Re: check	Christopher Kings-Lynne	14:40
Re: check	Stephan Szabo	14:55
Re: check	Manfred Koizar	16:35
Re: Limiting database size	Jeff Boes	16:52
Re: template1 - recreate	Josh Berkus	18:47
Request for builtin function: Double_quote	Josh Berkus	20:34
Users	Andy Pearce	23:46

June 18, 2002

Thread	Author	Time
Re: Limiting database size	Ulrich Sprick	08:11
Re: Request for builtin function: Double_quote	Christoph Haller	09:35
function text_ge(text, text), how to use on version 7.2	juerg.rietmann	12:08
Re: function text_ge(text, text), how to use on version 7.2	Achilleus Mantzios	13:24
Re: Request for builtin function: Double_quote	Tom Lane	14:48
Re: Request for builtin function: Double_quote	Josh Berkus	15:49
Re: Users	Bruno Wolff III	16:02
text vs varchar	Wei Weng	22:07
Re: text vs varchar	Josh Berkus	22:59
date_part	Rudi Starcevic	23:19
Re: text vs varchar	Michelle Murrain	23:31
Re: text vs varchar	Wei Weng	23:49

June 19, 2002

Thread	Author	Time
is it easy to change the create sequence algorithm?	Kevin Brannen	00:16
Re: date_part	Josh Berkus	00:47
Re: text vs varchar	Josh Goldberg	01:28
Help with a "recursive" query	Jerome Alet	07:30
Re: text vs varchar	Achilleus Mantzios	07:44
Aggregates not allowed in WHERE clause?	Joachim Trinkwitz	08:04
Re: Aggregates not allowed in WHERE clause?	Christopher Kings-Lynne	08:13
Re: Aggregates not allowed in WHERE clause?	Achilleus Mantzios	08:18
Re: Help with a "recursive" query	Oleg Bartunov	08:41
Re: Aggregates not allowed in WHERE clause?	Christoph Haller	10:18
Joining three data sources.	Janning Vygen	10:33
Mirar y reenviar por favor!!! son 2 segundos	Marta Beatriz Caldentey	11:05
SQL performance issue with PostgreSQL compared to MySQL	Jeff Self	13:26
Re: Joining three data sources.	Masaru Sugawara	14:09
Re: SQL performance issue with PostgreSQL compared to MySQL	Tom Lane	14:18
Re: SQL performance issue with PostgreSQL compared to	Josh Berkus	14:58
Tagging rows into collections?	Steve Wampler	16:02
Re: SQL performance issue with PostgreSQL compared to MySQL	Bruce Momjian	16:43
syntax for access an alias in the where clause ?	Michael Agbaglo	18:03
Re: Joining three data sources.	Janning Vygen	18:07
Which one is faster?	Wei Weng	19:27
Re: syntax for access an alias in the where clause ?	Wei Weng	19:56
Re: Which one is faster?	Bruce Momjian	20:34
Assign values to array	afa	20:45
Re: syntax for access an alias in the where clause ?	Michael Agbaglo	21:13
Re: Tagging rows into collections?	Tom Lane	21:19
Re: syntax for access an alias in the where clause ?	Tom Lane	21:23
Re: syntax for access an alias in the where clause ?	Jeff Eckermann	22:04
Re: syntax for access an alias in the where clause ?	Stephan Szabo	22:11
Re: syntax for access an alias in the where clause ?	Ross J. Reedstrom	23:56

June 20, 2002

Thread	Author	Time
Rows affected	Rudi Starcevic	04:01
Re: Joining three data sources.	Janning Vygen	06:27
Re: SQL performance issue with PostgreSQL compared to	Achilleus Mantzios	07:16
Re: Rows affected	Gaetano Mendola	07:25
Re: Aggregates not allowed in WHERE clause?	Joachim Trinkwitz	08:05
Re: Tagging rows into collections?	Richard Huxton	10:12
psql -E <dbname> Floating exception (coredump)	Christoph Haller	10:38
Re: Which one is faster?	Jan Wieck	12:23
slow DELETE queries	Denis	13:23
Re: psql -E <dbname> Floating exception (coredump)	Tom Lane	13:28
Re: Tagging rows into collections?	Steve Wampler	13:34
Re: Joining three data sources.	Masaru Sugawara	13:55
Re: Assign values to array	Arve Fahlvik	14:56
Re: slow DELETE queries	Manfred Koizar	15:01
Re: Which one is faster?	Bruce Momjian	16:10
rowtype and ecpg	Alla	17:15
how to sort a birthday list ?	Michael Agbaglo	18:55
Re: how to sort a birthday list ?	David Stanaway	21:32

June 21, 2002

Thread	Author	Time
Re: SQL performance issue with PostgreSQL compared to	Josh Berkus	00:00
Re: how to sort a birthday list ?	Josh Berkus	00:03
SQL Challenge: Skip Weekends	Josh Berkus	00:13
Re: SQL Challenge: Skip Weekends	Joe Conway	05:32
Re: skip weekends	Rudi Starcevic	06:08
Re: skip weekends	Cliff Wells	07:43
Re: how to sort a birthday list ?	Michael Agbaglo	08:30
Re: how to sort a birthday list ?	Michael Agbaglo	09:23
date_ge and time_ge 📎	juerg.rietmann	09:35
Re: date_ge and time_ge	Achilleus Mantzios	09:45
Re: how to sort a birthday list ?	Bruno Wolff III	12:39
Re: how to sort a birthday list ?	Jan Wieck	13:22
Optimizer question with equivalent joins	Dirk Lutzebaeck	14:26
Re: Optimizer question with equivalent joins	Tom Lane	15:18
Re: [ADMIN] Incredible..	Cliff Wells	16:02
Re: [ADMIN] Incredible..	Larry Rosenman	16:11
Re: SQL Challenge: Skip Weekends	Jean-Luc Lachance	17:46
Presenting consistent data	Ian Lynagh	18:10
FW: RESTORE A TABLE	Jie Liang	18:32
index problem	Oleg Lebedev	18:59
Re: SQL Challenge: Skip Weekends	Josh Berkus	19:29
Re: SQL Challenge: Skip Weekends	Josh Berkus	19:31
Re: skip weekends	Josh Berkus	19:37
Can somebody help me to optimize this huge query?	Dirk Lutzebaeck	20:32
Re: is it easy to change the create sequence algorithm?	Josh Berkus	20:43
Re: is it easy to change the create sequence algorithm?	Andrew Hammond	21:34

June 22, 2002

Thread	Author	Time
Obtaining primary key information from pg system tables	Kris	10:30
A problem on running a sql script in DBVisualizer	Vernon Wu	10:36
Re: Obtaining primary key information from pg system tables	Dmitri Colebatch	10:44
Re: Obtaining primary key information from pg system tables	Kris	11:08

June 23, 2002

Thread	Author	Time
Select + min question	Devrim GUNDUZ	11:36
Re: Select + min question	Christopher Kings-Lynne	12:16
Re: Select + min question	Mathieu Arnold	12:22

June 24, 2002

Thread	Author	Time
Re: Select + min question	Devrim GUNDUZ	06:18
Re: slow DELETE queries	Denis	08:28
Re: rowtype and ecpg	Christoph Haller	10:51
Slow SELECT with distinct, in a TIMESTAMP type column	Marcos Garcia	13:58
assign count() result to a declared variable in plpgsql	Joseph Syjuco	15:25
Re: variance aggregate function incorrect? Reference Materials reg create aggregate	Tom Lane	15:39
Re: assign count() result to a declared variable in plpgsql	Tom Lane	16:12
Re: variance aggregate function incorrect? Reference Materials	Bruce Momjian	16:16
Re: assign count() result to a declared variable in plpgsql	Jeff Eckermann	18:06
Re: Slow SELECT with distinct, in a TIMESTAMP type column	Stephan Szabo	18:36
Re: Slow SELECT with distinct, in a TIMESTAMP type column	Marcos Garcia	19:46
Re: rowtype and ecpg	Alla	19:49
Re: Can somebody help me to optimize this huge query?	Josh Berkus	20:30
Re: Slow SELECT with distinct, in a TIMESTAMP type column	Stephan Szabo	21:06
variance aggregate function incorrect? Reference Materials reg create aggregate	Joseph Syjuco	22:13
Re: Request for builtin function: Double_quote	Tom Lane	22:40

June 25, 2002

Thread	Author	Time
Re: Request for builtin function: Double_quote	Josh Berkus	03:32
altering column width	tdn	06:44
unique index on function and column	Bruno Wolff III	17:58
Re: unique index on function and column	Tom Lane	18:35
Re: unique index on function and column	Bruno Wolff III	18:45
2 Selects 1 is faster, why?	Eric	19:25
Performance Ideas	Eric	19:37
Re: Limiting database size	Eric	19:48
Re: unique index on function and column	Josh Berkus	20:09
Re: unique index on function and column	Bruno Wolff III	20:34
PostgreSQL Cookbook update	Roberto Mello	22:03

June 26, 2002

Thread	Author	Time
what is the difference between default 0 vs default '0'	Beth Gatewood	00:52
Re: what is the difference between default 0 vs default '0'	Lee Harr	02:35
Re: what is the difference between default 0 vs default '0'	Christopher Kings-Lynne	06:46
Quickest way to insert unique records?	Ian Cass	10:12
sequence chages after firing update	Subhashini Karthikeyan	11:47
Re: Performance Ideas	Tom Lane	14:13
Re: sequence chages after firing update	Stephan Szabo	14:46
Efficient Query For Mapping IP Addresses To Country Code.	Rajesh Kumar Mallah.	15:00
Re: sequence chages after firing update	Rajesh Kumar Mallah.	15:18
Re: 2 Selects 1 is faster, why?	Alvar Freude	15:34
Possibility of Index-Only access in PostgreSQL?	Gunther Schadow	17:54
Re: Limiting database size	Josh Berkus	18:12
Calculating with sql	Dennis Kaarsemaker	20:18
Re: Possibility of Index-Only access in PostgreSQL?	Tom Lane	22:59
Re: Limiting database size	terry	23:07
Re: Limiting database size	Thomas Swan	23:41
pg_restore cannot restore function	Jie Liang	23:55

June 27, 2002

Thread	Author	Time
Re: Possibility of Index-Only access in PostgreSQL?	Christopher Kings-Lynne	03:51
CHECK clause doesn't work with CASE clause	Jrg Holetschek	09:52
graphical interface - admin	q u a d r a	11:50
Subtraction of Dates	Valerie Goodman	13:21
Re: CHECK clause doesn't work with CASE clause	Tom Lane	13:44
Re: CHECK clause doesn't work with CASE clause	Richard Huxton	14:19
Re: CHECK clause doesn't work with CASE clause	Richard Poole	15:02
Re: 2 Selects 1 is faster, why?	Masaru Sugawara	15:04
Re: Possibility of Index-Only access in PostgreSQL?	Gunther Schadow	15:19
Re: Slow SELECT -> Growing Database	Marcos Garcia	15:24
Re: Calculating with sql	Masaru Sugawara	16:50
Re: Slow SELECT -> Growing Database	Stephan Szabo	17:11
Re: graphical interface - admin	Ron Peterson	18:19
Re: Slow SELECT -> Growing Database	Marc Spitzer	19:01
Re: Calculating with sql	Dennis Kaarsemaker	19:15
to_char() and order-by	Jeff Boes	19:27
Unsubscription -- How?	David Secret	19:34
Function question	David Hassell	20:33
Two-way query	Vernon Wu	21:47
Re: 2 Selects 1 is faster, why?	Keith Gray	23:40

June 28, 2002

Thread	Author	Time
Re: Slow SELECT -> Growing Database	Tatsuo Ishii	01:46
Re: 2 Selects 1 is faster, why?	Tom Lane	03:52
time difference	q u a d r a	03:58
Re: transaction in plpgsql	Josh Berkus	06:08
Re: graphical interface - admin	David BOURIAUD	06:38
Re: transaction in plpgsql	Nils Höglund	06:53
Re: to_char() and order-by	Karel Zak	07:59
creating functional index over multiple columns	Chantal Ackermann	11:13
Re: creating functional index over multiple columns	Chantal Ackermann	11:22
Re: to_char() and order-by	Jeff Boes	12:48
Re: Function question	Steve Brett	13:38
Re: Subtraction of Dates	Steve Brett	13:52
Re: Calculating with sql	Masaru Sugawara	14:10
Re: Function question	Jie Liang	15:26
Re: graphical interface - admin	Josh Berkus	15:30
Re: transaction in plpgsql	Josh Berkus	15:36
Re: graphical interface - admin	Robert Treat	15:44
transaction in plpgsql	Joseph Syjuco	16:58
pg_user and pg_group	q u a d r a	17:32
Re: graphical interface - admin	terry	18:12
pg_restore cannot restore function	Jie Liang	18:49
Re: graphical interface - admin	Josh Berkus	19:18
Re: pg_restore cannot restore function	Jan Wieck	19:39
something similar to "on delete cascade" ?	Albrecht Berger	19:51
Re: pg_restore cannot restore function	Jie Liang	20:46
Re: pg_restore cannot restore function	Jie Liang	20:49
Re: something similar to "on delete cascade" ?	Josh Berkus	21:33
pg_group members	Kelly	22:31
Re: pg_group members	Bruce Momjian	23:27

June 29, 2002

Thread	Author	Time
Re: creating functional index over multiple columns	Christopher Kings-Lynne	04:19
selecting from integer[]	Kelly	11:48
Re: selecting from integer[]	Christopher Kings-Lynne	14:32
Re: selecting from integer[]	Stephan Szabo	21:11

June 30, 2002

Thread	Author	Time
pl/pgsql capabilities?	Ferenc Engard	23:43

Browse Archives

Prev | Next