pgsql-sql since 2002-02-16 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

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
Re: SQL reference card 📎 Bruce Momjian 22:29
Re: CURRENT_TIMESTAMP breaking with 7.1->7.2 dump/import Mark Stosberg 22:47
comparision chart clayton cottingham 23:39

Feb. 20, 2002

Thread Author Time
Re: CURRENT_TIMESTAMP breaking with 7.1->7.2 dump/import Christopher Kings-Lynne 03:13
Re: Issues w/ 7.1 to 7.2 upgrade. Josh Berkus 03:38
Re: comparision chart Christopher Sawtell 05:43
Re: comparision chart Johannes =?iso-8859-15?q?Gr=F8dem?= 08:36
Re: comparision chart Christopher Kings-Lynne 08:59
combination of 'textcat' and 'interval' in 7.2. Bhuvan A 12:02
Re: Issues w/ 7.1 to 7.2 upgrade. Thomas Good 13:11
Changing a column constraint? Henry Holland 13:21
Re: combination of 'textcat' and 'interval' in 7.2. Peter Eisentraut 16:19
Re: comparision chart clayton cottingham 17:28
Re: SQL For smarties Graham Vickrage 18:55
Re: SQL For smarties Stephan Szabo 19:15
Re: SQL For smarties Jeff Eckermann 19:20
Re: SQL For smarties Josh Berkus 20:16
Re: Dates and year 2000 Andy Marden 20:37
Matching columns in rows from two tables Richard Emberson 21:51
Re: Dates and year 2000 Tom Lane 23:21
Re: comparision chart Josh Berkus 23:32
Re: comparision chart clayton cottingham 23:57

Feb. 21, 2002

Thread Author Time
Re: Dates and year 2000 Thomas Lockhart 01:54
Trying to convert a TIMESTAMP return value to TIME Erik Norvelle 03:35
OT: duplicate emails... Rajesh Kumar Mallah 07:33
Re: Dates and year 2000 Andy Marden 07:59
Changing column constraints? Henry Holland 09:25
Re: Dates and year 2000 Andy Marden 09:27
Re: comparision chart Troels Arvin 13:47
Re: Dates and year 2000 Thomas Lockhart 14:13
Re: comparision chart Brian Knox 14:14
Help with many updates Glenn MacGregor 16:31
Re: Money type and kylix Josh Berkus 19:03
Re: Changing column constraints? Josh Berkus 19:07
Re: current connections and queries Hunter, Ray 19:30
Re: Changing column constraints? Stephan Szabo 19:52
Finding matching columns from two tables Richard Emberson 20:17
Re: Help with many updates Oliver Elphick 21:09
Re: Trying to convert a TIMESTAMP return value to TIME Erik Norvelle 21:13
Re: all tables in a DB\? Jie Liang 21:21
Re: SQL: Are the "" around table & coloumnames necessary? Oliver Elphick 21:39
Re: maximum of sums Jean-Luc Lachance 21:55
Re: SQL query (general) Jean-Luc Lachance 22:09
Permanent fatal errors Josh Berkus 22:14
Finding matching columns from two tables Richard Emberson 22:34

Feb. 22, 2002

Thread Author Time
Re: Casting pairs of floating point variables as a point in plpgsql Tom Lane 00:18
Re: Permanent fatal errors Tom Lane 01:01
Re: Trying to convert a TIMESTAMP return value to TIME Tom Lane 02:07
Date Problem pauLSiew 02:39
Re: all tables in a DB\? Christopher Kings-Lynne 03:10
Re: create index on function - why? Christopher Kings-Lynne 03:13
Re: Array slice subscripts (was Re: [SQL] plpgsql function Bruce Momjian 03:55
Re: Array slice subscripts (was Re: [SQL] plpgsql function with more than one array argument) Tom Lane 04:14
Re: SQL: Are the "" around table & coloumnames necessary? pauLSiew 06:50
Can someone help me with this function? 📎 Christopher Kings-Lynne 08:51
Re: Can someone help me with this function? Christopher Kings-Lynne 09:02
Re: Array slice subscripts (was Re: [SQL] plpgsql function Andre Holzner 09:17
quotes nightmare! Graham Vickrage 13:18
How does Index Scan get used Samuel J. Sutjiono 14:46
Page Management Samuel J. Sutjiono 15:13
Re: Postgres vs. Mysql Roberto Mello 15:55
Re: Page Management Wei Weng 15:58
Re: comparision chart Roberto Mello 16:00
Re: quotes nightmare! Stephan Szabo 16:11
Re: How does Index Scan get used Stephan Szabo 16:13
Re: quotes nightmare! Roberto Mello 16:28
Re: Date Problem Josh Berkus 16:51
Regular Expression for 'and' instead of 'or' Samuel J. Sutjiono 17:04
Re: Page Management Nick Fankhauser 17:13
How do I return more than one value in a postgresql pl/pgsql procedure? Mark Nielsen 17:56
Re: How does Index Scan get used Oliver Elphick 18:08
Re: Regular Expression for 'and' instead of 'or' Fernando Schapachnik 18:15
Re: [SQL] Regular Expression for 'and' instead of 'or' Samuel J. Sutjiono 18:34
Re: [SQL] Regular Expression for 'and' instead of 'or' Fernando Schapachnik 18:46
Re: How does Index Scan get used Oliver Elphick 19:32
Re: How does Index Scan get used Frank Bax 20:13
Re: Regular Expression for 'and' instead of 'or' Tom Lane 20:20
Re: [SQL] Regular Expression for 'and' instead of 'or' Peter Eisentraut 20:45
Re: Regular Expression for 'and' instead of 'or' Medi Montaseri 21:26
Bench Test Hunter, Ray 21:53
Re: comparision chart Mark kirkwood 23:47

Feb. 23, 2002

Thread Author Time
Re: How does Index Scan get used Tom Lane 00:11
Re: [SQL] Transient Disk Usage Higher In 7.2 ? Mark kirkwood 00:29
Re: How does Index Scan get used Oliver Elphick 00:56
Re: Matching columns in rows from two tables Masaru Sugawara 06:18
Re: Regular Expression for 'and' instead of 'or' Rajesh Kumar Mallah 06:25
should I use postgresql arrays... Rajesh Kumar Mallah 06:37
Re: Finding matching columns from two tables Masaru Sugawara 08:41
[No subject] Bradley Baetz 10:21
Re: should I use postgresql arrays... Peter Eisentraut 17:21
Re: Bench Test Tom Lane 18:49
Re: How do I return more than one value in a postgresql pl/pgsql procedure? Roberto Mello 19:03
How to insert zeros into a bytea column? Iklódi Lajos 20:16