pgsql-sql before 2002-07-03 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 19, 2002

Thread Author Time
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

July 1, 2002

Thread Author Time
Re: graphical interface - admin Andreas Joseph Krogh 09:10
Re: graphical interface - admin Oleg Bartunov 11:29
Re: graphical interface - admin Andreas Joseph Krogh 12:16
Re: graphical interface - admin Oleg Bartunov 13:00
Re: graphical interface - admin Andreas Joseph Krogh 13:06
Re: graphical interface - admin Roberto Mello 14:37
Re: pl/pgsql capabilities? Roberto Mello 14:40
unsubscribe Simeone, Mario 16:28
Using union to avoid creating temp table Bruno Wolff III 16:31
Re: Using union to avoid creating temp table Tom Lane 17:17
Re: pg_restore cannot restore function Jan Wieck 18:13
CASE Select, referring to selected value Nick Riemondi 22:00
Re: pl/pgsql capabilities? Ferenc Engard 23:37

July 2, 2002

Thread Author Time
Re: pl/pgsql capabilities? Roberto Mello 05:23
Fw: Postgres function call problems Sandeep Chibber 10:40
Re: CASE Select, referring to selected value Achilleus Mantzios 12:16
Temporary table instead of repeated joins Chantal Ackermann 12:48
Re: CASE Select, referring to selected value Christopher Kings-Lynne 13:57
Re: CASE Select, referring to selected value Nick Riemondi 14:30
Why doesn't it use indexes? Ahti Legonkov 15:46
constraint Ricardo Javier Aranibar León 20:07
Selecting data from a table created in another database... Ligia Pimentel 20:13
Re: pg_restore cannot restore function Jie Liang 23:08

Browse Archives

Prev | Next