pgsql-sql - November 2008

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
Jump to day: 1 2 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 24 25 27 28 30

Nov. 2, 2008

Thread Author Time
Seq scan on join, not on subselect? analyze this Bryce Nesbitt 17:51
Seq scan on join, not on subselect? analyze this Bryce Nesbitt 18:04
Re: Seq scan on join, not on subselect? analyze this Tom Lane 18:38
Re: Seq scan on join, not on subselect? analyze this 📎 Bryce Nesbitt 20:14

Nov. 3, 2008

Thread Author Time
reliable lock inside stored procedure Sebastian Böhm 09:29
Re: reliable lock inside stored procedure Richard Huxton 11:06
Re: reliable lock inside stored procedure (SOLVED) Sebastian Böhm 19:42
Re: [SQL] reliable lock inside stored procedure (SOLVED) Tom Lane 21:20
Re: Date Index Ryan Hansen 22:57
Re: Date Index Tom Lane 23:59

Nov. 4, 2008

Thread Author Time
Re: [SQL] reliable lock inside stored procedure (SOLVED) Robert Haas 00:26
Re: [SQL] reliable lock inside stored procedure (SOLVED) Tom Lane 00:57
Display message to user Bart van Houdt 12:31
Re: Display message to user Fernando Hevia 13:24
RE: [SQL] Display message to user Bart van Houdt 14:08
need help in building a query Devil™ Dhuvader 15:38

Nov. 5, 2008

Thread Author Time
Re: Display message to user Peter Eisentraut 12:21
[No subject] Hemant Patel 13:42
Re: ries van Twisk 14:50
Re: Hemant Patel 16:21
Re: Scott Marlowe 17:14

Nov. 6, 2008

Thread Author Time
Re: need help in building a query Devil™ Dhuvader 16:15
Re: need help in building a query Harold A. Giménez Ch. 17:10
Finding all tables that have foreign keys referencing a table Andreas Joseph Krogh 21:35

Nov. 7, 2008

Thread Author Time
Creating input/output_functions Markus Schatten 12:07
Res: Finding all tables that have foreign keys referencing a table paulo matadr 14:15
sum timestamp result in hours paulo matadr 14:20
Res: sum timestamp result in hours paulo matadr 16:36
Re: sum timestamp result in hours Scott Marlowe 16:49
Re: need help in building a query Devil™ Dhuvader 17:20
Re: Res: Finding all tables that have foreign keys referencing a table Andreas Joseph Krogh 19:46
Re: Res: Finding all tables that have foreign keys referencing a table Tom Lane 20:09
Re: Res: Finding all tables that have foreign keys referencing a table Andreas Joseph Krogh 20:34
Re: Res: Finding all tables that have foreign keys referencing a table Tom Lane 20:45
Resp.: need help in building a query Osvaldo Kussama 20:51
Re: need help in building a query Frank Bax 21:00

Nov. 8, 2008

Thread Author Time
Re: need help in building a query Devil™ Dhuvader 16:57
Re: need help in building a query Devil™ Dhuvader 17:12

Nov. 10, 2008

Thread Author Time
Query optimizing Sebastian Ritter 10:43
Re: Query optimizing Richard Huxton 11:05
Re: Seq scan on join, not on subselect? analyze this Helio Campos Mello de Andrade 11:28
[PERFORM] Can we activate WAL runtime? prakash 11:38
Re: Query optimizing Helio Campos Mello de Andrade 11:48
Re: Query optimizing Sebastian Ritter 11:58
Re: Query optimizing 📎 Richard Huxton 12:03
Re: Query optimizing Sebastian Ritter 12:21
Re: Query optimizing Richard Huxton 12:32
Re: Query optimizing Sebastian Ritter 13:39
Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Mario Splivalo 14:01
Converting between UUID and VARCHAR Mario Splivalo 14:34
Re: Converting between UUID and VARCHAR A. Kretschmer 14:44
Subsorting GROUP BY data Johnson, Michael L. 14:56
Re: Subsorting GROUP BY data tv 15:18
Re: Subsorting GROUP BY data Oliveiros Cristina 15:23
Re: Subsorting GROUP BY data Fernando Hevia 15:30
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Tom Lane 15:48
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Mario Splivalo 16:14
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Tom Lane 16:26
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Richard Huxton 16:42
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Tom Lane 16:57
inserts within function, within insert Kevin Duffy 17:11
Re: Subsorting GROUP BY data Johnson, Michael L. 18:06
Measuring degredation of CLUSTER INDEX operation Bryce Nesbitt 19:54
Re: Measuring degredation of CLUSTER INDEX operation Scott Marlowe 23:37

