pgsql-sql - July 2000

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

July 1, 2000

Thread	Author	Time
Median	Kermani, Bahram	00:37
Re: Which procedural language to use for functions.	Jan Wieck	09:03
function	Andrey	15:56

July 2, 2000

Thread	Author	Time
Query about using arrays (for accessing pg_group)	Greg Wickham	07:20
Re: retrieving a serial number	Joachim Trinkwitz	12:28
Re: Query about using arrays (for accessing pg_group)	Tom Lane	16:38

July 3, 2000

Thread	Author	Time
Re: case insensitive search	[email protected]	06:58
Antw: plpgsql function gets wierd with Null parameters	Gerhard Dieringer	07:42
Re: trigger or something else?	Grant Finnemore	09:34
Re: Antw: plpgsql function gets wierd with Null parameters	Tom Lane	14:16
[No subject]	emils	14:40
Need Help With Dates.	John	17:40
Re: Need Help With Dates.	Thomas Lockhart	18:11
maintain number in variable	Andrey	18:14
Re: case insensitive search	Mitch Vincent	19:46

July 4, 2000

Thread	Author	Time
LEFT JOIN	Antti Linno	12:15
Antw: LEFT JOIN	Gerhard Dieringer	12:46
Re: Antw: LEFT JOIN	Antti Linno	13:34
Re: Antw: LEFT JOIN	Erol Oz	14:54
ODP: Antw: LEFT JOIN	Rybarczyk Mikolaj	15:16
Re: Antw: LEFT JOIN	Tom Lane	19:43

July 5, 2000

Thread	Author	Time
ERROR: ExecEvalAggref: no aggregates in this expression context	Paul McGarry	00:37
Re: Median	omid omoomi	08:38
Antw: Problem with joins	Gerhard Dieringer	10:31
GROUP by	Antti Linno	11:14
Re: GROUP by	Jerome Alet	11:50
Re: GROUP by	Jesus Aneiros	11:52
Group BY ...(cont.)	Antti Linno	12:01
Antw: GROUP by	Gerhard Dieringer	12:11
Re: Group BY ...(cont.)	[email protected]	12:15
Re: Group BY ...(cont.)	Jesus Aneiros	12:17
PLPGSQL - does not support more than 8 args?	Grigori Soloviov	12:23
GROUP by finish&&last day of month	Antti Linno	12:32
Re: GROUP by finish&&last day of month	Jerome Alet	12:46
Aww, sorry (last day of month)	Antti Linno	12:55
Re: GROUP by finish&&last day of month	[email protected]	13:00
Re: Problem with joins	Thomas Lockhart	14:34
Re: Aww, sorry (last day of month)	Thomas Lockhart	14:51
bug in using index scans?	Martin, Sylvain R. (LNG)	14:56
Re: GROUP by finish&&last day of month	Patrick Jacquot	15:00
RE: bug in using index scans? More Investigating	Martin, Sylvain R. (LNG)	15:04
Help! PLPGSQL and PGSQL - does not support more than 8 arguments for a function?	Grigori Soloviov	15:16
lztext and compression ratios...	Jeffery Collins	16:59
Re: ERROR: ExecEvalAggref: no aggregates in this expression context	Tom Lane	17:15
Re: lztext and compression ratios...	Tom Lane	18:12
PostgreSQL 7.1	Mitch Vincent	18:39
Re: PostgreSQL 7.1	The Hermit Hacker	18:49
Re: PostgreSQL 7.1	Tom Lane	20:02
Re: PostgreSQL 7.1	Jan Wieck	20:41
Re: lztext and compression ratios...	Jan Wieck	22:16
Re: lztext and compression ratios...	Tom Lane	22:40

July 6, 2000

Thread	Author	Time
Re: lztext and compression ratios...	Jeffery Collins	00:07
Re: ERROR: ExecEvalAggref: no aggregates in this expressioncontext	Paul McGarry	00:59
Re: ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext 📎	Paul McGarry	02:45
ALTER TABLE ADD COLUMN syntax question.	Robert B. Easter	03:51
Re: ERROR: ExecEvalAggref: no aggregates in this expressioncontext	Tom Lane	04:44
Re: ERROR: ExecEvalAggref: no aggregates in thisexpressioncontext 📎	Paul McGarry	05:19
Re: lztext and compression ratios...	Jan Wieck	08:47
Re: lztext and compression ratios...	Tom Lane	14:22
hierar questions	Andrey	15:05
Running queries from scripts.	DalTech - Continuing Technical Education	15:50
Re: Running queries from scripts.	Margarita Barvinok	15:58
Re: Running queries from scripts.	DalTech - Continuing Technical Education	16:16
confused by select.	John	20:17
Re: confused by select.	Brett W. McCoy	20:38
Get: Month & Month-1 & Month+1	Ebbe Poulsen	20:59
Re: confused by select.	Richard	21:05
Re: [SQL] Re: lztext and compression ratios...	Jan Wieck	21:09
Re: confused by select.	Jan Wieck	21:31
Re: PostgreSQL 7.1	Bruce Momjian	21:35

