pgsql-sql before 2000-11-01 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

Oct. 11, 2000

Thread	Author	Time
Can I use subselect as a function parameter?	Oliver Elphick	13:42
Re: Can I use subselect as a function parameter?	Tom Lane	14:25
AFTER triggers, short question	Mark Volpe	14:49
Re: Can I use subselect as a function parameter?	Philip Warner	14:55
SQL to retrieve foreign keys	Colleen Williams	15:56
Re: SQL to retrieve foreign keys	Stephan Szabo	16:29
Referential integrity: broken rule?	Franz J Fortuny	19:18
Re: Referential integrity: broken rule?	Stephan Szabo	22:15

Oct. 12, 2000

Thread	Author	Time
set digest	karasiov	08:51
if else query help	Brian C. Doyle	14:14
Re: dynamic object creation	Mark Volpe	14:22
Re: if else query help	Jean-Christophe Boggio	14:56
Re: if else query help	Josh Berkus	15:35
Re: if else query help	Jie Liang	17:36
Standard syntax?	Franz J Fortuny	17:44
Re: Standard syntax?	Josh Berkus	17:54
Re: Standard syntax?	Tomas Berndtsson	17:54
Re: Standard syntax?	Jie Liang	18:19
Re: if else query help	John McKown	18:37
Re: Standard syntax?	Peter Eisentraut	18:45
Re: Standard syntax?	Tom Lane	19:32
dynamic object creation	Indraneel Majumdar	19:56
xml perl & pgsql	Philip Cook	21:50
Problem whith Stored queries	Nelson Brito	22:49

Oct. 13, 2000

Thread	Author	Time
Operator Column	Itai Zukerman	11:20
Re: dynamic object creation	Indraneel Majumdar	21:10
Re: dynamic object creation	Indraneel Majumdar	21:11

Oct. 15, 2000

Thread	Author	Time
Variable-length Types	Itai Zukerman	14:00
Re: Variable-length Types	Josh Berkus	18:31
Re: Regular expression query	Bruce Momjian	18:50
Re: Variable-length Types	Tom Lane	20:26
Re: Variable-length Types	Josh Berkus	20:36
Re: Variable-length Types	Itai Zukerman	20:58
Re: Variable-length Types	KuroiNeko	21:17

Oct. 16, 2000

Thread	Author	Time
Re: Variable-length Types	Josh Berkus	00:39
Re: Variable-length Types	Josh Berkus	02:10
Re: Variable-length Types	Bruce Momjian	02:22
Antw: many-many mapping between unique tables	Gerhard Dieringer	06:57
Re: Antw: many-many mapping between unique tables	Gerhard Dieringer	08:09
Re: JDBC Performance	Josh Berkus	15:13
Re: Antw: many-many mapping between unique tables	KuroiNeko	15:14
Re: Antw: many-many mapping between unique tables	Josh Berkus	15:17
many-many mapping between unique tables	Indraneel Majumdar	18:11
JDBC Performance	Craig May	19:49
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	20:13
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	21:39
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	21:54
Formatting US phone numbers, was Variable-length Types	KuroiNeko	22:01
Re: many-to-many mapping	K Parker	22:49

Oct. 17, 2000

Thread	Author	Time
Re: Antw: many-many mapping between unique tables	Indraneel Majumdar	05:19
Last serial number inserted	Eduardo	10:16
Re: Last serial number inserted	Josh Berkus	15:47
Re: Variable-length Types	DalTech - CTE	16:54
nested transactions 📎	Bernie Huang	18:02
Big Sub-select statement 📎	Bernie Huang	18:53
problem with select where like ']'	hubert depesz lubaczewski	19:02
Re: JDBC Performance	Peter Mount	19:23
Re: problem with select where like ']'	Tom Lane	19:33
Re: problem with select where like ']'	KuroiNeko	20:07
Re: nested transactions	Bruce Momjian	20:49
Re: nested transactions	John Hasler	22:25
Re: problem with select where like ']'	Joseph Shraibman	22:43
Re: problem with select where like ']'	Tom Lane	23:29
RE: nested transactions	Mikheev, Vadim	23:37
Re: problem with select where like ']'	Bruce Momjian	23:43
Re: problem with select where like ']'	Joseph Shraibman	23:53

Oct. 18, 2000

