pgsql-sql - September 2006

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 9 11 12 13 14 15 17 19 20 21 22 23 26 27 28 29 30

Sept. 1, 2006

Thread Author Time
help with pagila Walter Cruz 13:31
Re: help with pagila Andrew Sullivan 15:21
Re: help with pagila Walter Cruz 17:26
Re: help with pagila Andrew Sullivan 17:40
Re: help with pagila Tomas Vondra 18:06
Re: help with pagila Scott Marlowe 19:58
Re: help with pagila Tom Lane 20:21
Re: help with pagila Tomas Vondra 20:25
Re: help with pagila Walter Cruz 20:46
Re: help with pagila Stephan Szabo 21:12

Sept. 2, 2006

Thread Author Time
Mac Address Ezequias Rodrigues da Rocha 20:42
Re: Mac Address Milen A. Radev 22:34
Re: Mac Address Bruno Wolff III 23:24

Sept. 3, 2006

Thread Author Time
Re: Mac Address Andreas Kretschmer 07:07
Re: How to get the row that start a trigger Aaron Bono 23:17

Sept. 4, 2006

Thread Author Time
Re: help with pagila Markus Schaber 07:55

Sept. 5, 2006

Thread Author Time
pg_dump M. Santosa 07:22
Postgres regexp matching failure? Mario Splivalo 10:18
Re: pg_dump Andrew Sullivan 10:54
Re: Postgres regexp matching failure? Aaron Bono 13:42
Re: Postgres regexp matching failure? Tom Lane 14:11
Re: Postgres regexp matching failure? Mario Splivalo 14:16
Re: Postgres regexp matching failure? Mario Splivalo 14:17
Re: Postgres regexp matching failure? Alvaro Herrera 14:21
Re: pg_dump Tom Lane 14:28
Re: Postgres regexp matching failure? Mario Splivalo 15:03
Re: Postgres regexp matching failure? Alvaro Herrera 15:17
Re: Postgres regexp matching failure? Tom Lane 15:22
Re: Subquery alternatives? codeWarrior 16:07
Re: Postgres regexp matching failure? Aaron Bono 16:10

Sept. 6, 2006

Thread Author Time
Way to reverse ordering of an IP ... ? Marc G. Fournier 03:51
Query regarding to MS reporting services (Grand total problem) Dinesh Tiwari 05:30
Re: Way to reverse ordering of an IP ... ? Philippe Lang 06:35
Re: Query regarding to MS reporting services (Grand total problem) Andrew Sullivan 11:31
Substitute a Character Judith 16:53
Re: Substitute a Character Andreas Kretschmer 17:09
Re: Substitute a Character Chris Mair 17:14
Re: Substitute a Character Daryl Richter 20:20
Evaluation of if conditions Daniel CAUNE 22:32
Re: Evaluation of if conditions Gregory S. Williamson 23:02
Re: Evaluation of if conditions Oisin Glynn 23:04
Re: Evaluation of if conditions Joe 23:40

Sept. 7, 2006

Thread Author Time
Re: Evaluation of if conditions Tom Lane 04:10
Problem with FOR UPDATE Kaloyan Iliev 09:00
Re: Substitute a Character Kaloyan Iliev 09:03
Re: Postgres regexp matching failure? Mario Splivalo 10:32
Is it possible to left join based on previous joins result Emi Lu 13:13
Re: Query regarding to MS reporting services (Grand total problem) Aaron Bono 14:01
Re: Is it possible to left join based on previous joins result Emi Lu 14:02
Re: Problem with FOR UPDATE Tom Lane 14:15
Re: Problem with FOR UPDATE Stephan Szabo 14:20
Re: Is it possible to left join based on previous joins result Stephan Szabo 14:26
Re: Is it possible to left join based on previous joins Ragnar 14:30
Thanks Kaloyan Iliev 15:29

Sept. 9, 2006

Thread Author Time
Re: Is it possible to left join based on previous joins result Aaron Bono 17:26

Sept. 11, 2006

