pgsql-sql since 2001-05-30 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

May 30, 2001

Thread	Author	Time
Shortcut?	Phuong Ma	00:05
Re: batch file	Grant	01:07
Re: Shortcut?	D'Arcy J.M. Cain	01:19
Re: Shortcut?	Tom Lane	04:21
Re: [GENERAL]	Kapil Tilwani	06:13
query on two databases ..	Muhammed Yazici	07:23
How to use the template table in postgresql	stone	09:01
Re: How to use the template table in postgresql	Hans-Jürgen Schönig	09:15
Re: Case Insensitive Queries	[email protected]	10:40
sql hard question	limlim	11:41
Re: Difficult SQL Statement	Renato De Giovanni	13:25
Re: Left Joins...	Renato De Giovanni	13:33
ERROR: Class '37632' not found	DI Hasenöhrl	13:42
Re: Case Insensitive Queries	Tom Lane	14:23
Re: Case Insensitive Queries	[email protected]	14:37
Re: ERROR: Class '37632' not found	Tom Lane	14:39
Re: Case Insensitive Queries	Mark	14:57
Re: Case Insensitive Queries	Mark	14:57
bpchar compares (was Re: Case Insensitive Queries)	Mark	14:59
RE: primary key scans in sequence	Koen Antonissen	15:57
Re: query on two databases ..	Nils Zonneveld	16:27
Re: Case Insensitive Queries	Tom Lane	16:53
SELECT * INTO TABLE is not working for me.	Roy Souther	17:02
Re: bpchar compares (was Re: Case Insensitive Queries)	Richard Huxton	17:34
php-nuke	Sharmad Naik	17:44
RE: primary key scans in sequence	Stephan Szabo	17:46
Re: Case Insensitive Queries	Mark	17:47
Re: Case Insensitive Queries	Mark	18:06
Re: Case Insensitive Queries	Stephan Szabo	18:16
Distinct Values	Nicolas	18:22
Re: Case Insensitive Queries	Stephan Szabo	18:54
Re: Case Insensitive Queries	Ian Lance Taylor	19:51
Unique record Identifier?	Chris Ruprecht	20:14
Re: Case Insensitive Queries	Tom Lane	20:45
Re: Slow inserts/deletes	Frank Contrepois	21:21
Re: START for SERIAL type?	Frank Contrepois	21:23
Re: Is it possible to defer triggers?	Frank Contrepois	21:26
Re: INSERT value of type table	Frank Contrepois	21:31
Re: Unique record Identifier?	Josh Berkus	21:33
Using indexes	Linh Luong	22:37
Re: Using indexes	Bruce Momjian	22:57
Re: Unique record Identifier?	Chris Ruprecht	23:11
Too many rows returning	Linh Luong	23:33

May 31, 2001

Thread	Author	Time
Re: SELECT * INTO TABLE is not working for me.	Sergey E. Volkov	07:54
RE: primary key scans in sequence	Koen Antonissen	09:03
Re: SELECT * INTO TABLE is not working for me.	Richard Huxton	10:52
question about PL/pgSQL function	datactrl	11:24
7.1 LOCK TABLE changes	Brian Powell	15:12
7.1.1 Lock Problems on Views	Brian Powell	15:33
RE: primary key scans in sequence	Stephan Szabo	15:37
Re: rowset Return from postgresql	Josh Berkus	16:03
Date manipulation	Mark	16:22
Re: 7.1.1 Lock Problems on Views	Tom Lane	16:42
Re: 7.1.1 Lock Problems on Views	Brian Powell	17:06
Re: Date manipulation	Reinoud van Leeuwen	19:21
Re: Date manipulation	Peter Eisentraut	21:08
RE: primary key scans in sequence	Gerald Gutierrez	23:26

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	[email protected]	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?	[email protected]	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

Browse Archives

Prev | Next