pgsql-sql before 2007-04-04 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

March 16, 2007

Thread	Author	Time
Re: Joins on many-to-many relations.	Wiebe Cazemier	11:56
Re: INSERT INTO	Guillaume Lelarge	12:07
Re: INSERT INTO	Richard Broersma Jr	13:02
Re: INSERT INTO	Richard Broersma Jr	13:08
Re: INSERT INTO	Shavonne Marietta Wijesinghe	13:37
Re: INSERT INTO	Alvaro Herrera	14:45
Grabbing Newest Records From Duplicates	Travis Whitton	15:28
Re: Grabbing Newest Records From Duplicates	Tom Lane	15:35
log file permissions?	Gerardo Herzig	15:50
Re: Grabbing Newest Records From Duplicates	Travis Whitton	15:55
Re: Grabbing Newest Records From Duplicates	Tom Lane	16:17
Re: log file permissions?	Steve Crawford	16:18
Re: log file permissions?	Tom Lane	16:21
Re: [SQL] PostgreSQL to Oracle	Reece Hart	17:18
Re: [SQL] PostgreSQL to Oracle	David Fetter	17:44
Re: [SQL] PostgreSQL to Oracle	Jonah H. Harris	18:20

March 17, 2007

Thread	Author	Time
Re: INSERT INTO	Josh Williams	01:19
Rollback	Hetal Patel	10:49
Re: Rollback	Phillip Smith	11:23
Re: Rollback	Hetal Patel	11:59

March 18, 2007

Thread	Author	Time
triple self-join crawling	T E Schmitz	19:51

March 19, 2007

Thread	Author	Time
better approach: case or join	chester c young	01:21
Help with sub query	roopa perumalraja	02:56
Re: Help with sub query	Phillip Smith	04:03
create view with check option	Karthikeyan Sundaram	05:38
Re: [SQL] create view with check option	Tom Lane	05:58
Re: [SQL] create view with check option	hubert depesz lubaczewski	07:29
Re: triple self-join crawling	Andrew Sullivan	08:12
Re: triple self-join crawling	T E Schmitz	08:22
Encode	Ezequias R. da Rocha	12:21
Re: Encode	Shoaib Mir	12:39
Re: [SQL] create view with check option	Tom Lane	14:16
Re: triple self-join crawling	T E Schmitz	16:09
Re: triple self-join crawling	T E Schmitz	16:10
Multiple partition tables and faster queries	Maya Nigrosh	16:40
Re: create view with check option	Gaetano Mendola	17:34
Re: Encode	Jure Kodzoman	18:35
Re: create view with check option	Karthikeyan Sundaram	20:41
Re: triple self-join crawling	Martin Marques	22:00

March 20, 2007

Thread	Author	Time
Issue with copying data from a text file.	Paul Lambert	02:25
Re: Issue with copying data from a text file.	Phillip Smith	02:37
Re: Issue with copying data from a text file.	Paul Lambert	02:44
Re: Issue with copying data from a text file.	Andrej Ricnik-Bay	02:53
Re: Issue with copying data from a text file.	Paul Lambert	02:59
Re: Issue with copying data from a text file.	Phillip Smith	03:05
Re: Issue with copying data from a text file.	Michael Fuhr	03:17
Re: Issue with copying data from a text file.	Paul Lambert	03:21
Re: How to declare cursor if tablename is a variable?	Michael Fuhr	03:41
ERROR: duplicate key violates unique constraint	remco lengers	09:11
unsubscribe	Stefan Ionita	09:17
Re: ERROR: duplicate key violates unique constraint	Bart Degryse	09:20
unsubscribe	Stefan Ionita	09:27
Re: ERROR: duplicate key violates unique constraint	Richard Huxton	09:27
Select and Count	Shavonne Marietta Wijesinghe	10:14
Re: Select and Count	Martin Marques	11:55
Re: unsubscribe	Alvaro Herrera	12:46
Re: Select and Count	Bart Degryse	13:25
ERROR: invalid byte sequence for encoding "UTF8": 0x92	Karthikeyan Sundaram	19:34
Re: ERROR: invalid byte sequence for encoding "UTF8": 0x92	Ivo Rossacher	20:03
Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92	Claus Guttesen	20:06
Substitute	Judith	23:54

March 21, 2007

