pgsql-sql since 2001-08-21 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

Aug. 21, 2001

Thread Author Time
exists Joseph Shraibman 02:05
database location question Carolyn Lu Wong 05:19
Re: exists Stephan Szabo 05:40
is it possible to use arrays in plpgsql function?? Bhuvan A 05:54
Primary vs Unique Index Gonzo Rock 06:45
Re: is it possible to use arrays in plpgsql function?? omid omoomi 07:20
Getting 'n-1'th record. Bhuvan A 07:41
Re: Getting 'n-1'th record. omid omoomi 09:14
Re: Primary vs Unique Index D'Arcy J.M. Cain 09:26
RE: Sequential select queries...?? Henshall, Stuart - WCP 10:43
Re: database location question Tom Lane 14:12
Re: split/explode functions Jeff Eckermann 14:17
Re: Getting 'n-1'th record. Tom Lane 14:21
Re: Primary vs Unique Index 📎 Josh Berkus 14:39
Re: Getting 'n-1'th record. Jeff Eckermann 15:08
Re: Getting 'n-1'th record. 📎 Josh Berkus 15:15
Re: exists Joseph Shraibman 15:24
Re: How to execute a system file in procedure? Albert REINER 16:23
Re: exists Stephan Szabo 16:45
Re: exists Joseph Shraibman 17:29
Re: exists Stephan Szabo 17:57
Re: exists Joseph Shraibman 18:08
Re: exists Tom Lane 19:06
Should I worry? Josh Berkus 19:35
Re: Should I worry? Tom Lane 20:44
Re: exists Joseph Shraibman 20:51
Re: exists Tom Lane 21:03
Re: exists Joseph Shraibman 21:19
Re: exists Tom Lane 23:48

Aug. 22, 2001

Thread Author Time
Re: exists Joseph Shraibman 00:15
changes to table creation syntax in 7.1.2? Jayson Callaway 04:23
Altering pg_conndefaults macky 06:28
Re: [SQL] Altering pg_conndefaults Peter Eisentraut 16:09
just checking postgresql 19:37
protected ON DELETE CASCADE Murray Hobbs 22:01

Aug. 23, 2001

Thread Author Time
Help On Postgresql Jaydip 07:50
Re: [NOVICE] protected ON DELETE CASCADE Albert Reiner 12:12
Re: protected ON DELETE CASCADE Jan Wieck 13:55
Re: protected ON DELETE CASCADE Gregory Wood 14:48
Function returning an array Francesco Casadei 14:58
Re: Function returning an array 📎 Josh Berkus 15:44
Re: Function returning an array Tom Lane 17:07
HELP: Trend reporting Jason Charette 18:05
Execute permsissions on fuctions Zot O'Connor 18:52
Re: protected ON DELETE CASCADE Murray Hobbs 19:07
DBD::Pg install error (freebsd) jake johnson 19:08
Re: Function returning an array Alex Pilosov 19:45
Re: protected ON DELETE CASCADE Jan Wieck 20:21
Re: protected ON DELETE CASCADE Murray Hobbs 20:46

Aug. 24, 2001

Thread Author Time
GRANT ALL ON TO GROUP failure Jari Aalto+usenet 05:35
Re: GRANT ALL ON TO GROUP failure Thurstan R. McDougle 08:51
Re: Temp tables being written to disk. Avoidable? [Another TO-DO] Chris Ruprecht 13:38
Re: DBD::Pg install error (freebsd) Vivek Khera 15:39
WHERE on an alias Joseph Shraibman 18:11
Re: WHERE on an alias Stephan Szabo 19:27
Re: WHERE on an alias Joseph Shraibman 19:31
Indexing and performance Josh Berkus 19:56
Re: WHERE on an alias Josh Berkus 19:58
Re: WHERE on an alias Joseph Shraibman 20:18
Re: WHERE on an alias Josh Berkus 20:43
Re: WHERE on an alias Stephan Szabo 20:52
Re: WHERE on an alias Tom Lane 20:56
Re: DBD::Pg install error (freebsd) jake johnson 23:20

Aug. 25, 2001

Thread Author Time
Re: Execute permsissions on fuctions Zot O'Connor 04:42
Re: Execute permsissions on fuctions Dmitry G. Mastrukov Дмитрий Геннадьевич Мастрюков 06:08
Re: Execute permsissions on fuctions Christopher Sawtell 08:19

Aug. 26, 2001

