pgsql-sql - September 2000

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 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 29 30

Sept. 1, 2000

Thread Author Time
Re: RE: Create table in functions Jan Wieck 02:36
Re: RE: Create table in functions Andreas Tille 12:44
Query-ing arrays Jon Lapham 15:27
Re: Query-ing arrays Stephan Szabo 16:07
Re: Query-ing arrays Jon Lapham 18:31

Sept. 3, 2000

Thread Author Time
Re: Week of the Year? Brian C. Doyle 11:25
Re: Week of the Year? John McKown 18:07

Sept. 4, 2000

Thread Author Time
Re: Auto increment Richard Rowell 01:24
Order by in stored functions Andreas Tille 05:18
Re: pg_hba.conf Christopher Sawtell 07:47
Re: pg_hba.conf drfrog 09:11
Re: pg_hba.conf Jan Wieck 10:19
drop sequence in transaction Ice Planet 12:15
Re: Order by in stored functions Tom Lane 16:10
pg_hba.conf Craig May 17:15
Re: pg_hba.conf Craig May 18:50

Sept. 5, 2000

Thread Author Time
Query on array-elements inside object Umashankar Kotturu 03:12
Re: Order by in stored functions Andreas Tille 06:26
array column -- do you really want this? Oliver Seidel 07:40
Protection of tables by group and not by users 📎 nicolas.michaud 09:22
Re: pg_hba.conf Craig May 11:11
Re: pg_hba.conf Craig May 11:28
Re: Re: Order by in stored functions Jie Liang 17:53
Re: Query on array-elements inside object Jie Liang 18:03
7.0.2: Arrays Larry Rosenman 19:56
Re: [HACKERS] 7.0.2: Arrays Kristofer Munn 20:22
Re: [HACKERS] 7.0.2: Arrays Larry Rosenman 20:30
Re: 7.0.2: Arrays Jie Liang 20:38

Sept. 6, 2000

Thread Author Time
8K Limit, and Replication Poet/Joshua Drake 05:41
Re: 8K Limit, and Replication Karel Zak 07:01
Re: Trigger Mike Baroukh 10:24
Re: Trigger Chris Ryan 12:18
Re: Trigger 📎 Chris Ryan 12:40
Cascading Deletes Craig May 17:21
Re: Protection of tables by group and not by users Jie Liang 17:41
Re: Cascading Deletes Stephan Szabo 17:50
Re: Cascading Deletes Jie Liang 18:12
Re: Auto increment Mads Jensen 18:34
Re: [SQL] Re: 7.0.2 questions on encoding and compilation Max Pyziur 19:04
RE: 7.0.2 questions on encoding and compilation Max Pyziur 19:07
Re: [SQL] Re: 7.0.2 questions on encoding and compilation Dana Hudes 19:10
crypt function Francisco André Barbosa Neto 19:39
Trigger Craig May 20:27

Sept. 7, 2000

Thread Author Time
Re: [SQL] Re: 7.0.2 questions on encoding and compilation Igor N. Avtaev 03:40
Re: Cascading Deletes K Parker 04:23
Re: crypt function Ian Turner 05:44
Database Link Gerhard Dieringer 11:27
Re: Join Kristofer Munn 14:03
Antw: Join Gerhard Dieringer 14:25
Foresee any problems with this? postgres-failover (long) Ingram, Bryan 15:15

Sept. 8, 2000

Thread Author Time
Join Craig May 00:59

Sept. 9, 2000

Thread Author Time
Creating an aggregate function Roberto Mello 07:48
Porting from mysql to psql (UNIX_TIMESTAMP()?) Zlatko Calusic 11:02
Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) Rommel B. Abaya 11:25
Re: Porting from mysql to psql (UNIX_TIMESTAMP()?) Zlatko Calusic 12:30
Re: [SQL] Porting from mysql to psql (UNIX_TIMESTAMP()?) Tom Lane 16:59
Re: Creating an aggregate function Tom Lane 21:03

Sept. 10, 2000

Thread Author Time
"ORDER BY" issue - is this a bug? Max Pyziur 18:19

Sept. 11, 2000

Thread Author Time
Re: [BUGS] "ORDER BY" issue - is this a bug? Tom Lane 00:35
Re: [BUGS] "ORDER BY" issue - is this a bug? Max Pyziur 01:06
Re: [BUGS] "ORDER BY" issue - is this a bug? Tom Lane 01:50
Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? Max Pyziur 03:16
Isolation and Concurrency in PG functions? Roberto Mello 05:02
what utilities do i need for postgres on solaris 7 ?? Dronamraju Rajesh 06:51
Re: what utilities do i need for postgres on solaris 7 ?? 📎 Mario Farias-Elinos Baez 07:23
need asap: bg_BG locale for FreeBSD Oleg Bartunov 07:40
Tree structure Trewern, Ben 12:27
making two columns out of one Frank Bax 13:34
Re: need asap: bg_BG locale for FreeBSD Palle Girgensohn 13:51
Re: need asap: bg_BG locale for FreeBSD Oleg Bartunov 14:32
Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? Lamar Owen 14:43
Re: Isolation and Concurrency in PG functions? Tom Lane 16:01
Re: Tree structure Albert REINER 16:25
Re: Tree structure 📎 Zeljko Trogrlic 16:30
How can I select all of the tables with field name 'area'? G. Anthony Reina 23:37
RE: How can I select all of the tables with field name 'area'? Stuart Foster 23:56