July 7, 2000

Thread	Author	Time
maximum TEXT length?	Dnesbitt	00:47
Re: confused by select.	Brett W. McCoy	01:12
MAX() of 0 records.	Paul McGarry	01:44
Re: MAX() of 0 records.	Tom Lane	03:29
Re: lztext and compression ratios...	Tom Lane	05:30
Re: [SQL] MAX() of 0 records. 📎	Paul McGarry	05:34
Re: [SQL] MAX() of 0 records.	Tom Lane	07:06
Ancient postgres+EXCEPT	Antti Linno	07:10
Re: MAX() of 0 records.	benoit	08:32
Re: [SQL] MAX() of 0 records.	Paul McGarry	08:54
Re: [SQL] MAX() of 0 records. 📎	Paul McGarry	09:00
Search for underscore w/ LIKE	brianb-pgsql	09:09
Re: MAX() of 0 records. 📎	Paul McGarry	09:37
Re: confused by select.	Patrick Jacquot	09:44
Re: MAX() of 0 records.	DalTech - Continuing Technical Education	12:44
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	eisentrp	13:14
Altnerate Column Return Names	Thomas Swan	13:46
Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Chris Bitmead	15:35
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Tom Lane	15:56
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Bruce Momjian	16:02
Re: Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Tom Lane	16:35
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Tom Lane	16:52
Re: Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Robert B. Easter	16:53
order by accents?	Patrick Coulombe	16:53
Re: Re: [SQL] MAX() of 0 records.	Tom Lane	17:12
Re: Search for underscore w/ LIKE	Tom Lane	17:33
date comparision	sandis	18:07
Re: Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Tom Lane	18:12
Re: Search for underscore w/ LIKE	Tom Lane	18:21
Re: order by accents?	Web Manager	18:23
Re: Search for underscore w/ LIKE	Bruce Momjian	18:24
Re: confused by select.	Antoine Reid	19:32
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Jan Wieck	19:47
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Tom Lane	21:56

July 8, 2000

Thread	Author	Time
Re: Altnerate Column Return Names	Peter Eisentraut	00:09
Re: Search for underscore w/ LIKE	Peter Eisentraut	00:09
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Peter Eisentraut	00:16
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Philip Warner	01:16
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Bruce Momjian	01:19
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Tom Lane	01:49
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Bruce Momjian	01:54
How to get a self-conflicting row level lock?	Forest Wilkinson	01:58
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Philip Warner	02:00
RE: How to get a self-conflicting row level lock?	Mikheev, Vadim	02:03
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Tom Lane	02:18
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Tom Lane	02:28
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Philip Warner	02:56
Supported Encoding	Tony Nakamura	03:35
Re: How to get a self-conflicting row level lock?	Tom Lane	04:40
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios....	Jan Wieck	11:29

July 9, 2000

Thread	Author	Time
Re: [SQL] MAX() of 0 records.	Tom Lane	18:35

July 10, 2000