Thread Author Time
Sql Marcia Cunha 00:55
Different Choices For Index/Sequential Scan With And Without A Join In 7.2 Mark kirkwood 08:36
undocumented setval() Cedar Cox 08:40
"AND", "OR" and Materialize :(((( Meszaros Attila 12:38
Re: [SQL] undocumented setval() Tom Lane 15:24
Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2 Tom Lane 15:44
Re: "AND", "OR" and Materialize :(((( Tom Lane 15:51
Re: "AND", "OR" and Materialize :(((( Meszaros Attila 18:09
Re: Different Choices For Index/Sequential Scan With And Without A Join In 7.2 markir 22:49

Aug. 27, 2001

Thread Author Time
Apache authentication and v7.1 Giorgio Volpe 08:34

Aug. 28, 2001

Thread Author Time
Create table syntax satish rao 07:11
Problem with sequences Vladimir Terziev 15:15

Aug. 29, 2001

Thread Author Time
List archives moved and cleaned up ... Marc G. Fournier 03:44
Re: WHERE on an alias Andre Schnabel 06:27
[No subject] Vladimir Terziev 07:40
getting the oid for a new tuple in a BEFORE trigger Markus Wagner 09:15
Re: omid omoomi 09:16
Re: [SQL] getting the oid for a new tuple in a BEFORE trigger omid omoomi 10:11
Re: getting the oid for a new tuple in a BEFORE trigger 📎 Josh Berkus 14:38
Re: changes to table creation syntax in 7.1.2? Stephan Szabo 18:24
Re: changes to table creation syntax in 7.1.2? Jason Earl 20:34
GRANT ALL ON TO GROUP failure Jari Aalto 21:26
RE: changes to table creation syntax in 7.1.2? Jayson Callaway 21:42
Re: GRANT ALL ON TO GROUP failure Peter Eisentraut 21:57
Re: GRANT ALL ON TO GROUP failure Oliver Elphick 22:20

Aug. 30, 2001

Thread Author Time
Latin-2 sort order Michał Pasternak 00:16
Re: Latin-2 sort order Tatsuo Ishii 01:55
Re: Re: [SQL] getting the oid for a new tuple in a BEFORE trigger Horst Herb 03:40
Apache authentication with debian linux Giorgio Volpe 08:12
Re: [SQL] getting the oid for a new tuple in a BEFORE trigger Francesco Casadei 09:05
Re: getting the oid for a new tuple in a BEFORE trigger Peter Eisentraut 13:28
Apache authentication with debian linux Giorgio Volpe 13:35
Index Scan Backward vs. Sort/Sequential Scan when using ORDER BY Keith Bussey 16:38
Re: Problem with sequences Josh Berkus 16:56
Re: [SQL] HELP: Trend reporting Oleg Lebedev 17:16
Re: Create table syntax Arne Weiner 17:39
Re: Create table syntax Stephan Szabo 17:42
Re: Help On Postgresql Arne Weiner 17:46
Re: Help On Postgresql Stephan Szabo 17:49
Re: Help On Postgresql Jeff Eckermann 18:16
Re: Where can I find the SQL Commands that I can use with ECPG Arne Weiner 18:40
Re: Re: [SQL] HELP: Trend reporting Stephan Szabo 19:12
Re: Re: pg_dumpall failed Stephan Szabo 19:58
Re: Re: pg_dumpall failed Oleg Lebedev 20:02
Re: Re: pg_dumpall failed Stephan Szabo 20:06
Re: Re: pg_dumpall failed Oleg Lebedev 20:20
2 tables, joins and same name... Marc André Paquin 20:25
Re: Re: pg_dumpall failed Oleg Lebedev 21:53
Re: Re: pg_dumpall failed Oleg Lebedev 22:53
Re: Sql Bruce Momjian 22:53

Aug. 31, 2001

Thread Author Time
Re: Latin-2 sort order Tatsuo Ishii 00:59
Re: Help On Postgresql Henshall, Stuart - WCP 10:18
Re: 2 tables, joins and same name... Richard Poole 14:17
Re: 2 tables, joins and same name... Stephan Szabo 14:30
Re: 2 tables, joins and same name... 📎 Josh Berkus 14:46
Re: 2 tables, joins and same name... 📎 Josh Berkus 15:29
Re: 2 tables, joins and same name... Thomas Rehlich 15:55
Re: getting the oid for a new tuple in a BEFORE trigger Mikheev, Vadim 16:45
Re: 2 tables, joins and same name... Ross J. Reedstrom 22:29

Sept. 1, 2001

Thread Author Time
Re: 2 tables, joins and same name... 📎 Josh Berkus 16:44
Re: 2 tables, joins and same name... Ross J. Reedstrom 18:21

Sept. 3, 2001

Thread Author Time
duplicated oid Carolyn Lu Wong 04:41
[No subject] Joseph Syjuco 09:02
Re: Michael Davis 16:29
GRANT ALL ON TO GROUP failure Jari Aalto 16:34
Re: Joe Conway 17:05
Re: Peter Eisentraut 17:35
Re: Stephan Szabo 17:45
More on the TO DO wishlist Chris Ruprecht 18:06
Re: INSERT Syntax 📎 Josh Berkus 19:33
Re: More on the TO DO wishlist 📎 Josh Berkus 19:39
Re: More on the TO DO wishlist Peter Eisentraut 21:24
Re: On Differing Optimizer Choices ( Again) Tom Lane 22:33
Re: Index Scan Backward vs. Sort/Sequential Scan when using ORDER BY Tom Lane 23:31

Sept. 4, 2001

Thread Author Time
Re: More on the TO DO wishlist 📎 Josh Berkus 03:16
Re: 2 tables, joins and same name... 📎 Josh Berkus 03:18
Need help in composing PostgreSQL query Vladimir V. Zolotych 06:23
Re: Need help in composing PostgreSQL query Oliver Elphick 07:53
Re: GRANT ALL ON TO GROUP failure Henshall, Stuart - WCP 09:53
Re: 2 tables, joins and same name... Jeff Eckermann 15:10
Re: [HACKERS] getting the oid for a new tuple in a BEFORE Bruce Momjian 15:33

Sept. 6, 2001

Thread Author Time
[No subject] postgresql 17:11
BUG in 7.1.3 Alessandro Rossi 21:34
Re: duplicated oid Carolyn Lu Wong 23:53

Sept. 7, 2001

Thread Author Time
Re: duplicated oid Stephan Szabo 00:23
Re: duplicated oid Tom Lane 00:35
Re: Combine query views into one SQL string Nils Zonneveld 08:10
Re: Combine query views into one SQL string Maik 08:42
Re: Combine query views into one SQL string Nils Zonneveld 09:00
Re: ERROR: DefineQueryRewrite: rule plan string too big. Tom Lane 14:19
Re: Haller Christoph 15:13
ERROR: DefineQueryRewrite: rule plan string too big. Haller Christoph 15:38

Sept. 8, 2001

Thread Author Time
optimizing queries and indexes... Robert J. Sanford, Jr. 03:53

Sept. 9, 2001

Thread Author Time
Re: postgresql 03:12
Re: Combine query views into one SQL string Tony Hunt 07:46
Re: optimizing queries and indexes... 📎 Josh Berkus 20:03
Re: Combine query views into one SQL string Eimas 23:20

Sept. 10, 2001

Thread Author Time
Re: optimizing queries and indexes... Stephan Szabo 00:06
Re: optimizing queries and indexes... 📎 Josh Berkus 01:05
Re: optimizing queries and indexes... Stephan Szabo 05:01
array variable in pl/pgsql jack 07:47
row level locking? Jeff Barrett 15:25
calling a shell script from pl/pgsql Jeff Barrett 16:14
Re: row level locking? Stephan Szabo 17:18
Re: calling a shell script from pl/pgsql Stephan Szabo 17:22
Re: calling a shell script from pl/pgsql Larry Rosenman 17:51
pl/sh (was Re: calling a shell script from pl/pgsql) Alex Pilosov 18:17
Re: pl/sh (was Re: calling a shell script from pl/pgsql) Stephan Szabo 18:19
Re: pl/sh (was Re: calling a shell script from pl/pgsql) Alex Pilosov 18:24
Re: calling a shell script from pl/pgsql clayton cottingham 18:44
Re: calling a shell script from pl/pgsql Jeff Barrett 19:15
Re: pl/sh (was Re: calling a shell script from pl/pgsql) Peter Eisentraut 19:26
Re: calling a shell script from pl/pgsql Larry Rosenman 19:49

Sept. 11, 2001

Thread Author Time
array variable in pl/pgsql datactrl 00:45
array variable in pl/pgsql datactrl 00:57
array variables in pl/pgsql Jack 01:31
group by weirdness Joseph Shraibman 02:11
Re: group by weirdness 📎 Josh Berkus 04:06
Re: Combine query views into one SQL string Gledatelj 06:33
Re: calling a shell script from pl/pgsql Jan Wieck 07:08
table inheritance and foreign key troubles Kevin Way 08:04
SQL Query Miguel González 08:41
Re: table inheritance and foreign key troubles Christof Glaser 09:12
Re: table inheritance and foreign key troubles Christof Glaser 10:49
Re: table inheritance and foreign key troubles Stephan Szabo 10:58
Re: SQL Query Adam Lang 12:52
referencing oid impozsible ? patrick.jacquot 14:58
Re: referencing oid impozsible ? Stephan Szabo 16:58
Re: referencing oid impozsible ? Josh Berkus 17:29
To query many tables. trebischt 18:47
using LATIN1 ? Domingo Alvarez Duarte 20:15

Sept. 12, 2001

Thread Author Time
Re: table inheritance and foreign key troubles Kevin Way 01:24
Re: SQL Query Miguel González 07:51
Which SQL query makes it possible to optain the 3 greatest values of an interger list ? Yoann 08:41

Browse Archives

Prev | Next