pgsql-sql since 2002-02-06 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

Feb. 6, 2002

Thread Author Time
Re: indexes Isabelle Brette 09:50
Re: indexes Stephan Szabo 15:29
Query with Parameters Evil Azrael 16:53
Re: WAL filling up disk Vivek Khera 17:28
Re: Query with Parameters Ian Barwick 17:57
Re: Query with Parameters Jeff Eckermann 19:24
JOIN between three *simple* tables ... Marc G. Fournier 20:47
Re: JOIN between three *simple* tables ... Tom Lane 21:14
Re: JOIN between three *simple* tables ... Marc G. Fournier 21:41

Feb. 7, 2002

Thread Author Time
type aliases in 7.0.3 Christopher Kings-Lynne 00:46
pg_shadow / pg_user Rudi 01:51
Re: pg_shadow / pg_user Christopher Kings-Lynne 02:05
Re: pg_shadow / pg_user Rudi 02:15
Re: pg_shadow / pg_user Bruce Momjian 02:31
Nested Transactions John Hasler 13:13
Re: Nested Transactions Bruce Momjian 17:00
How do you return more than one variable in a plpgsql function? Mark Nielsen 20:43
Looking for the correct solution for a generic problem. Frank Joerdens 20:52
Re: Looking for the correct solution for a generic problem. Mark Nielsen 20:53
Re: Help with a SQL query Mark Nielsen 21:02
Re: Looking for the correct solution for a generic problem. Stephan Szabo 21:31
Re: Looking for the correct solution for a generic problem. Tom Lane 21:50
Re: Looking for the correct solution for a generic problem. Frank Joerdens 22:04
ALTER TABLE and dropping a column Frank Joerdens 22:25
Re: ALTER TABLE and dropping a column Josh Berkus 23:22

Feb. 8, 2002

Thread Author Time
Re: How do you return more than one variable in a plpgsql function? Vincent AE Scott 02:13
Re: Help with a SQL query Bill Cunningham 03:47
Multiprocessor support for 7.2 📎 David M. Richter 09:05
Re: Multiprocessor support for 7.2 Bruce Momjian 14:02

Feb. 9, 2002

Thread Author Time
Adding a New Composite Constraint to an Existing Table. Bhuvan A 10:28
Re: Adding a New Composite Constraint to an Existing Table. MindTerm 12:57
Re: Adding a New Composite Constraint to an Existing Table. Stephan Szabo 17:43

Feb. 10, 2002

Thread Author Time
SQL Help - multi values James Carrier 06:34
Re: SQL Help - multi values Oleg Bartunov 08:49
Re: SQL Help - multi values Bruno Wolff III 16:04
Re: SQL Help - multi values Greg Sabino Mullane 17:53
Re: SQL Help - multi values Andrew G. Hammond 20:33
Re: SQL Help - multi values David Stanaway 22:43

Feb. 11, 2002

Thread Author Time
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 01:00
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Brent Verner 01:42
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 02:24
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu 📎 Brent Verner 03:49
Sequences Hunter, Ray 13:43
Re: SQL Help - multi values James Carrier 14:17
Re: Sequences Markus Bertheau 14:22
Re: Sequences Bruno Wolff III 14:36
Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 15:07
Re: Sequences Hunter, Ray 15:12
Join Statements T Conti 15:15
Re: Sequences mallah 15:19
Re: Sequences mallah 15:38
Re: Sequences Bruno Wolff III 15:51
Re: Sequences 📎 Chris Ruprecht 17:25
Re: Oracle "Jobs" in PostgreSQL Andrew G. Hammond 17:54
Re: Oracle "Jobs" in PostgreSQL Thomas Good 18:30
UNION and rows improperly unified: query optimization question Henry House 20:05
Support for bulk reads/writes ? charlie 20:06
Re: Support for bulk reads/writes ? Andrew Perrin 20:24
Re: Support for bulk reads/writes ? David Stanaway 22:58

Feb. 12, 2002