Thread	Author	Time
Re: Substitute	Milen A. Radev	03:02
Re: Substitute	Michael Fuhr	03:02
Re: [SQL] ERROR: invalid byte sequence for encoding "UTF8": 0x92	Michael Fuhr	03:32
unsubscribe	Stefan	06:11
unsubscribe	Piotr Dabrowski	06:36
Regular Expressions	Ezequias R. da Rocha	14:04
Re: Regular Expressions	Bricklen Anderson	14:28
Re: Regular Expressions	Guy Fraser	14:36
Anyone still using the sql_inheritance parameter?	Tom Lane	14:49
Re: Anyone still using the sql_inheritance parameter?	Joshua D. Drake	15:00
Re: Anyone still using the sql_inheritance parameter?	Ron Johnson	15:43
Re: Anyone still using the sql_inheritance parameter?	codeWarrior	16:00
job opportunity	Max.Kaufmann	16:12
Re: Anyone still using the sql_inheritance parameter?	Tom Lane	16:13
Re: Anyone still using the sql_inheritance parameter?	Tom Lane	16:14
Re: Anyone still using the sql_inheritance parameter?	Ron Johnson	16:50
Re: Issue with copying data from a text file.	Steve Midgley	17:01
growth of the database	Karthikeyan Sundaram	17:25
Re: Regular Expressions	Ezequias R. da Rocha	17:37
Re: growth of the database	Guido Neitzer	17:37
Re: Regular Expressions	Guy Fraser	20:32
Monitor what command is executing at the backend	Karthikeyan Sundaram	21:49
Re: [SQL] Monitor what command is executing at the backend	George Pavlov	21:56
Re: [SQL] Monitor what command is executing at the backend	Karthikeyan Sundaram	22:16
Re: [SQL] Monitor what command is executing at the backend	George Pavlov	22:25

March 22, 2007

Thread	Author	Time
Re: Regular Expressions	Andrew Sullivan	01:35
Re: growth of the database	Hubertus Freiherr von Fuerstenberg	10:40
unsubscribe	Susan Evans	11:55
Subqueryes	Ezequias R. da Rocha	13:48
Re: Subqueryes	Alvaro Herrera	13:56
Re: Subqueryes	Richard Broersma Jr	14:07
Re: Subqueryes	Ezequias R. da Rocha	14:42
Dummy question	Ezequias R. da Rocha	19:43
Re: Dummy question	Joe	20:17
Re: Dummy question	Ezequias R. da Rocha	20:26

March 23, 2007

Thread	Author	Time
Re: How to declare cursor if tablename is a variable?	Michael Fuhr	11:47

March 26, 2007

Thread	Author	Time
Selecting different views from a Boolean expression	Wilkinson, Jim	13:36
Shared Buffers	ezequias	21:01

March 27, 2007

Thread	Author	Time
Re: timestamp subtraction (was Re: [SQL] formatting intervals with to_char)	Bruce Momjian	01:50
array_to_string	Sabin Coanda	06:47
select vs. select count	Claus Guttesen	12:37
Re: select vs. select count	Claus Guttesen	12:39
Foreign Unique Constraint	Jon Horsman	13:21
Re: Foreign Unique Constraint	A. Kretschmer	13:36
Re: select vs. select count	Peter Eisentraut	14:20
Re: Foreign Unique Constraint	Jon Horsman	14:27
Re: array_to_string	Tom Lane	14:49
Re: array_to_string	Richard Huxton	14:59
Re: array_to_string	Tom Lane	15:35
Re: array_to_string	Richard Huxton	15:45
Re: Foreign Unique Constraint	Peter Eisentraut	15:58
Re: select vs. select count	Tom Lane	16:10
Re: Foreign Unique Constraint	chester c young	17:35
Re: Regular Expressions	ezequias	20:01
Re: Regular Expressions	Richard Broersma Jr	22:16
Re: Foreign Unique Constraint	Phillip Smith	22:17

March 28, 2007

Thread	Author	Time
Re: Foreign Unique Constraint	Jon Horsman	03:51
Re: Foreign Unique Constraint	Peter Eisentraut	09:08
Re: Regular Expressions [progress]	ezequias	12:25
Re: Foreign Unique Constraint	Jon Horsman	13:28
union with count?	Gerardo Herzig	14:04
Re: Regular Expressions [progress]	Richard Broersma Jr	14:10
Re: union with count?	A. Kretschmer	14:24
Re: union with count?	Richard Broersma Jr	14:27
Re: union with count?	Gerardo Herzig	15:23
Re: Rules with sequence columns	Tom Lane	16:17
Re: union with count?	Andreas Kretschmer	16:19
Rules with sequence columns	Ray Madigan	16:25
How too select different views using a IF/THEN/ELSE procedure ?	Wilkinson, Jim	19:04
Track query status	Sumeet	20:59
Re: Track query status	Andrew Sullivan	21:49
Re: Foreign Unique Constraint	Phillip Smith	22:21

March 29, 2007