Nov. 11, 2008

Thread Author Time
Re: [PERFORM] Can we activate WAL runtime? Craig Ringer 03:28
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Mario Splivalo 11:17
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Mario Splivalo 11:24
Re: Using UTF strings in pg8.3 - storing hexadecimal values in bytea columns Mario Splivalo 11:27
Postgres version of all_ind_cols Bart van Houdt 13:57
Re: Postgres version of all_ind_cols Mario Splivalo 14:02
Re: Postgres version of all_ind_cols Bart van Houdt 14:04
Re: Postgres version of all_ind_cols A. Kretschmer 14:04

Nov. 12, 2008

Thread Author Time
Invitation to connect on LinkedIn Helio Campos Mello de Andrade 22:14

Nov. 13, 2008

Thread Author Time
array variables Marcin Krawczyk 09:08
Re: array variables Marcin Krawczyk 09:13
Re: array variables Pavel Stehule 09:30
Re: array variables Achilleas Mantzios 09:39
Re: array variables Marcin Krawczyk 09:44
Re: array variables Tom Lane 13:14
Re: array variables Pavel Stehule 13:16
Re: array variables Tom Lane 13:42
Re: array variables Pavel Stehule 13:47
Re: array variables Tom Lane 13:52
Re: array variables Pavel Stehule 13:59

Nov. 14, 2008

Thread Author Time
uuid on windows Sabin Coanda 07:38
Re: uuid on windows Richard Huxton 08:46
Re: uuid on windows Sabin Coanda 10:26
trapping a NULL querystring error Gerardo Herzig 10:29
Re: uuid on windows Richard Huxton 10:39
Re: trapping a NULL querystring error A. Kretschmer 10:55
Re: uuid on windows Sabin Coanda 13:17
Enc: Help to replace caracter paulo matadr 16:17
raise doesn't add end of line Sabin Coanda 16:27
Re: Enc: Help to replace caracter Raymond O'Donnell 16:39
Re: Enc: Help to replace caracter Marco Antonio 16:55
Query to match location transitions sub3 19:12

Nov. 15, 2008

Thread Author Time
Re: Enc: Help to replace caracter Raj Mathur 04:06
Re: Query to match location transitions Tomasz Myrta 12:59

Nov. 17, 2008

Thread Author Time
Re: raise doesn't add end of line Sabin Coanda 08:40
Re: raise doesn't add end of line Pavel Stehule 14:31
Re: raise doesn't add end of line Sabin Coanda 15:01

Nov. 18, 2008

Thread Author Time
custom serial number mahmoud ewiwi 09:09
Re: custom serial number A. Kretschmer 09:26
Re: custom serial number Pavel Stehule 09:37
Re: custom serial number A. Kretschmer 09:42
Re: custom serial number Pavel Stehule 09:45
Re: custom serial number Gerardo Herzig 18:17
Left Join Question Ryan Wells 22:48
Re: Left Join Question ries van Twisk 23:18
Re: Left Join Question Mark Roberts 23:22

Nov. 19, 2008

Thread Author Time
Re: Left Join Question Richard Huxton 07:45
Re: custom serial number A. Kretschmer 07:45
Re: custom serial number mahmoud ewiwi 08:52
Query to retrieve all indexed columns Bart van Houdt 12:11
Re: custom serial number A. Kretschmer 13:37
VACUUM cannot be executed from multi-command string Sabin Coanda 15:26
Re: Left Join Question Ryan Wells 15:30
Re: VACUUM cannot be executed from multi-command string Richard Huxton 18:05
Re: Query to retrieve all indexed columns Tom Lane 18:24

