pgsql-sql - June 2001

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

June 1, 2001

Thread Author Time
Re: query on two databases .. Muhammed Yazici 07:41
Problem with pg_index. David BOURIAUD 13:52
Re: Problem with pg_index. Tom Lane 14:20
date format Martín Marqués 14:40
[Fwd: Problem with pg_index.] David BOURIAUD 14:51
Foreign Keys and Inheritance Dennis Muhlestein 15:38
Re: Date manipulation Josh Berkus 16:21
Re: question about PL/pgSQL function Josh Berkus 16:24
PGAccess/pgplsql Blues Josh Berkus 16:30
select distinct too slow george young 16:36
Re: PGAccess/pgplsql Blues Tom Lane 17:28
seleting all dates between two dates Jeff Barrett 19:09
Re: question about PL/pgSQL function Jan Wieck 19:29
Re: PGAccess/pgplsql Blues Roberto Mello 21:53

June 2, 2001

Thread Author Time
trying to summarize into a new table by time... Larry Rosenman 10:12
list of returns types for functions Clayton Cottingham aka drfrog 11:43
Re: trying to summarize into a new table by time... Larry Rosenman 13:50
Re: trying to summarize into a new table by time... Tom Lane 14:16
Re: trying to summarize into a new table by time... Larry Rosenman 14:44
Re: trying to summarize into a new table by time... Tom Lane 14:58
Re: trying to summarize into a new table by time... Larry Rosenman 15:02
help with a function Clayton Cottingham aka drfrog 17:27
Re: trying to summarize into a new table by time... Alex Pilosov 18:14
Tutorial : using foreign keys, retrictions etc Mario Bittencourt 22:49

June 4, 2001

Thread Author Time
SQL Date Challenge Josh Berkus 17:31
Re: PGAccess/pgplsql Blues Josh Berkus 18:02
Re: SQL Date Challenge Manuel Sugawara 18:03
Re: SQL Date Challenge george young 18:44
Re: SQL Date Challenge Larry Rosenman 18:56
Re: SQL Date Challenge Josh Berkus 20:26
Re: SQL Date Challenge Alex Pilosov 20:56
Re: SQL Date Challenge Peter Eisentraut 21:30
Re: SQL Date Challenge Josh Berkus 21:32
Re: seleting all dates between two dates Hans-Jürgen Schönig 21:39
Re: select distinct too slow Hans-Jürgen Schönig 21:45

June 5, 2001

Thread Author Time
Huh? Data typing bug? Josh Berkus 00:33
Re: Huh? Data typing bug? Grant 00:44
Re: Huh? Data typing bug? Tom Lane 01:25
Re: Huh? Data typing bug? Josh Berkus 01:56
Re: SQL Date Challenge Josh Berkus 03:19
PL/PGSQL Andrzej Roszkowski 06:18
Cluster and primary key Mikael Kjellstrm 07:51
Foreign key to base table with rows in inherited tables Mikael Kjellstrm 08:23
Re: Distinct Values Hans-Jürgen Schönig 09:18
Re: Distinct Values Hans-Jürgen Schönig 09:20
problem with Pl/Pgsql function Matteo Centenaro 11:16
Re: Problem on CREATE/ALTER USER Tom Lane 14:14
Reading array's of integer in plpg/SQL Luis Sousa 16:41
Problem on CREATE/ALTER USER chard 18:26
PHP-PostgreSQL - install Dorin Grunberg 18:34
Re: [PHP] PHP-PostgreSQL - install Chris Ruprecht 19:17
Re: Distinct Values Stephan Szabo 21:14
Re: query on two databases .. Stephan Szabo 21:30
Re: 7.1 LOCK TABLE changes Peter Eisentraut 21:33
plperl clayton cottingham 22:09
Re: sql hard question Josh Berkus 23:32
Re: plperl Tom Lane 23:45
Re: plperl Jie Liang 23:48

June 6, 2001

