pgsql-sql since 2001-06-21 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

June 21, 2001

Thread	Author	Time
Re: commentds on redhats new database	Tom Lane	05:32
Re: commentds on redhats new database	Ross J. Reedstrom	05:45
plsql in 7.1	Jie Liang	06:03
Re: set datestyle to European PROBLEM	Roelof Sondaar	09:06
Re: Extracting date from epoche	Richard Huxton	09:11
Re: pl/pgsql question (functions)	Richard Huxton	09:25
Re: select by streak	Richard Huxton	09:29
Problem by inserting rows in a table via function	DI Hasenöhrl	11:13
Re: Extracting date from epoche	Tom Lane	14:05
Re: Using the extract() function in plpgsql	Richard Huxton	14:28
RE: arguments for query files	Jeff Eckermann	14:48
Correct syntex for implicit curor in for loops	Najm Hashmi	15:43
Re: Correct syntex for implicit curor in for loops	Jan Wieck	16:15
Problem with installing Postgresql 7.1.1	Wei Weng	16:45
Re: Correct syntex for implicit curor in for loops	Josh Berkus	16:46
case, new column not found	Martín Marqués	17:02
Changing PL/pgSQL triggers	James Orr	17:30
Re: Correct syntex for implicit curor in for loops	Jan Wieck	17:35
Re: Extracting date from epoche	Richard Huxton	17:47
Re: Changing PL/pgSQL triggers	Roberto Mello	17:50
Re: Correct syntex for implicit curor in for loops	Tom Lane	17:54
Re: Changing PL/pgSQL triggers	Alain Lavigne	18:10
Re: select by streak	Joseph Shraibman	19:04
RE: Select most recent record?	Marc Sherman	19:27
Re: Changing PL/pgSQL triggers	Josh Berkus	19:31
RE: Select most recent record?	Mark Hamby	20:50
Re: Re: binary data	Hugh Mandeville	21:29
Re: case, new column not found	Stephan Szabo	23:46
Re: case, new column not found	Tom Lane	23:49
Re: case, new column not found	Josh Berkus	23:53

June 22, 2001

Thread	Author	Time
Re: Re: binary data	Hugh Mandeville	02:43
Re: Changing PL/pgSQL triggers	Kristoff Bonne	07:22
Difference between insert a tuple in a table by function and by datasheet	DI Hasenöhrl	07:23
distinguishing different database connections	Markus Wagner	07:59
RE: Difference between insert a tuple in a table by function and by datasheet	Cyril Slucki	08:02
Re: pl/pgsql question (functions)	Kristoff Bonne	08:09
Incremental sum ?	Domingo Alvarez Duarte	08:16
RE: Difference between insert a tuple in a table by function and by datasheet	Hiroshi Inoue	08:17
Dump db with LO	vincent	08:20
Re: Difference between insert a tuple in a table by function and by datasheet	Dariusz Pietrzak	08:25
Re: [SQL] distinguishing different database connections	Christof Glaser	08:38
Re: pl/pgsql question (functions)	Richard Huxton	10:51
Re: [SQL] distinguishing different database connections	Alex Pilosov	11:57
select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1	Markus Bertheau	12:06
CAST Problem: Difference between insert a tuple in a table by function and by datasheet	DI Hasenöhrl	12:14
What is a "tuple"	Kristoff Bonne	12:51
Re: Help with a double left join	Alex Pilosov	13:41
RE: Help with a double left join	Ari Nepon	13:43
Re: select tbl1.attr1, number of tuples where tbl2.attr1=tbl1.attr1	Tom Lane	13:54
Re: Re: Re: binary data	Tom Lane	14:22
View performance question	Josh Berkus	15:07
Re: Help with a double left join	Tom Lane	15:15
Re: firehouse	Ross J. Reedstrom	15:17
Re: What is a "tuple"	Alex Pilosov	15:27
Re: Incremental sum ?	Alex Pilosov	15:29
Re: View performance question	Alex Pilosov	15:34
Re: Re: Re: binary data	Karel Zak	15:35
Re: Re: Re: binary data	Tom Lane	15:40
Re: Difference between insert a tuple in a table by function and by datasheet	Richard Huxton	16:08
Re: Incremental sum ?	Ross J. Reedstrom	16:21
Re: What is a "tuple"	Kristoff Bonne	16:31
unregister	Porfirio Córdoba	16:31
Re: View performance question	Josh Berkus	16:48
Re: cache lookup failed ???? What is it ???!!!	Peter Eisentraut	16:56
Re: Incremental sum ?	Tom Lane	16:58
Re: View performance question	Alex Pilosov	17:00
Re: firehouse	Bruce Momjian	17:04
Re: View performance question	Tom Lane	17:05
Re: Incremental sum ?	Ross J. Reedstrom	17:18
Re: What is a "tuple"	Ross J. Reedstrom	17:28
Re: View performance question	Tom Lane	17:58
timestamp conversion to unisgned long?	pierre	18:08
Re: View performance question	Josh Berkus	18:37
Re: [SQL] distinguishing different database connections	Stephan Szabo	18:40
Re: timestamp conversion to unisgned long?	Alex Pilosov	18:46
NOTIFY "string" from rule	Jeff Boes	19:18
Re: timestamp conversion to unisgned long?	Peter Eisentraut	19:19
cache lookup failed ???? What is it ???!!!	J.Fernando Moyano	21:10
Re: View performance question	Tom Lane	21:11