Sept. 12, 2000

Thread Author Time
Re: How can I select all of the tables with field name 'area'? G. Anthony Reina 00:34
This is A test Please Delete Hector Banda 00:53
Re: How can I select all of the tables with field name 'area'? Darrin Ladd 01:15
Re: [SQL] Re: [BUGS] "ORDER BY" issue - is this a bug? Max Pyziur 03:03
Re: Tree structure Zeljko Trogrlic 10:51
RE: Tree structure Trewern, Ben 14:52
Weighted Searching Mitch Vincent 16:22
Re: [SQL] Weighted Searching Stephan Szabo 16:41
Odd stuff Jie Liang 18:52
Re: Weighted Searching Josh Berkus 19:51

Sept. 13, 2000

Thread Author Time
Re: making two columns out of one Frank Bax 00:40
PLSQL Paulo Roberto Siqueira 02:05
Re: [SQL] Weighted Searching Oleg Bartunov 03:07
Optimizing Multiply Joins ??? Meszaros Attila 14:16
work on some tables in the same time. Jerome Raupach 14:40
Re: Optimizing Multiply Joins ??? Tom Lane 15:36
Re: PLSQL Josh Berkus 15:46
Re: work on some tables in the same time. Ian Turner 15:48
Re: work on some tables in the same time. Jerome Raupach 15:58
Re: work on some tables in the same time. Ian Turner 16:14
Re: work on some tables in the same time. Stephan Szabo 16:39
Re: PLSQL Jie Liang 16:59
Re: Optimizing Multiply Joins ??? Meszaros Attila 19:22
Re: Optimizing Multiply Joins ??? Tom Lane 20:48
Group by within table joins 📎 Bernie Huang 22:54
Re: Group by within table joins Josh Berkus 23:19
Re: Group by within table joins Jie Liang 23:28

Sept. 14, 2000

Thread Author Time
Web Hosts (off-topic) Tim Quinlan 04:57
Re: Optimizing Multiply Joins ??? Meszaros Attila 15:46
Re: Optimizing Multiply Joins ??? Tom Lane 16:21
Re: Optimizing Multiply Joins ??? Meszaros Attila 16:59
Re: Web Hosts (off-topic) Peter Mount 19:04
left and outer joins? Michael Teter 19:18
Re: Optimizing Multiply Joins ??? Tom Lane 19:35
Re: left and outer joins? Stephan Szabo 19:39

Sept. 15, 2000

Thread Author Time
demo of using large objects interface in php danny 02:57
get table schema in psql? Michael Teter 08:47
Error with DISTINCT Jerome Raupach 09:03
Re: get table schema in psql? Patrik Kudo 09:42
Re: get table schema in psql? Michael Teter 09:49
Re: get table schema in psql? Rommel B. Abaya 12:29
Re: Error with DISTINCT Tom Lane 14:13
Where to get benchmark testing Stuart Foster 15:24
New operators 📎 Kyle 15:55
Re: get table schema in psql? Jie Liang 21:29
Re: Error with DISTINCT Jie Liang 21:36
Re: get table schema in psql? Roderick A. Anderson 23:53

Sept. 16, 2000

Thread Author Time
installing pgaccess Keith Wong 04:00
Re: installing pgaccess Tom Lane 05:49
All function parameters become NULL if one is? Joel Burton 22:47

Sept. 17, 2000

Thread Author Time
Does optimizer know about 'constant' expressions? Philip Warner 08:43
Re: installing pgaccess Peter Eisentraut 13:03
Re: Does optimizer know about 'constant' expressions? Tom Lane 18:16
Re: All function parameters become NULL if one is? Peter Eisentraut 20:37

Sept. 18, 2000

Thread Author Time
shmget fails for min buffers of postmaster also on solaris 7 ..... Dronamraju Rajesh 07:53
Re: shmget fails for min buffers of postmaster also on solaris 7 ..... Thomas Mack 08:32
info about tables Jie Liang 17:05
Division 📎 Bernie Huang 22:47
Re: Division Jie Liang 23:24

Sept. 19, 2000