Thread	Author	Time
Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Philip Warner	00:24
Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Tom Lane	01:21
Re: [HACKERS] Re: [SQL] MAX() of 0 records.	Philip Warner	01:43
CREATE TABLE with foreign key and primary key	Paulo Roberto Siqueira	01:49
m4 macros plus PostgreSQL anyone?	andrew	02:48
Re: m4 macros plus PostgreSQL anyone?	K Parker	04:10
Counting affected rows	Przem Kowalczyk	07:51
Re: date comparision ???	sandis	08:52
Re: CREATE TABLE with foreign key and primary key	Oliver Elphick	09:16
Re: Counting affected rows	Holger Klawitter	09:36
Type conversion	Ice Planet	11:40
Corruption... please help	Ed	13:18
Re: Corruption... please help	Bruce Momjian	13:27
Re: Type conversion	Thomas Lockhart	14:24
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Jan Wieck	15:11
Subselects with IN and EXISTS	Dorin Grunberg	17:21
Re: SERIAL type does not generate new ID ?	Ed Loehr	18:08
problem with date	Shalini shikha	18:15
Re: problem with date	DalTech - Continuing Technical Education	18:17
Timestamp problem 📎	Bernie Huang	18:52
Re: Matching and Scoring with multiple fields	Tim Johnson	18:56
Re: Timestamp problem	Ed Loehr	19:07
Re: Re: Matching and Scoring with multiple fields	Oliver Mueschke	20:14
Re: Re: Matching and Scoring with multiple fields	Ed Loehr	21:31
Re: Re: [SQL] Re: [GENERAL] lztext and compression ratios...	Bruce Momjian	21:32
Error : Unknown address family (0)	Ed	21:58
importing in sql	Abdul Karim	22:03

July 11, 2000

Thread	Author	Time
Finding entries not in table..differnce?	Zot O'Connor	00:29
Re: Finding entries not in table..differnce?	Stephan Szabo	00:43
Re: Finding entries not in table..differnce?	Erol Oz	00:50
Creating timestamps in queries?	Rob S.	05:26
Re: Creating timestamps in queries?	Patrik Kudo	07:07
SQL-92 SQLSTATE in PostgreSQL ?!	Adam Walczykiewicz	07:16
Checking for existence of table	Paul McGarry	07:28
Change type of column	Volker Paul	07:31
Re: Supported Encoding	Volker Paul	07:38
RE: Change type of column	Rob S.	15:45

July 12, 2000

Thread	Author	Time
Re: Creating timestamps in queries?	Frank Bax	00:39
RE: Creating timestamps in queries?	Rob S.	01:07
Re: Supported Encoding	Toshihide Tony Nakamura	02:44
Opposite of LOCK	Antti Linno	08:11
Re: Opposite of LOCK	Jan Wieck	11:41
Re: SERIAL type does not generate new ID ?	Jean-Marc Libs	14:02
Re: join if there, blank if not	Jacques Williams	14:41
join if there, blank if not	Gary Stainburn	15:34
Bug in to_char()	Brian Powell	16:24
Re: date comparision ???	Ross J. Reedstrom	16:55
Re: Opposite of LOCK	Tom Lane	17:06
SQL	DATAPUC-Frederico Papatella Guerino	17:11
Re: importing in sql	Ross J. Reedstrom	17:55
Re: importing in sql	jmr	18:19
RE: join if there, blank if not	Henry Lafleur	18:51

July 13, 2000

Thread	Author	Time
RE: Re: Matching and Scoring with multiple fields	Tim Johnson	00:13
Antw: RE: join if there, blank if not	Gerhard Dieringer	07:01
Re: lztext and compression ratios...	Tom Lane	07:07
Re: lztext and compression ratios...	Hannu Krosing	07:39
Re: Bug in to_char()	Karel Zak	08:56
Re: join if there, blank if not	Patrick Jacquot	10:59
RE: join if there, blank if not	Henry Lafleur	13:11
update some elements in the array 📎	Bernie Huang	16:48
Re: update some elements in the array 📎	Bernie Huang	17:55
Re: update some elements in the array	Tom Lane	18:22

July 14, 2000

Thread	Author	Time
case-sensitivity and the serial type	John BEPPU	09:21
nevermind...	John BEPPU	09:28
Trigger	Carolyn Lu Wong	14:11
Re: nevermind...	Tom Lane	15:09
Re: Trigger	Tom Lane	15:49
transactions within stored procedures	Nathan Young	16:02
Re: transactions within stored procedures	Thomas Mack	16:19

July 15, 2000

Thread	Author	Time
Applying SUM twice in the same query.	Rodger Donaldson	05:31
Re: Applying SUM twice in the same query.	Tom Lane	15:59
Select by priority	Prasanth A. Kumar	17:11

July 16, 2000

Thread	Author	Time
Re: Select by priority	omid omoomi	00:51
Re: Select by priority	Prasanth A. Kumar	08:15
Re: Select by priority	Peter Eisentraut	14:45
How to get count of rows in cursor	Robert B. Easter	22:02

July 17, 2000

Thread	Author	Time
SQL question	Carolyn Lu Wong	02:07
Re: SQL question	Philip Warner	02:18
Re: SQL question	Carolyn Lu Wong	03:41

Browse Archives

Prev | Next