Thread	Author	Time
Re: problem with select where like ']'	Vince Vielhaber	00:00
Re: problem with select where like ']'	Bruce Momjian	00:05
Function that returns a tuple.	Claudio Jose Zanardi Grillo	13:32
Re: problem with select where like ']'	Peter Eisentraut	15:24
Re: Function that returns a tuple.	Josh Berkus	15:36
Re: Function that returns a tuple.	Tom Lane	16:32

Oct. 19, 2000

Thread	Author	Time
substr	Jeff MacDonald	13:19
Re: substr	Tom Lane	14:50
Re: substr	Jeff MacDonald	16:05
Re: COUNT	Frank Bax	18:05
Re: COUNT	Brian C. Doyle	18:07
Re: COUNT	Jie Liang	18:13
Re: COUNT	Daniel Wickstrom	18:30
Re: COUNT	bmccoy	18:35
Conditional query plans.	Michael Richards	21:01
what is the best way to set-up keywords in tables and Queries ?	lesstif	23:20
Re: Conditional query plans.	Tom Lane	23:49

Oct. 20, 2000

Thread	Author	Time
"too big" transactions	Edmar Wiggers	00:59
COUNT	Craig May	04:58
help on creating table	pgsql-sql	10:48
Re: Conditional query plans.	Continuing Technical Education	12:16
Re: what is the best way to set-up keywords in tables and Queries ?	Keith Kratochvil	13:52

Oct. 21, 2000

Thread	Author	Time
Help: Using a regular expression match as a value	Richard DeVenezia	14:18

Oct. 22, 2000

Thread	Author	Time
Re: foreign key introduces unnecessary locking ?	Jan Wieck	12:26

Oct. 23, 2000

Thread	Author	Time
[No subject]	jan.bajerski	15:11
Re:	Stephan Szabo	16:30
Re:	Tomas Berndtsson	16:44
Need info: pl/pgsql performance	najm Hashmi	17:25
Re:	bmccoy	18:09
Re: foreign key introduces unnecessary locking ?	Vadim Mikheev	18:22
Re: SQL	Josh Berkus	19:04
Re: foreign key introduces unnecessary locking ?	Vadim Mikheev	21:29
Re: Postgresql Site Search	The Hermit Hacker	23:52

Oct. 24, 2000

Thread	Author	Time
Re: Large Objects	pgsql-sql	03:29
Large Objects	Craig May	10:07
Postgresql Site Search	Craig May	10:37
Re: Help: Using a regular expression match as a value	[email protected]	10:47
Like Query on BLOB's	Craig May	13:21
Permission and users	Ferruccio Zamuner	13:49
knowing which columns have beend UPDATEd inside a TRIGGER?	Louis-David Mitterrand	13:55
Re: NULL	Sandis Jerics	18:31
Alternate Database Locations	Brian C. Doyle	18:40
Error in Extrack Database	Tubagus Nizomi	19:06
Re: [SQL] Re: NULL	Mark Volpe	20:39
Re: help on creating table	Albert REINER	21:15
Re: Error in Extrack Database	Poul L. Christiansen	21:22
Re: help on createing table	Josh Berkus	22:05
Re: Help on Union Query	Josh Berkus	22:06
Re: knowing which columns have beend UPDATEd inside a TRIGGER?	Tom Lane	22:51
Re: Alternate Database Locations	Brian C. Doyle	23:00

Oct. 25, 2000

Thread	Author	Time
Help on Union Query	Craig May	04:44
quote in function	Carolyn Lu Wong	05:03
Re: knowing which columns have beend UPDATEd inside a TRIGGER?	Louis-David Mitterrand	06:23
Re: knowing which columns have beend UPDATEd inside a TRIGGER?	Tomas Berndtsson	07:21
Get a time from a char column	Blaise Carrupt	10:48
How to Return number of rows updated in stored procedure	Shane McEneaney	16:03
Re: How to call a shell command in rule	Clayton Cottingham	16:16
Surprising sequence scan when function call used	Will Fitzgerald	17:26
How to call a shell command in rule	Jie Liang	17:44
Add Constraint	Sivagami .	17:51
Re: Alternate Database Locations	Roderick A. Anderson	19:04
Re: Alternate Database Locations	Brian C. Doyle	19:20
Re: Problem whith Stored queries	Jie Liang	23:07

Oct. 26, 2000