Thread Author Time
on connect/on disconnect Robert Edwards 00:57
where clause subqueries vs multiple rows results James Cloos 03:27
Re: on connect/on disconnect Aaron Bono 04:28
Re: on connect/on disconnect Robert Edwards 04:52
Re: where clause subqueries vs multiple rows results Aaron Bono 04:54
Re: where clause subqueries vs multiple rows results Aaron Bono 04:55
Re: where clause subqueries vs multiple rows results Richard Broersma Jr 05:01
Re: on connect/on disconnect Aaron Bono 05:10
hi i am gettin error when i am deleting a function from my pgadmin Penchalaiah P. 07:46
Re: on connect/on disconnect Markus Schaber 10:31
Re: on connect/on disconnect Markus Schaber 10:36
Re: where clause subqueries vs multiple rows results James Cloos 12:04
Re: on connect/on disconnect Jorge Godoy 12:09
Re: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono 14:46
Fwd: hi i am gettin error when i am deleting a function from my pgadmin Aaron Bono 14:47
case insensitive regex clause with some latin1 characters fails Ragnar Österlund 19:09
Re: case insensitive regex clause with some latin1 characters fails Tom Lane 19:41
Re: case insensitive regex clause with some latin1 characters Emi Lu 20:14
text+number, find largest entry gabor 23:34

Sept. 12, 2006

Thread Author Time
Re: text+number, find largest entry Tom Lane 00:15
Re: on connect/on disconnect Robert Edwards 00:43
Re: hi i am gettin error when i am deleting a function from Robert Edwards 00:46
Two optimization questions Mezei Zoltán 10:23
Sorting items in aggregate function Steven Murdoch 15:46
Joint a table back on itself? paallen 15:55
Re: Joint a table back on itself? Daryl Richter 18:09
Re: Sorting items in aggregate function Michael Fuhr 18:17
Re: on connect/on disconnect Aaron Bono 18:21
Re: Sorting items in aggregate function Volkan YAZICI 18:24
Re: Two optimization questions Aaron Bono 18:46
Re: Two optimization questions Mezei Zoltán 19:06
How to get all users under a group Emi Lu 19:24
Re: Sorting items in aggregate function Tom Lane 20:37
Re: Sorting items in aggregate function Osvaldo Rosario Kussama 20:54

Sept. 13, 2006

Thread Author Time
Re: How to get all users under a group Emi Lu 13:51
Aggregates with internal state type? Markus Schaber 20:34
Re: Aggregates with internal state type? Tom Lane 21:13
Re: Aggregates with internal state type? Markus Schaber 21:19
Re: Aggregates with internal state type? Tom Lane 21:25
Re: Aggregates with internal state type? Markus Schaber 21:44

Sept. 14, 2006

Thread Author Time
How to delete multiple records Javanesevn 06:07
Re: How to delete multiple records Reinoud van Leeuwen 07:09
Re: How to delete multiple records Markus Schaber 07:13
nested select within a DISTINCT block zqzuk 12:02
nested select within a DISCTINCT block zqzuk 17:13
Re: nested select within a DISCTINCT block Daryl Richter 21:58
Re: nested select within a DISCTINCT block zqzuk 22:11

Sept. 15, 2006

Thread Author Time
Re: nested select within a DISCTINCT block Niklas Johansson 01:24
lower() not working correctly...? Andreas Joseph Krogh 07:52
lower() not working correctly...? Andreas Joseph Krogh 08:06
Re: lower() not working correctly...? Mario Weilguni 08:21
Re: lower() not working correctly...? Guillaume Lelarge 08:44
Re: lower() not working correctly...? A. Kretschmer 08:44
Re: lower() not working correctly...? Amit_Wadhwa 08:50
Re: Sorting items in aggregate function (thanks) Steven Murdoch 09:15
Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 gould 09:16
Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 Milen A. Radev 09:29
Re: Omission of 'FROM' ? diff between pgsql 7.4.1 and pgsql 8.1.4 A. Kretschmer 09:36
Re: [HACKERS] lower() not working correctly...? Ragnar 10:07
Re: Aggregates with internal state type? Markus Schaber 14:41
Dividing results from two tables with different time frames Becky Hoff 15:34

Sept. 17, 2006

Thread Author Time
Re: Dividing results from two tables with different time Ragnar 10:05
Transactional behaviour with trigger Joost Kraaijeveld 12:32
Re: Transactional behaviour with trigger Michael Fuhr 14:36
Re: Transactional behaviour with trigger Joost Kraaijeveld 14:56
Re: Dividing results from two tables with different time frames Aaron Bono 16:16