Thread	Author	Time
SELECT INSTEAD	Phillip Smith	05:35
Re: SELECT INSTEAD	Michael Fuhr	06:48
Re: SELECT INSTEAD	Richard Huxton	06:49
Re: SELECT INSTEAD	Phillip Smith	06:58
Temp tbl Vs. View	Radhika Sambamurti	15:26
Re: Temp tbl Vs. View	Richard Broersma Jr	15:46
Re: Temp tbl Vs. View	Rodrigo De León	15:56
Re: Empty Table	Rajesh Kumar Mallah	18:16
Empty Table	ezequias	18:25
Re: Empty Table	ezequias	18:50
Re: Empty Table	Rajesh Kumar Mallah	19:34
Re: Empty Table	Rajesh Kumar Mallah	19:41
Re: Track query status	Rajesh Kumar Mallah	19:48
Re: Foreign Unique Constraint	Jon Horsman	21:23
Re: olympics ranking query	Kyle Bateman	21:33

March 30, 2007

Thread	Author	Time
Re: select vs. select count	Claus Guttesen	11:19
using sql on v7.4 server to feed stored procedure	Brian Jarrett	19:19
Re: using sql on v7.4 server to feed stored procedure	Tom Lane	20:14
function return array	Karthikeyan Sundaram	21:16

March 31, 2007

Thread	Author	Time
plpgsql function return array	Karthikeyan Sundaram	07:43
Re: plpgsql function return array	Michael Fuhr	12:55

April 1, 2007

Thread	Author	Time
Sequence vs Serial	Daniel CAUNE	04:01
Re: Sequence vs Serial	Scott Marlowe	07:58
Re: Sequence vs Serial	Tom Lane	18:51

April 2, 2007

Thread	Author	Time
Calling void functions	Peter Eisentraut	08:02
Re: Calling void functions	Daniel Caune	12:52
Re: Calling void functions	A. Kretschmer	13:31
Update problem.	Shavonne Marietta Wijesinghe	14:06
Update problem.	Shavonne Marietta Wijesinghe	14:52
Re: Update problem.	Andrew Sullivan	15:17
Re: Calling void functions	Tom Lane	16:44
SQL4. I ask you to help in development (or critic).	sql4-en.narod.ru	16:56
Maxusers MaxConnections	ezequias	18:13
Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)	Bruce Momjian	22:46
Re: Calling void functions	Daniel CAUNE	23:08

April 3, 2007

Thread	Author	Time
Very slow DELETE on 4000 rows of 55000 row table	Bryce Nesbitt	06:10
Re: Very slow DELETE on 4000 rows of 55000 row table	Tom Lane	07:04
Re: Update problem.	Shavonne Marietta Wijesinghe	07:13
Serial	Shavonne Marietta Wijesinghe	09:20
Re: Serial	A. Kretschmer	09:32
Re: Serial	Shavonne Marietta Wijesinghe	09:55
Re: Serial	Milen A. Radev	10:10
Re: Serial	A. Kretschmer	10:14
Re: Serial	Shavonne Marietta Wijesinghe	10:29
Re: Serial	A. Kretschmer	10:40
best way: diary functions.	Gary Stainburn	12:25
LOCK command inside a TRANSACTION	Carlos Santos	12:48
Using a variable as a view name in a select	Wilkinson, Jim	13:04
Re: Using a variable as a view name in a select	A. Kretschmer	13:16
Re: Using a variable as a view name in a select	John Summerfield	13:21
Re: LOCK command inside a TRANSACTION	Peter Eisentraut	13:57
Re: Using a variable as a view name in a select 📎	Hilary Forbes	14:14
A long-running transaction	John Summerfield	14:16
Re: Serial	Scott Marlowe	14:17
Re: Serial	Richard Broersma Jr	15:24
Re: Update problem.	Andrew Sullivan	16:16
Re: Using a variable as a view name in a select 📎	Hilary Forbes	16:45
Re: Using a variable as a view name in a select	Wilkinson, Jim	17:18
plpgsql function question	Karthikeyan Sundaram	17:42
Re: plpgsql function question	Andreas Kretschmer	18:18
Re: plpgsql function question	Karthikeyan Sundaram	18:33
Re: [pgsql-sql] Daily digest v1.2492 (19 messages)	Steve Midgley	18:35
Re: plpgsql function question	A. Kretschmer	19:24
Re: A long-running transaction	Andrew Sullivan	20:14
Re: plpgsql function question	John DeSoi	20:27
exception handling in postgres plpgsql	Karthikeyan Sundaram	22:35
Re: [SQL] exception handling in postgres plpgsql	Joe	23:30

Browse Archives

Prev | Next