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

Thread	Author	Time
Escape Quotes	Keith Gray	01:11
Re: Order by email address by domain ?	Frank Bax	01:53
Re: Escape Quotes	Tom Lane	02:34
Re: Escape Quotes	Tom Lane	02:38
Re: Escape Quotes	Keith Gray	02:40
Re: Escape Quotes	Keith Gray	03:17
Re: Re: Escape Quotes	Roberto Mello	04:45
ipsql (was - Escape Quotes) 📎	Keith Gray	05:22
Question about Committed Isolation	datactrl	05:26
Client Applications come with PostGreSQL V7.1	Jack	05:39
number of days in a month	Cwhisperer	06:19
Client Applications come with PostGreSQL V7.1	datactrl	06:20
Postgres function library	Lajtos Mate	06:48
Problems in porting from Oracle to Postgres	Amit	06:54
RE: Order by email address by domain ?	Maxim Maletsky	07:45
Re: Cannot build PL/Perl ...	Mark Nielsen	10:41
can't get rid of unnesesary SORT step in explain plan for hash join	Alexey Nalbat	11:47
Max simultaneous users	webb sprague	14:10
RE: Order by email address by domain ?	Jeff Eckermann	14:35
Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???	Cliff Crawford	15:01
Re: [HACKERS] Problems in porting from Oracle to Postgres	Roberto Mello	15:06
Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ???	J.H.M. Dassen Ray	15:29
Re: execute client application from PL/pgSql	Jeff MacDonald	16:28
Re: execute client application from PL/pgSql	clayton cottingham	16:32
create type and domains	Valerio Santinelli	16:32
Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement	Tom Lane	16:33
Re: Postgres function library	Roberto Mello	17:14
Re: Informix->PostgreSQL database convertion	Sylte	17:15
Re: Is this possible?	Roberto Mello	17:24
Re: number of days in a month	Kaare Rasmussen	18:15
WAL logs eating my diskspace!!	webb sprague	19:40
Re: Re: How to store gif or jpeg? Thanks!	Mathijs Brands	20:18
Problem using IP functions	Marc Lamothe	20:33
Re: WAL logs eating my diskspace!!	Tom Lane	23:30

May 12, 2001

Thread	Author	Time
Re: execute client application from PL/pgSql	datactrl	00:23
Constraints...	Michael Richards	18:57
SELECT timestamp('2001-06-12'::date - '2000-06-12'::date)	Hans-Jürgen Schönig	19:26
Re: multi-table join, final table is outer join count ...	The Hermit Hacker	22:47

May 13, 2001

Thread	Author	Time
Re: Constraints...	Stephan Szabo	00:38
Re: Re: multi-table join, final table is outer join count ...	Tom Lane	00:41
Re: can't get rid of unnesesary SORT step in explain plan for hash join	Tom Lane	01:53
Re: SELECT timestamp('2001-06-12'::date - '2000-06-12'::date)	Tom Lane	03:03
Re: Problem using IP functions	Tom Lane	03:44
Re: Re: Informix->PostgreSQL database convertion	rmcm	08:05
BLOB	Antti Linno	14:02
how to remove ?	Subhramanya Shiva	16:43
DISTINCT ON () with UNION	pgsql	23:14

May 14, 2001

Thread	Author	Time
Re: DISTINCT ON () with UNION	Tom Lane	00:52
Re: can't get rid of unnesesary SORT step in explain plan for hash join	Alexey Nalbat	07:36
unwritable /tmp causes initdb to crash	John Scott	08:16
error message...	S.E.Franke	11:10
Auto incrementing an integer	Sylte	13:02
Re: can't get rid of unnesesary SORT step in explain plan for hash join	Tom Lane	14:17
fatal ERROR running simple join query...	Ligia Pimentel	14:28
Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement	David D. Kilzer	14:42
Re: Auto incrementing an integer	Martín Marqués	15:15
Case	Cwhisperer	15:21
Re: fatal ERROR running simple join query...	Martín Marqués	15:21
Counting rows in a table	Srikanth Rao	15:21
plpgsql function / ??? / help	Larry Rosenman	18:00
Re: execute client application from PL/pgSql	Jeff MacDonald	18:16
working with stored procedures	Radhika Vutukuru	19:41
Re: Case	Peter Eisentraut	20:39
Re: Auto incrementing an integer	Thomas Swan	21:27
Re: Auto incrementing an integer	Philip Hallstrom	21:53
Re: Auto incrementing an integer	Sylte	21:55