Sept. 19, 2006

Thread Author Time
inner join is much faster! is that right? James Im 09:21
Borland Database Engine assumes Varchar(255) as Memo Ezequias Rodrigues da Rocha 12:11
Re: inner join is much faster! is that right? Chris Mair 12:29
Re: inner join is much faster! is that right? James Im 13:44
Nested loops are killing throughput CG 14:46
Re: Nested loops are killing throughput Tom Lane 15:03
Count and list only where count is bigger than 1 Ezequias Rodrigues da Rocha 15:04
Re: Count and list only where count is bigger than 1 📎 Mezei Zoltán 15:09
Re: Count and list only where count is bigger than 1 bnichols 15:09
Re: Count and list only where count is bigger than 1 A. Kretschmer 15:15
Re: Nested loops are killing throughput CG 18:05
Re: Nested loops are killing throughput Tom Lane 18:17
Re: Nested loops are killing throughput CG 18:59
Make Trigger run after completion of ENTIRE transaction Henry Ortega 19:00
Re: Nested loops are killing throughput Tom Lane 19:15
Re: Nested loops are killing throughput CG 20:36

Sept. 20, 2006

Thread Author Time
Need a SQL to create sets of hobbies CN 05:18
Re: Make Trigger run after completion of ENTIRE transaction Markus Schaber 09:24
Re: Need a SQL to create sets of hobbies Harald Fuchs 11:33
Re: Dividing results from two tables with different time frames Aaron Bono 17:24
Re: Nested loops are killing throughput CG 18:10
Re: Need a SQL to create sets of hobbies Aaron Bono 18:38
ERROR: could not write block 196261 of temporary file: No space left TJ O'Donnell 22:00
Re: ERROR: could not write block 196261 of temporary file: No space left Tom Lane 22:31

Sept. 21, 2006

Thread Author Time
UnSubscribe vijay balan 04:47
unique rows TJ O'Donnell 05:18
UnSubscribe dmz 06:13
Unsubscribe David Klugmann 06:36
Re: unique rows Kaloyan Iliev 07:33
Re: unique rows Markus Schaber 07:46
Re: Help with optional parameters Curtis Scheer 22:18
Re: Help with optional parameters MaXX 22:48

Sept. 22, 2006

Thread Author Time
Group by minute Ezequias Rodrigues da Rocha 13:52
Re: Group by minute Niklas Johansson 14:10
Re: Group by minute 📎 Mezei Zoltán 14:14
Re: Group by minute Scott Marlowe 14:56
Re: nested select within a DISTINCT block Bruno Wolff III 17:28
How to autoincrement a primary key... Doug Hyde 19:13
Re: How to autoincrement a primary key... Richard Broersma Jr 19:25
Re: How to autoincrement a primary key... Andrew Chilton 22:00
Re: How to autoincrement a primary key... Thomas Kellerer 22:12

Sept. 23, 2006

Thread Author Time
Re: How to autoincrement a primary key... Aarni Ruuhimäki 06:27
Re: unique rows TJ O'Donnell 14:43

Sept. 26, 2006

Thread Author Time
Populating using Select Ezequias Rodrigues da Rocha 12:35
Re: Populating using Select Andrew Sullivan 12:52
Finding context for error log Kyle Bateman 14:19
Re: Finding context for error log Tom Lane 14:56
Re: Populating using Select Ezequias Rodrigues da Rocha 18:38
Re: Finding context for error log Vivek Khera 19:37

Sept. 27, 2006

Thread Author Time
Query regarding Writing a report using the file sysstem data processing extensions Dinesh Tiwari 13:14
Re: Query regarding Writing a report using the file sysstem Markus Schaber 14:33
Re: unique rows Bruno Wolff III 20:27

Sept. 28, 2006

Thread Author Time
files or DataBase tomcask o_o 22:37

Sept. 29, 2006

Thread Author Time
Re: files or DataBase Jim C. Nasby 01:06
Re: files or DataBase Gregory S. Williamson 02:12
regexp_replace usage chester c young 21:31
tree-structured query chester c young 22:00

Sept. 30, 2006

Thread Author Time
How to FindNearest Alexander Ilyin 08:43
Re: tree-structured query Ragnar 22:29

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 9 11 12 13 14 15 17 19 20 21 22 23 26 27 28 29 30