Thread Author Time
"Day" from 8am to 3am Judd Maltin 00:05
RE: Distinct Values Hartwig Jens 06:43
How to use the type int2vector ? David BOURIAUD 06:43
Re: php-nuke Nils Zonneveld 08:40
Re: How to use the type int2vector ? David BOURIAUD 10:14
Re: Large Objects - lo_export tjk@tksoft.com 13:04
tables, permissions, sequences Martín Marqués 13:21
Large Objects - lo_export Guru Prasad 13:22
audit trail and system catalogs Markus Wagner 14:01
Sub-SELECT uses un-GROUPed attribute: how to solve. Gaizka Villate 14:48
Re: "Day" from 8am to 3am Tom Lane 14:57
audit trail and system catalogs Markus Wagner 15:15
Re: "Day" from 8am to 3am Judd Maltin 15:17
multiple sql update w/ major time issues Dawn 15:23
RE: Distinct Values KuroiNeko 15:23
Re: Tutorial : using foreign keys, retrictions etc Stephan Szabo 15:41
Re: help with a function Peter Eisentraut 15:51
Re: seleting all dates between two dates Josh Berkus 15:53
Re: [SQL] Foreign Keys and Inheritance Stephan Szabo 15:54
Re: audit trail and system catalogs Stephan Szabo 16:23
Memory exhausted in AllocSetAlloc george young 16:24
Re: seleting all dates between two dates george young 16:31
Cascade constraint gone!!! Linh Luong 16:34
Re: php-nuke Roberto Mello 17:00
Re: Tutorial : using foreign keys, retrictions etc Roberto Mello 17:03
maximum number of rows in table - what about oid limits? jmscott@REMOVEMEyahoo.com 17:07
Re: Cascade constraint gone!!! Stephan Szabo 17:27
Re: Memory exhausted in AllocSetAlloc Stephan Szabo 17:29
Re: Memory exhausted in AllocSetAlloc Tom Lane 17:49
How to create a *pass-through-query* in postgresql DI Hasenöhrl 17:53
Re: [SQL] maximum number of rows in table - what about oid limits? Stephan Szabo 17:55
Re: [SQL] maximum number of rows in table - what about oid limits? John Scott 18:45
Re: How to create a *pass-through-query* in postgresql Alex Pilosov 18:50
Re: [SQL] maximum number of rows in table - what about oid limits? Stephan Szabo 18:50
Functions and Triggers Hunter, Ray 20:13
Re: How to create a *pass-through-query* in postgresql Richard Huxton 20:29
Yet another Postgresql article... Brent R. Matzelle 20:33
sum of string columns, why ? Marcos Vaz - ( NewAge Group ) 21:13
Re: [SQL] maximum number of rows in table - what about oid limits? John Scott 21:52
Re: [SQL] maximum number of rows in table - what about oid limits? Stephan Szabo 21:58
Re: [SQL] maximum number of rows in table - what about oid limits? Tom Lane 22:37
Re: maximum number of rows in table - what about oid limits? Josh Berkus 23:09
Re: How to create a *pass-through-query* in postgresql Josh Berkus 23:12

June 7, 2001

Thread Author Time
behavior of ' = NULL' vs. MySQL vs. Standards Mark Stosberg 01:00
Re: [SQL] maximum number of rows in table - what about oid limits? John Scott 01:08
Re: behavior of ' = NULL' vs. MySQL vs. Standards Stephan Szabo 01:12
Re: [SQL] maximum number of rows in table - what about oid limits? Tom Lane 02:05
Re: maximum number of rows in table - what about oid limits? Tom Lane 02:13
Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane 02:19
Help me speed things up... Paul Tomblin 02:26
Re: behavior of ' = NULL' vs. MySQL vs. Standards Stephan Szabo 03:12
Are SQL commands "atomic" ? Gerald Gutierrez 06:10
Getting row with id=max(id) Gerald Gutierrez 06:20
Re: How to create a *pass-through-query* in postgresql Richard Huxton 06:37
About i8n David BOURIAUD 07:06
Re: multiple sql update w/ major time issues Hans-Jürgen Schönig 08:26
About table column names. David BOURIAUD 08:57
Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane 10:00
how to configure --with-tcl in CYGWIN guard 10:50
Re: About i8n J.H.M. Dassen Ray 11:55
which sql syntax is better for joins on pgsql? fabrizio 12:22
Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett 13:34
Re: behavior of ' = NULL' vs. MySQL vs. Standards Thomas Lockhart 13:41
Re: behavior of ' = NULL' vs. MySQL vs. Standards Mark Stosberg 14:40
Re: About table column names. Mark Stosberg 14:45
Re: behavior of ' = NULL' vs. MySQL vs. Standards ANDREW PERRIN 14:59
Re: Re: [SQL] maximum number of rows in table - what about oid limits? Tim Barnard 15:08
listing foreign keys David Brown 15:26
Re: About table column names. Peter Eisentraut 15:28
dropping constraints Linh Luong 15:32
Re: Re: About i8n David BOURIAUD 15:52
Re: behavior of ' = NULL' vs. MySQL vs. Standards Josh Berkus 15:53
Re: dropping constraints Stephan Szabo 16:36
Re: plperl Clayton Cottingham aka drfrog 16:50
Are SQL commands "atomic" ? Gerald Gutierrez 16:59
Getting row with id=max(id) Gerald Gutierrez 17:00
Re: Re: About i8n Peter Eisentraut 17:00
Re: Getting row with id=max(id) jeff 17:04
UPDATE with concatenate Laurent Patureau 17:14
Re: Getting row with id=max(id) Peter Eisentraut 17:31
Re: Are SQL commands "atomic" ? Stephan Szabo 17:39
Re: UPDATE with concatenate Stephan Szabo 17:43
Re: UPDATE with concatenate Rene Pijlman 18:39
Function returning record Alla 18:53
Re: Are SQL commands "atomic" ? Gerald Gutierrez 19:05
Re: Getting row with id=max(id) Gerald Gutierrez 19:13
Re: Getting row with id=max(id) Gerald Gutierrez 19:17
Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Ivar Helbekkmo 19:17
RE: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Mike Mascari 19:36
Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Ivar Helbekkmo 19:42
Re: Getting row with id=max(id) Alex Pilosov 19:51
Forein Key Problem Dennis 21:43