May 15, 2001

Thread	Author	Time
RE: Auto incrementing an integer	Michael Davis	01:33
How NULL is interpreted in Pgsql	Guru Prasad	08:08
Give me a suggestion 'START WITH .. CONNECT BY'.	山さん	08:40
Re: error message...	Justin Clift	10:09
Re: execute client application from PL/pgSql	Justin Clift	10:31
system time	Seema Noor	10:46
Re: system time	Justin Clift	10:57
Case insensitive string comparison?	Borek Lupoměský	12:48
Re: working with stored procedures (fwd)	Guru Prasad	13:10
Re: Case insensitive string comparison?	Karel Zak	13:47
Re: How NULL is interpreted in Pgsql	Tom Lane	14:12
varbit question	Laurent Duperval	14:31
Exp/Imp Problems...	ameet	14:52
Re: varbit question	Peter Eisentraut	15:41
Re: varbit question	Laurent Duperval	15:47
Re: system time	Jason Earl	19:04
Select between two connections	cbell	19:43
Please dont flame	Olivier PRENANT	21:01
Re: Select between two connections	Per-Olof Pettersson	23:30
Re: How NULL is interpreted in Pgsql	Per-Olof Pettersson	23:38
Re: [SQL] Is this possible?	Peter J. Schoenster	23:47
Re: how to remove ?	Per-Olof Pettersson	23:51

May 16, 2001

Thread	Author	Time
search for groups with a user	Martín Marqués	08:49
[Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)]	Chris Ryan	12:45
Select most recent record?	Marc Sherman	13:28
Restricting the number of decimal digits	Srikanth Rao	13:34
Re: Select most recent record?	Tom Lane	14:35
Re: Select most recent record?	Andrew Perrin	14:43
Re: Select most recent record?	Tom Lane	14:50
RE: Select most recent record?	Michael Ansley (UK)	14:50
RE: Select most recent record?	Marc Sherman	14:52
oid and triggers	Adam Doligalski	14:56
To Run 2 database servers at the same time	Najm Hashmi	15:01
Re: Please dont flame	Nils Zonneveld	15:33
Re: To Run 2 database servers at the same time	Peter Eisentraut	15:51
Re: [Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)]	Stephan Szabo	17:19
Help! Record logging	Edwin S. Ramirez	17:30
case insensitive sort for output from SELECT	Stephen Patterson	19:21
"avg" function for arrays?	G. Anthony Reina	19:43
Re: Select most recent record?	George Moga	19:49
Re: fatal ERROR running simple join query...	Ligia Pimentel	21:29

May 17, 2001

Thread	Author	Time
Setting session global variables	Jonathan Bartlett	00:43
Re: Setting session global variables	Tom Lane	01:12
Re: Exp/Imp Problems...	Roberto Mello	01:22
Re: Give me a suggestion 'START WITH .. CONNECT BY'.	Roberto Mello	01:26
Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1	Forest Wilkinson	02:18
Re: Setting session global variables	Jonathan Bartlett	02:48
how to add an new record from part of an old one	juerg.rietmann	12:32
Re: how to add an new record from part of an old one 📎	George Moga	14:28
Setting session global variables 📎	Kyle	14:57

May 18, 2001

Thread	Author	Time
ON UPDATE CASCADE overhead?	Forest Wilkinson	00:19
has anyone tried running in MAC OS X	postgresql	00:48
Re: has anyone tried running in MAC OS X	Mike Castle	01:10
Re: has anyone tried running in MAC OS X	Tom Lane	05:20
Inherited tables: How stable is that feature?	Florian Weimer	08:13
Re: has anyone tried running in MAC OS X	Giorgio Valoti	08:46
HELP: what's wrong with my PL/PSQL function??	Bruno Boettcher	09:21
Re: has anyone tried running in MAC OS X	Justin Clift	09:47
Re: search for groups with a user	Martín Marqués	13:26
Re: ON UPDATE CASCADE overhead?	Jan Wieck	13:37
Calculating the age of a person	Hans-Jürgen Schönig	13:39
convert date to time?	speeves	14:28
Re: Inherited tables: How stable is that feature?	Tom Lane	15:15
Re: search for groups with a user	george young	15:35
Re: Calculating the age of a person	[email protected]	15:53
Re: has anyone tried running in MAC OS X	Peter Eisentraut	16:00
Help with ECPG on debian Potato	BOUCHPAN-LERUST-JUERY Lionel	17:48
are NEW and OLD rule attributes broken?	Forest Wilkinson	18:36
Re: are NEW and OLD rule attributes broken?	Tom Lane	19:20
Why indexes are not used when scanning from functions?	Ловпаче Айдамир	23:30