June 23, 2001

Thread	Author	Time
day difference	Jackie Siu	03:31
Re: Re: Re: binary data	Bruce Momjian	14:02
RE: firehouse	Magnus Hagander	16:39

June 25, 2001

Thread	Author	Time
When using COPY	datactrl	00:55
Foreign key problem	Andreas Tille	07:34
Plsql Function with error: No space left on device. 📎	David M. Richter	08:50
Re: Plsql Function with error: No space left on device.	Richard Huxton	10:23
Re: [SQL] Difference between insert a tuple in a table by function and by datasheet	DI Hasenöhrl	10:26
Re: What is a "tuple"	Jan Wieck	11:32
Re: Foreign key problem	Christof Glaser	14:06
Re: Foreign key problem	Itai Zukerman	14:07
Problems using a rule with the WHERE clause	Luis Sousa	15:08
Re: Foreign key problem	Stephan Szabo	16:22
control structure in a transaction block?	Wei Weng	17:19
Re: Problems using a rule with the WHERE clause	Tom Lane	18:01
Re: select with multiple occurences in same table	Josh Berkus	22:37

June 26, 2001

Thread	Author	Time
select with multiple occurences in same table	William Herring	00:08
pl/pgSQL and escaping LIKE clauses	Robby Slaughter	00:50
loosing connection after function call	Markus Wagner	05:52
Changing datatype of a column	Ilan Fait	07:41
Re: Problems using a rule with the WHERE clause	Luis Sousa	09:52
TEXT field size	Antti Linno	11:32
Re: Plsql Function with error: No space left on device. 📎	David M. Richter	11:32
Re: Plsql Function with error: No space left on device. 📎	David M. Richter	13:24
Re: Plsql Function with error: No space left on device.	Richard Huxton	13:32
Re: TEXT field size	Richard Huxton	13:34
ConnecDB() -- couldn't send SSL negotiation packet:	Bhuvan A	13:54
Nested Transactions	John Hasler	14:29
Re: [SQL] loosing connection after function call	Tom Lane	14:32
Re: Problems using a rule with the WHERE clause	Tom Lane	14:41
Re: Changing datatype of a column	Peter Eisentraut	14:43
Re: Plsql Function with error: No space left on device.	Tom Lane	14:54
simple function crashes my postmaster	Meggus	15:34
Re: Changing datatype of a column	Jason Earl	16:28
Re: Using the extract() function in plpgsql	Kristis Makris	19:58
Text manipulation in SQL	Jim	21:59
Storing image contents in TEXT fields	Jerome Alet	22:11
how to limit user to open another session	Jie Liang	22:23
Re: Storing image contents in TEXT fields	Alex Pilosov	22:34
Cast varchar to interval in plpgsql	Sergei Pohilko	23:15

June 27, 2001

Thread	Author	Time
strange plan	Craig Longman	05:28
Re: strange plan	Craig Longman	05:45
session detect and terminate	Jie Liang	06:57
Re: Using the extract() function in plpgsql	Richard Huxton	07:17
Re: Plsql Function with error: No space left on device. 📎	David M. Richter	11:51
Re: Plsql Function with error: No space left on device. 📎	David M. Richter	13:06
filtering	sbelow	13:43
Re: Plsql Function with error: No space left on device.	Tom Lane	14:07
Re: Storing image contents in TEXT fields	Jan Wieck	15:17
Re: Text manipulation in SQL	Jim	15:24
Re: Using the extract() function in plpgsql	Kristis Makris	15:55
Re: Storing image contents in TEXT fields	Jerome Alet	17:48
Re: Using the extract() function in plpgsql	Richard Huxton	18:30
Re: Storing image contents in TEXT fields	Jan Wieck	19:10
Re: Using the extract() function in plpgsql	Kristis Makris	19:25
Re: Using the extract() function in plpgsql	Tom Lane	20:04
Re: Using the extract() function in plpgsql	Kristis Makris	20:51
Subquery error. Help please!!	kakerjak	21:09