June 8, 2001

Thread Author Time
Re: Re: About i8n David BOURIAUD 07:02
Help datetime Tubagus Nizomi 07:36
Hidden Select Luis Sousa 08:54
update from another table ivan 10:03
rpt Hilkiah Lavinier 12:32
Re: Rule ON DELETE, to perform to DELETE querys ! Martín Marqués 13:32
Re: maximum number of rows in table - what about oid limits? Tom Lane 14:38
Re: Re: [SQL] maximum number of rows in table - what about oid limits? Tom Lane 14:41
Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane 14:53
Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane 15:04
Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett 15:26
Rule ON DELETE, to perform to DELETE querys ! Luis Sousa 15:28
Re: behavior of ' = NULL' vs. MySQL vs. Standards Josh Berkus 15:33
Re: maximum number of rows in table - what about oid limits? Josh Berkus 15:42
Re: Re: About i8n Peter Eisentraut 16:29
Re: Hidden Select Peter Eisentraut 16:31
Re: Getting row with id=max(id) Tom Lane 16:34
Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards Josh Berkus 16:53
Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett 17:48
Re: maximum number of rows in table - what about oid limits? Josh Berkus 18:15
Re: maximum number of rows in table - what about oid limits? Jonathan Bartlett 21:42
Re: behavior of ' = NULL' vs. MySQL vs. Standards Tom Lane 22:01
Re: maximum number of rows in table - what about oid limits? Josh Berkus 22:03

June 9, 2001

Thread Author Time
Index usage Subra Radhakrishnan 03:27
Re: Index usage Stephan Szabo 03:39
Inconsistent usage of Index 📎 Subra Radhakrishnan 15:18
Do I have to lock table in this case? Ondrej Palkovsky 15:50
Re: Inconsistent usage of Index Peter Eisentraut 16:17
Re: Index usage Peter Eisentraut 16:21
cascading delete - recursivity Postgresql 16:22
Re: Inconsistent usage of Index Joe Conway 16:23

June 10, 2001

Thread Author Time
Integrity reference and inheritance Christophe Labouisse 04:57
Integrity and Inheritance Christophe Labouisse 05:08
Re: Integrity and Inheritance Stephan Szabo 05:23
Re: Integrity and Inheritance Tom Lane 16:11
GRANT EXECUTE Dmitry G. Mastrukov 19:07
Re: Integrity and Inheritance Stephan Szabo 21:03

June 11, 2001

Thread Author Time
Re: maximum number of rows in table - what about oid limits? Bruce Momjian 04:37
Re: maximum number of rows in table - what about oid limits? Bruce Momjian 04:42
Re: Yet another Postgresql article... Bruce Momjian 04:54
ORDER BY what? Martín Marqués 08:19
RE: GRANT EXECUTE Hartwig Jens 08:41
Memory exhausted 📎 David Richter 12:25
Re: rpt Jeff Boes 13:10
Re: Memory exhausted Tom Lane 13:56
Re: GRANT EXECUTE Peter Eisentraut 14:38
Table design issue.... pierre 14:38
Re: Yet another Postgresql article... Tatsuo Ishii 14:42
Bit Mapping operation Najm Hashmi 15:54
Re: Hidden Select Luis Sousa 16:27

Browse Archives

Prev | Next