Thread Author Time
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu Tom Lane 00:49
Re: UNION and rows improperly unified: query optimization question Tom Lane 01:18
help importing external excel file RPI 01:33
obtaining row number of select Keith Keller 02:23
Re: Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 04:09
Re: Oracle "Jobs" in PostgreSQL David Stanaway 04:30
Sequencing Problem in Transaction.. Bhuvan A 05:25
Storing text data in databases. mallah 05:39
Re: Sequencing Problem in Transaction.. Christopher Kings-Lynne 06:02
Re: Storing text data in databases. Christopher Kings-Lynne 06:04
Re: Sequencing Problem in Transaction.. Stephan Szabo 06:21
Re: Oracle "Jobs" in PostgreSQL Unnikrishnan Menon 06:56
Re: Sequencing Problem in Transaction.. Bhuvan A 13:40
SQL request to retrieve the type of columns Jean-Max Reymond 15:45
Re: SQL request to retrieve the type of columns Vivek Khera 15:52
Re: Storing text data in databases. Josh Berkus 16:22
Re: Sequencing Problem in Transaction.. Bruce Momjian 17:16
Re: SQL request to retrieve the type of columns Andrew G. Hammond 17:40
pg_atoi error Oleg Lebedev 21:08
Re: pg_atoi error Oleg Lebedev 21:35
Re: UNION and rows improperly unified: query optimization question Jean-Luc Lachance 22:49

Feb. 13, 2002

Thread Author Time
remove Srikanth Rao 16:28
Time Intervals Michael Richards 16:53
How long does it take? Torbj=?ISO-8859-1?B?9g==?=rn Andersson 19:14
Re: Time Intervals Jason Earl 19:23
Re: How long does it take? clayton cottingham 19:36
Re: Time Intervals Michael Richards 19:37
Re: How long does it take? Tom Lane 21:43
Re: Time Intervals Tom Lane 21:50

Feb. 14, 2002

Thread Author Time
Re: How long does it take? Frank Bax 02:12
synchronise 2 db pgsql ? Laurent Patureau 10:09
Re: How long does it take? Torbj=?ISO-8859-1?B?9g==?=rn Andersson 10:18
trigger on table Graham Vickrage 12:17
Re: trigger on table Hano de la Rouviere 12:27
Re: trigger on table PGExplorer 12:28
Re: trigger on table Karel Zak 12:43
Re: How long does it take? Ross J. Reedstrom 16:43
Is this the most efficent way to child nodes off a N-ary node database? Christian Brink 18:52
Money type and kylix Eduardo 19:23
Index not being used Matthew Price 19:33
pre-alpha release of OpenFTS (perl version) is available for testing Oleg Bartunov 19:36
Re: Is this the most efficent way to child nodes off a N-ary Oleg Bartunov 19:37
nexval error duplicate key ron 19:55
Front and Back End Hunter, Ray 21:02
Re: Front and Back End Josh Berkus 21:33
Re: Index not being used Josh Berkus 21:38
Re: Index not being used Matthew Price 22:04
Re: Index not being used Josh Berkus 22:38
Re: Index not being used Stephan Szabo 23:08

Feb. 15, 2002