Thread	Author	Time
Query Problem	Josh Berkus	01:59
plperl	Jie Liang	02:08
Re: Alternate Database Locations	Tom Lane	02:43
Re: Alternate Database Locations	indraneel	02:54
Re: Surprising sequence scan when function call used	Tom Lane	03:22
Re: Surprising sequence scan when function call used	Hosokawa Tetsuichi	04:08
Re: plperl	Tom Lane	04:09
Re: How to call a shell command in rule	Jie Liang	05:27
Re: Add Constraint	Stephan Szabo	05:47
Re: Alternate Database Locations	Brian C. Doyle	10:08
pg_atoi: error in "template1": can't parse "template1"	Dronamraju Rajesh	12:17
Re: Query Problem	Tomas Berndtsson	13:53
Re: Alternate Database Locations	Tom Lane	14:02
HELP! ... pg_locale ???	Sandis Jerics	14:48
Nested Aggregate fonction & gouping attributes	Pitot	14:53
Re: Alternate Database Locations	Brian C. Doyle	14:56
Re: [SQL] pg_atoi: error in "template1": can't parse "template1"	Tom Lane	15:00
Re: Query Problem	Tom Lane	15:16
Re: Alternate Database Locations	Tom Lane	15:21
Re: Query Problem	Stephan Szabo	15:22
"average" time	Ulf Mehlig	15:24
Re: plperl	Peter Eisentraut	15:48
Re: Query Problem	Josh Berkus	17:55
Re: Alternate Database Locations	indraneel	18:04
Re: Alternate Database Locations	Peter Eisentraut	19:12

Oct. 27, 2000

Thread	Author	Time
renaming columns... danger?	Michael Teter	05:01
Re: HELP! ... pg_locale ???	Tom Lane	05:33
Re: HELP! ... pg_locale ???	Tom Lane	05:33
except on nulls?	Daniel Kalchev	06:02
Re: [SQL] renaming columns... danger?	Grant Finnemore	08:30
Re: [SQL] renaming columns... danger?	Grant Finnemore	08:30
Re: renaming columns... danger?	Emils Klotins	09:00
Re: renaming columns... danger?	Emils Klotins	09:00
benchmarks	Clayton C.	11:36
Re: except on nulls?	Tom Lane	14:39
Re: except on nulls?	Tom Lane	14:39
<database>.<table_name>	Sivagami .	21:03

Oct. 28, 2000

Thread	Author	Time
Re: benchmarks	KuroiNeko	03:54
Re: benchmarks	Josh Berkus	06:24
Re: benchmarks	KuroiNeko	21:00

Oct. 29, 2000

Thread	Author	Time
RE: benchmarks 📎	Edmar Wiggers	04:00
Re: benchmarks	[email protected]	14:53

Oct. 30, 2000

Thread	Author	Time
pgsql-sql list should now work again ...	The Hermit Hacker	00:37
select with function per row	Marcin Mazurek	09:02
[No subject]	Lengyel Ferenc	12:36
Large Object dump ?	Alessandro Rossi	12:42
RE:	Schlobohm, Jack	12:52
Re:	Yury Don	12:55
Synonyms	Carl Shelbourne	13:17
Re: Large Object dump ?	Alessandro Rossi	14:11
[No subject]	Petr Jezek	14:20
Re:	Philip Warner	14:31
unsubscribe	Vadim Govorov	14:39
Re: Large Object dump ?	[email protected]	15:19
unsubscribe 📎	Schlobohm, Jack	15:28
fetching rows	Nikolay Mijaylov	16:27
Re: Synonyms	Peter Eisentraut	16:44
Re: fetching rows	K Parker	18:58
Re: fetching rows	Jeff Hoffmann	19:02
Re: fetching rows	Martin Christensen	22:07

Oct. 31, 2000

Thread	Author	Time
Re: Synonyms	hubert depesz lubaczewski	07:16
PLPGSQL examples	Kovacs Zoltan Sandor	11:30
Re: fetching rows	Decio Fonini	12:54
Need help! parse erro	Najm Hashmi	15:39
INSERT [IGNORE] INTO TABLE	Petr Jezek	16:05
Re: Need info: pl/pgsql performance	Kovacs Zoltan Sandor	16:20
RE: INSERT [IGNORE] INTO TABLE	Edmar Wiggers	16:31
RE: INSERT [IGNORE] INTO TABLE	Petr Jezek	17:04
RE: INSERT [IGNORE] INTO TABLE	Edmar Wiggers	17:19
RE: INSERT [IGNORE] INTO TABLE	K Parker	19:42
Problem with coalesce..	George Henry C. Daswani	21:52

Browse Archives

Prev | Next