Nov. 20, 2008

Thread Author Time
date range query help novice 02:10
Re: date range query help Adam Rich 02:42
Re: date range query help novice 03:03
Re: date range query help brian 03:28
Re: date range query help novice 03:43
Re: [SQL] date range query help Rodrigo E. De León Plicet 04:17
Re: [SQL] [GENERAL] date range query help Frank Bax 04:19
Re: [SQL] date range query help novice 04:32
Re: [SQL] date range query help brian 04:33
Re: [SQL] date range query help novice 04:41
Re: [SQL] date range query help Adam Rich 04:42
Re: [SQL] date range query help Joshua D. Drake 05:04
Re: date range query help Raymond C. Rodgers 05:42
UPDATE and DELEte with a lot of register is to slow... John Dizaro 10:20
Re: UPDATE and DELEte with a lot of register is to slow... Craig Ringer 11:29
Re: date range query help Sam Mason 11:49
Re: [SQL] date range query help Frank Bax 13:22
Re: date range query help Tom Lane 16:20
Res: UPDATE and DELEte with a lot of register is to slow... paulo matadr 19:04

Nov. 21, 2008

Thread Author Time
Re: UPDATE and DELEte with a lot of register is to slow... John Dizaro 12:34
BULK COLLECT Paul Dam 13:20
function - string ends with Kevin Duffy 16:30
Re: BULK COLLECT Scott Marlowe 16:46
Re: function - string ends with Kevin Duffy 16:47
Re: function - string ends with Oliveiros Cristina 16:53
simple text parsing function Kevin Duffy 20:35

Nov. 22, 2008

Thread Author Time
Interval Format Zagato 01:34
JOIN results of refcursor functions Milan Oparnica 01:37
Re: Interval Format Tom Lane 02:15
Re: JOIN results of refcursor functions Tom Lane 02:16
Re: Interval Format Zagato 02:31
Re: simple text parsing function John DeSoi 15:48

Nov. 24, 2008

Thread Author Time
Permission denied for create table Pascal Tufenkji 06:50
Re: Permission denied for create table Marcin Stępnicki 07:17
Re: BULK COLLECT Paul Dam 08:32
Re: Permission denied for create table Richard Huxton 09:24
Re: Permission denied for create table Tom Lane 13:17
Sequence and nextval problem Tk421 19:12
Re: Sequence and nextval problem Scott Marlowe 19:20
Re: Sequence and nextval problem ries van Twisk 21:21

Nov. 25, 2008

Thread Author Time
Re: Sequence and nextval problem 📎 Craig Ringer 04:35
Re: Sequence and nextval problem Craig Ringer 04:44
Full text search ordering question John Lister 15:28
Re: Sequence and nextval problem Steve Midgley 16:07
Re: Full text search ordering question Oleg Bartunov 16:43
Re: Full text search ordering question John Lister 16:54
EXECUTE query INTO problem Tk421 20:58
Re: EXECUTE query INTO problem Andreas Kretschmer 21:16
Re: EXECUTE query INTO problem Pawel Socha 22:07

Nov. 27, 2008

Thread Author Time
Re: JOIN results of refcursor functions Milan Oparnica 20:27
Re: JOIN results of refcursor functions Alvaro Herrera 20:45

Nov. 28, 2008

Thread Author Time
Re: UPDATE and DELEte with a lot of register is to slow... John Dizaro 10:37
wired behaviour Lutz Steinborn 13:51
Re: wired behaviour Paul Dam 14:10
Re: wired behaviour ries van Twisk 14:11
Re: wired behaviour Lutz Steinborn 14:22
Re: wired behaviour Ragnar Hafstað 14:54
Re: wired behaviour Shane Ambler 15:09
Re: wired behaviour Lennin Caro 15:22
Re: Converting between UUID and VARCHAR Helio Campos Mello de Andrade 22:27

Nov. 30, 2008

Thread Author Time
Re: JOIN results of refcursor functions Milan Oparnica 23:13

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 10 11 12 13 14 15 17 18 19 20 21 22 24 25 27 28 30