Thread Author Time
Re: Index not being used Tom Lane 00:46
Re: trigger on table Christopher Kings-Lynne 01:04
Re: Index not being used Christopher Kings-Lynne 01:23
Re: [SQL] Front and Back End Christopher Kings-Lynne 01:24
Re: nexval error duplicate key Lee Harr 01:27
Docs for all the schema functions Christopher Kings-Lynne 01:32
Re: RTLD_LAZY considered harmful (Re: pltlc and pltlcu David Terrell 02:08
Re: Index not being used Tom Lane 03:52
Re: Index not being used Christopher Kings-Lynne 04:06
creating an index on a function Nick Fankhauser 14:26
Re: creating an index on a function Brent Verner 15:42
Re: creating an index on a function Tom Lane 16:00
create index on function - why? Wei Weng 16:25
Re: creating an index on a function Nick Fankhauser 16:27
Re: create index on function - why? Nick Fankhauser 16:33
Re: create index on function - why? Tom Lane 16:46
Re: create index on function - why? Bruno Wolff III 17:01
SQL For smarties Graham Vickrage 17:14
Re: create index on function - why? Luis Sousa 17:22
current connections and queries david blood 17:27
Re: SQL For smarties Bill Cunningham 17:35
Re: SQL For smarties Tom Lane 17:51
Re: create index on function - why? David Huselid 18:01
Re: create index on function - why? Tom Lane 18:15
Problem with self-join updates... Benoit Menendez 18:39
Re: Problem with self-join updates... Stephan Szabo 18:51
Re: synchronise 2 db pgsql ? knut.suebert 21:37
[No subject] GB Clark 21:51
Sorry about the no subject message... GB Clark 21:55

Feb. 16, 2002

Thread Author Time
No Interval Conversion Function in 7.2?!!? Josh Berkus 00:20
Re: No Interval Conversion Function in 7.2?!!? Tom Lane 00:33
Re: No Interval Conversion Function in 7.2?!!? Tom Lane 00:55
Re: SELECT... FOR UPDATE David Griffiths 01:49
Re: Christopher Kings-Lynne 04:36
Re: UNION and rows improperly unified: query optimization question Marshall Spight 07:25
Psql & Readline Josh Berkus 16:38
Re: Psql & Readline Tom Lane 17:40
More problems with 7.2 & functions Josh Berkus 18:10
Re: Join Statements Mark Nielsen 18:30
Re: More problems with 7.2 & functions Tom Lane 18:37
Re: More problems with 7.2 & functions Josh Berkus 18:52
Re: More problems with 7.2 & functions Tom Lane 19:06
Re: More problems with 7.2 & functions Josh Berkus 19:58
Re: More problems with 7.2 & functions Tom Lane 20:02

Feb. 17, 2002

Thread Author Time
Re: create index on function - why? Bruce Momjian 02:49

Feb. 18, 2002

Thread Author Time
Function to split pg_trigger.tgargs Christopher Kings-Lynne 05:35
all tables in a DB\? D'laila Pereira 07:51
Sequence in the rules Luis Sousa 12:10
Re: Function to split pg_trigger.tgargs Rod Taylor 12:40
SQL: Are the "" around table & coloumnames necessary? Mikey 12:43
Need to change the size of a field suresh 13:30
Re: Need to change the size of a field Nick Fankhauser 13:56
Re: Need to change the size of a field postgresql 14:23
table locking Shane Wright 14:39
Re: table locking Bruce Momjian 15:16
Re: table locking Shane Wright 15:22
Re: Sequence in the rules Tom Lane 15:33
Re: table locking Bruce Momjian 15:34
Re: table locking Shane Wright 15:42
Re: table locking Tom Lane 15:42
Re: table locking Shane Wright 15:46
Re: table locking Shane Wright 16:37
Re: Need to change the size of a field Stephan Szabo 18:24
Why is my index not used Kristian Eide 18:54
Casting pairs of floating point variables as a point in plpgsql Irv Shapiro 19:02
Re: all tables in a DB\? Rolf Hug 20:28
Re: Why is my index not used Chris Ruprecht 20:59
Re: Why is my index not used Tom Lane 21:04

Feb. 19, 2002

Thread Author Time
Re: obtaining row number of select Christopher Kings-Lynne 01:26
maximum of sums Rob 05:54
Transient Disk Usage Higher In 7.2 ? Mark kirkwood 08:37
Re: [SQL] Transient Disk Usage Higher In 7.2 ? Christopher Kings-Lynne 09:03
Re: maximum of sums ThomasR 09:58
SELECT with LEFT OUTER JOIN ON 📎 Laurent Patureau 10:00
Re: SELECT with LEFT OUTER JOIN ON Luis Sousa 11:06
Re: SELECT with LEFT OUTER JOIN ON Luis Sousa 12:20
Re: Join Statements Henshall, Stuart - WCP 13:05
SQL query (general) D'laila Pereira 13:57
Re: Transient Disk Usage Higher In 7.2 ? Tom Lane 14:54
inheritance and foreign key Kancha . 15:17
Postgres vs. Mysql Hunter, Ray 16:03
Init startup script Hunter, Ray 16:22
Re: Postgres vs. Mysql Frank Joerdens 16:40
Re: SQL For smarties Rajesh Kumar Mallah 16:48
Re: [SQL] inheritance and foreign key Stephan Szabo 16:53
Re: Postgres vs. Mysql Marius Andreiana 17:14
Problem with self-join updates... Benoit Menendez 18:32
Dates and year 2000 Andy Marden 18:41
Re: Problem with self-join updates... Tom Lane 19:06
Re: Problem with self-join updates... Benoit Menendez 19:35
Issues w/ 7.1 to 7.2 upgrade. Diehl, Jeffrey 20:59
CURRENT_TIMESTAMP breaking with 7.1->7.2 dump/import Mark Stosberg 22:04

Browse Archives

Prev | Next