May 19, 2001

Thread	Author	Time
RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1	Mikheev, Vadim	00:28
Re: Help! Record logging	Richard Huxton	11:59
Re: HELP: what's wrong with my PL/PSQL function??	Richard Huxton	12:07
Re: HELP: what's wrong with my PL/PSQL function??	Tom Lane	14:58
Create an empty record	Per-Olof Pettersson	19:24
Re: Create an empty record	Per-Olof Pettersson	19:32
Re: Create an empty record	Stephan Szabo	20:45

May 20, 2001

Thread	Author	Time
Truncation of char, varchar, bit, varbit types (fwd)	Peter Eisentraut	00:36
Re: Truncation of char, varchar, bit, varbit types (fwd)	Joe Conway	01:26
timestamp bug	Cedar Cox	09:49
Re: Calculating the age of a person	Cedar Cox	10:07
Re: timestamp bug	Richard Huxton	12:29
Re: timestamp bug	Cedar Cox	13:42
problem while starting server ???	Subhramanya Shiva	17:16
Re: timestamp bug	Tom Lane	17:30
Re: timestamp bug	Alexander Dederer	19:34
PL/pgSQL problem with variables	Hans-Jürgen Schönig	19:34
Transposing data	Hans-Jürgen Schönig	19:42

May 21, 2001

Thread	Author	Time
Set Datestyle	Tubagus Nizomi	02:56
Re: [SQL] problem while starting server ???	Grant	05:26
Re: problem while starting server ??? (fwd)	Grant	05:35
Re: [SQL] problem while starting server ???	Tod McQuillin	05:37
Re: Transposing data	Alexander Dederer	06:39
Re: Transposing data	Hans-Jürgen Schönig	07:23
how to check presence of a function and set permissions?	Bruno Boettcher	08:33
Re: how to check presence of a function and set permissions?	Tod McQuillin	08:54
Re: Case insensitive string comparison?	Cedar Cox	09:15
Re: Case insensitive string comparison?	[email protected]	11:53
Re: HELP: what's wrong with my PL/PSQL function??	Jan Wieck	12:48
Re: Case insensitive string comparison?	Karel Zak	13:01
c++ wrapper library	LeoDeBeo	13:50
Need Help!!	Gurudutt	14:09
Re: HELP: what's wrong with my PL/PSQL function??	Tom Lane	14:16
Re: problem while starting server ???	Adam Haberlach	16:06
sequence problem	gabi munteanu	19:33
Re: sequence problem	Peter Eisentraut	20:24
how to set ownership of tables?	Bruno Boettcher	20:28
Re: sequence problem	Stephan Szabo	20:39
Define timestamp with no timezone	Sandhya Bellave	20:46

May 22, 2001

Thread	Author	Time
Re: how to check presence of a function and set permissions?	Bruce Momjian	04:15
Re: RULES	Martín Marqués	07:44
RULES	J.Fernando Moyano	09:56
Re: how to set ownership of tables?	Bruce Momjian	11:42
query PostgreSQL from c++	chris Gnther	13:18
Please help me....	waheed rahman	13:19
Re: Calculating the age of a person	Najm Hashmi	14:20
Re: RULES	Ross J. Reedstrom	14:53
Re: query PostgreSQL from c++	Peter Eisentraut	15:09
Re: Set Datestyle	Peter Eisentraut	15:36
Re: c++ wrapper library	Peter Eisentraut	16:09
RULES	J.Fernando Moyano	17:19

May 23, 2001

Thread	Author	Time
index/join madness	Michael Richards	05:15
implied rows when a rule gets executed.	J.Fernando Moyano	06:24
Recursive select	Martin Smetak	09:07
Re: Truncation of char, varchar, bit, varbit types (fwd)	J.H.M. Dassen Ray	13:04
Select question	Chris Ruprecht	13:23
Re: index/join madness	J.H.M. Dassen Ray	14:02
Re: index/join madness	David Olbersen	15:37
Re: Select question	Stephan Szabo	16:15
Re: Select question	Tom Lane	16:18
Re: index/join madness	Tom Lane	16:58
Difficult SQL Statement	Jim	17:20
Return cursor	Alla	18:20
Re: Why indexes are not used when scanning from functions?	Tom Lane	18:28

Browse Archives

Prev | Next