June 28, 2001

Thread	Author	Time
Re: Re: Re: binary data	Hugh Mandeville	02:34
Link many attributes in one table to one attribute in another??	Christian Anton	04:44
Re: Problems using a rule with the WHERE clause 📎	Luis Sousa	10:13
Using DateDiff with Postgres	Jeff Rhys-Jones	11:01
[No subject]	Ilan Fait	14:14
Re: Link many attributes in one table to one attribute in another??	Richard Huxton	14:31
examine the database	Ilan Fait	14:34
Re: Using DateDiff with Postgres	Richard Huxton	14:44
Re: Link many attributes in one table to one attribute in another??	Christof Glaser	14:45
Re: Subquery error. Help please!!	Wei Weng	14:46
Re: Subquery error. Help please!!	Tom Lane	14:54
Re: Link many attributes in one table to one attribute in another??	Wei Weng	15:10
Re: filtering	Josh Berkus	15:46
Re: Problems using a rule with the WHERE clause	Tom Lane	15:55
Re: Subquery error. Help please!!	Ross J. Reedstrom	17:11
Re: Using DateDiff with Postgres	Josh Berkus	17:15
Re: Re: Re: Re: binary data	Alex Pilosov	17:20
restoring a dump	Phuong Ma	18:13
timeout	Jie Liang	18:56
Still stuck on a left join	Ari Nepon	19:51
Re: timeout	Jeremy Buchmann	20:24
Re: restoring a dump	Peter Eisentraut	21:27
Re: Still stuck on a left join	Josh Berkus	22:39
Re: restoring a dump	Phuong Ma	23:32

June 29, 2001

Thread	Author	Time
Re: restoring a dump	Wei Weng	00:59
RE:	tamsin	12:40
Re: day difference	Josh Berkus	14:43
Re: NOTIFY "string" from rule	Tom Lane	14:46
Evaluating Subselects	Josh Berkus	15:02
create datatype	Craig Longman	15:36
RE: Evaluating Subselects	Jeff Eckermann	15:52
Re:	Thomas T. Veldhouse	15:58
Re:	Thomas T. Veldhouse	16:31
Re:	Thomas T. Veldhouse	17:27
Re:	Jan Wieck	17:33
Re: Plain text vs HTML mail	Tom Lane	18:01
Re:	Bruce Momjian	18:31
Re:	GH	18:37
Re: (was: )	Bruce Momjian	18:43
Re: (was: )	Jan Wieck	18:47
Re: Help!!! Trying to "SELECT" and get a tree structure back.	--CELKO--	19:06
creating variable views	Dado Feigenblatt	19:29

June 30, 2001

Thread	Author	Time
Re: day difference	Christopher Sawtell	04:14
Re: creating variable views	Richard Huxton	11:49
Date validation? 📎	Josh Berkus	21:08

July 1, 2001

Thread	Author	Time
Re: creating variable views	Dado Feigenblatt	00:04
RE:creating variable views	Josh Berkus	05:09
My First Function	Gary Stainburn	15:30
Re: My First Function	omid omoomi	16:39
WAL_FILES?	Josh Berkus	19:21
Re: WAL_FILES?	Peter Eisentraut	19:44
Re: WAL_FILES?	Josh Berkus	21:03

July 2, 2001

Thread	Author	Time
Multiple Indexes	Dennis	15:36
Re: need oracle ROWNUM equivalent	--CELKO--	20:56
Null set	Wei Weng	21:57
A free ODBC client to use with any database.	Petarian	22:54
How do I print a message in a function?	Wei Weng	23:46

July 3, 2001

Thread	Author	Time
Re: How do I print a message in a function?	Jie Liang	00:59
traversing foreign key relationships between tables	Markus Wagner	06:46
indexing arrays in pgaccess's query interface is failing	David Stanaway	09:05
problem with date/time constants	datactrl	12:44
Re: problem with date/time constants	David Stanaway	13:03
Re: problem with date/time constants	Alex Pilosov	13:08

Browse Archives

Prev | Next