Thread Author Time
sum of agreggates in one SELECT? Louis-David Mitterrand 10:58
RE: sum of agreggates in one SELECT? Stuart Foster 15:28
Re: sum of agreggates in one SELECT? Tom Lane 17:27
Repeatable reads Michael Richards 17:48
RE: Repeatable reads Mikheev, Vadim 18:06
Re: sum of agreggates in one SELECT? John McKown 18:17
Re: sum of agreggates in one SELECT? Louis-David Mitterrand 20:06
Re: Repeatable reads Tom Lane 20:27
Foreign Keys Help Delete! Timothy Covell 23:49

Sept. 20, 2000

Thread Author Time
Re: [GENERAL] Foreign Keys Help Delete! Josh Berkus 00:08
Re: [SQL] Foreign Keys Help Delete! Stephan Szabo 00:37
Re: [GENERAL] Foreign Keys Help Delete! Jie Liang 01:19
Re: sum of agreggates in one SELECT? Louis-David Mitterrand 06:44
no ORDER BY in subselects? Louis-David Mitterrand 13:23
ERROR: replace_vars_with_subplan_refs (!?) Louis-David Mitterrand 13:25
Re: no ORDER BY in subselects? Tom Lane 14:41
Re: no ORDER BY in subselects? Philip Warner 14:43
Re: ERROR: replace_vars_with_subplan_refs (!?) Tom Lane 14:43
Re: [GENERAL] Foreign Keys Help Delete! Josh Berkus 15:38
Re: ERROR: replace_vars_with_subplan_refs (!?) Tom Lane 16:13
[Fwd: Re: no ORDER BY in subselects?] Josh Berkus 16:20
sql query not using indexes User Lenzi 17:28
Re: [GENERAL] Foreign Keys Help Delete! Stephan Szabo 18:21
Re: sql query not using indexes Stephan Szabo 18:23
Re: [Fwd: Re: no ORDER BY in subselects?] Louis-David Mitterrand 18:25
Re: sql query not using indexes Mitch Vincent 18:37

Sept. 21, 2000

Thread Author Time
Re: [Fwd: Re: no ORDER BY in subselects?] Philip Warner 01:29
Re: [GENERAL] Foreign Keys Help Delete! Timothy Covell 02:30
Re: How do I run a search on array Stephan Szabo 04:02
C functions and int8? Forest Wilkinson 08:05
Re: C functions and int8? Karel Zak 08:32
Re: sql query not using indexes Sergio de Almeida Lenzi 12:15
Re: [Fwd: Re: no ORDER BY in subselects?] Frank Bax 15:50
How do I run a search on array Indraneel Majumdar 16:29
Multiple Index's Brian C. Doyle 17:12
Re: sql query not using indexes Stephan Szabo 17:26
Re: Multiple Index's Stephan Szabo 17:28
Re: Multiple Index's Mitch Vincent 17:28
Re: Multiple Index's Mark Volpe 17:29
Re: Multiple Index's Brian C. Doyle 17:30
Convert from Seconds-Since-Epoch to Timestamp Webb Sprague 18:10
Re: [Fwd: Re: no ORDER BY in subselects?] Philip Warner 18:35
Re: Convert from Seconds-Since-Epoch to Timestamp Jie Liang 18:35
Re: Convert from Seconds-Since-Epoch to Timestamp Brian C. Doyle 18:55
Re: Convert from Seconds-Since-Epoch to Timestamp Jie Liang 20:25
RE: sql query not using indexes Hiroshi Inoue 21:28

Sept. 22, 2000

Thread Author Time
Re: C functions and int8? Forest Wilkinson 00:35
Re: C functions and int8? Tom Lane 02:06
how to store a query, that results in a table root 13:58
Re: [Fwd: Re: no ORDER BY in subselects?] Josh Berkus 15:01
Re: sql query not using indexes Tom Lane 16:51
Re: sql query not using indexes Stephan Szabo 17:12
Re: how to store a query, that results in a table Jie Liang 21:41
[SQL] how to store a query, that results in a table 📎 Nelson 22:09
Re: how to store a query, that results in a table Jie Liang 22:26

Sept. 23, 2000

Thread Author Time
Re: how to store a query, that results in a table Keith Wong 01:14
Re: [SQL] how to store a query, that results in a table Paul Wehr 14:08
missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp) Louis-David Mitterrand 15:45
Re: [SQL] how to store a query, that results in a table Tom Lane 16:20
Re: missing "day(s)" in interval (was: Convert from Seconds-Since-Epoch to Timestamp) Tom Lane 16:46
select Jeff MacDonald 17:37
Re: select Jeff MacDonald 17:49
Re: select Stephan Szabo 18:49
Re: select Jeff MacDonald 18:52

Sept. 24, 2000

Thread Author Time
RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? Philip Warner 03:15

Browse Archives

Prev | Next
Jump to day: 1 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 29 30