pgsql-sql - July 2007

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 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31

July 1, 2007

Thread Author Time
Query Problem from FoxPro??? dBHS Jakarta 03:47
Re: Query Problem from FoxPro??? Jaime Casanova 04:44
Re: yet another simple SQL question John Summerfield 23:28

July 2, 2007

Thread Author Time
Re: yet another simple SQL question Andrej Ricnik-Bay 00:16
Replace usage of a table in query with its array values Loredana Curugiu 08:23
Re: Replace usage of a table in query with its array values Guy Rouillier 15:38
Re: Replace usage of a table in query with its array values Loredana Curugiu 16:49
Using escape strings in an insert statement. Paul Lambert 22:45
Re: Using escape strings in an insert statement. Michael Glaesemann 23:11
Re: Using escape strings in an insert statement. Paul Lambert 23:26

July 3, 2007

Thread Author Time
Re: Using escape strings in an insert statement. Michael Glaesemann 00:13
dblink inside plpgsql function Loredana Curugiu 09:02
Re: dblink inside plpgsql function Pavel Stehule 09:13
Re: dblink inside plpgsql function Bart Degryse 09:45
Re: dblink inside plpgsql function Loredana Curugiu 12:25
Re: dblink inside plpgsql function Richard Huxton 12:32
Re: [SQL] dblink inside plpgsql function Loredana Curugiu 12:50
Re: dblink inside plpgsql function Richard Huxton 12:58
Re: [SQL] dblink inside plpgsql function Loredana Curugiu 13:08
Re: Using escape strings in an insert statement. Erik Jones 15:49
Informix Schema -> PostgreSQL ? Mark Fenbers 16:22
Re: Informix Schema -> PostgreSQL ? Adam Tauno Williams 17:35
Re: Informix Schema -> PostgreSQL ? Scott Marlowe 17:48
Re: Using escape strings in an insert statement. Michael Glaesemann 17:56
Iterate and write a previous row to a temp table? Bob Singleton 18:43
Re: Iterate and write a previous row to a temp table? chester c young 18:49
Re: Iterate and write a previous row to a temp table? Richard Huxton 18:57
Re: Informix Schema -> PostgreSQL ? Adam Tauno Williams 23:35

July 4, 2007

Thread Author Time
Re: Informix Schema -> PostgreSQL ? Jaime Casanova 04:18
Re: Informix Schema -> PostgreSQL ? Nis Jørgensen 04:34
Re: Query Problem from FoxPro??? dBHS Jakarta 06:48

July 5, 2007

Thread Author Time
Re: 'comp.databases.theory' Michael Holzman 08:36
Re: separating improperly grouped page views Jeff Frost 17:20
Working with dates Ranieri Mazili 19:00
Re: Working with dates Ranieri Mazili 20:49

July 6, 2007

Thread Author Time
select from table and add rows. Gary Stainburn 13:25
Quote problem Bart Degryse 14:14
Re: select from table and add rows. Andrew Sullivan 15:02
Re: Iterate and write a previous row to a temp table? 📎 Bob Singleton 16:25
Re: select from table and add rows. Gary Stainburn 16:35
Re: select from table and add rows. Andrew Sullivan 16:53
Re: select from table and add rows. Jon Sime 17:16

July 10, 2007

Thread Author Time
Index working, but not inside function Patrick Clery 06:38
CIdr query qestion Michele Petrazzo - Unipex srl 07:36
Re: CIdr query qestion Jesper K. Pedersen 09:00
Re: CIdr query qestion Michael Fuhr 09:16
Database system identifier from SQL Peter Eisentraut 14:24
Re: Database system identifier from SQL Tom Lane 15:23
Re: Index working, but not inside function Tom Lane 17:24
Re: Database system identifier from SQL Peter Eisentraut 18:06
Re: Database system identifier from SQL Tom Lane 18:15

July 11, 2007

Thread Author Time
linux Mohd Ghalib Akhtar 13:04
Re: linux A. Kretschmer 13:39
using EXECUTE on Selects Radhika Sambamurti 16:41
using EXECUTE on Selects Radhika Sambamurti 16:44
Re: using EXECUTE on Selects Rodrigo De León 16:49
Re: using EXECUTE on Selects Andrew Sullivan 16:52
Re: using EXECUTE on Selects A. Kretschmer 17:08
Re: using EXECUTE on Selects Radhika Sambamurti 17:35
Re: linux Andrej Ricnik-Bay 18:39

July 12, 2007

Thread Author Time
Using case or if to return multiple rows Ashish Karalkar 06:45
Re: Using case or if to return multiple rows Pavel Stehule 07:09
Re: Using case or if to return multiple rows Ragnar 09:52
Re: Using case or if to return multiple rows Pavel Stehule 11:25
Converting from MS Access field aliases Joel Richard 14:07
Re: Using case or if to return multiple rows Tom Lane 15:34
Re: Converting from MS Access field aliases Nicholas Barr 15:55
Re: Converting from MS Access field aliases chester c young 16:36
Re: Converting from MS Access field aliases Tom Lane 17:23
Re: Converting from MS Access field aliases Joel Richard 17:36
Re: Converting from MS Access field aliases Tom Lane 17:48
Re: Converting from MS Access field aliases paallen 18:07
Re: Converting from MS Access field aliases Adam Tauno Williams 20:34
Query Plan Radhika Sambamurti 21:11
Re: Converting from MS Access field aliases Gregory Stark 22:00
Re: Query Plan Gregory Stark 22:14
Re: Converting from MS Access field aliases Tom Lane 22:48

July 13, 2007

Thread Author Time
Re: Converting from MS Access field aliases Nis Jørgensen 06:36
calling webservice through postgresql function Jyoti Seth 07:14
Re: calling webservice through postgresql function Richard Huxton 07:26
Re: calling webservice through postgresql function Jyoti Seth 07:31
Re: calling webservice through postgresql function Richard Huxton 07:37
Re: calling webservice through postgresql function A. Kretschmer 07:46
calculation of pay based on dates Penchalaiah P. 10:12
Re: calculation of pay based on dates Gary Stainburn 10:16
Bitmap Index Scan Radhika Sambamurti 20:01
Re: Bitmap Index Scan Rodrigo De León 20:12

July 14, 2007

Thread Author Time
Re: Converting from MS Access field aliases Andrej Ricnik-Bay 01:42

July 15, 2007

Thread Author Time
data dependent sequences? Stuart McGraw 15:28
Re: data dependent sequences? Ragnar 16:04
Re: data dependent sequences? chester c young 16:07

July 16, 2007

Thread Author Time
Having the sum of two queries Dani Castaños 11:06
Re: Having the sum of two queries Achilleas Mantzios 11:15
Re: Having the sum of two queries Roberto Spier 11:57
Re: [OBORONA-SPAM] calling webservice through postgresql function Dmitry Turin 13:18
Re: Having the sum of two queries Hélder M. Vieira 22:00

July 17, 2007

Thread Author Time
Re: [OBORONA-SPAM] calling webservice through postgresql function Jyoti Seth 05:18
Re: Having the sum of two queries Dani Castaños 07:14
Re: data dependent sequences? Stuart 13:34
Re: data dependent sequences? Stuart 13:34
Re: data dependent sequences? Richard Broersma Jr 14:19
Re: data dependent sequences? Andrew Sullivan 15:00
Re: data dependent sequences? Stuart 15:40
Re: data dependent sequences? Andrew Sullivan 16:44
Re: data dependent sequences? Stuart 18:23
Re: data dependent sequences? Andrew Sullivan 20:48

July 18, 2007

Thread Author Time
Inserting an IF statement in the middle of a SELECT in pl/pgSQL code Norm Garand 02:42
Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code Rodrigo De León 04:46
Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code Jaime Casanova 04:50
A better look at trying to insert a Conditional in a SELECT statement Norm Garand 05:33
Database Synchronization Jyoti Seth 07:14
Re: Database Synchronization Richard Huxton 07:28
Birth Day Calculation Ashish Karalkar 11:02
Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code Fernando Hevia 12:46
Re: Birth Day Calculation Osvaldo Rosario Kussama 13:56
Re: Database Synchronization Chris Browne 14:57
Re: Database Synchronization Richard Huxton 15:43
pgmemcache PostgreSQL Admin 16:46

July 19, 2007

Thread Author Time
Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code Jaime Casanova 02:40
Re: Database Synchronization Jyoti Seth 04:31
Re: pgmemcache Hannes Dorbath 07:31
UNION and LIMIT issue Howard Smith 22:00
Re: UNION and LIMIT issue Tom Lane 22:27

July 20, 2007

Thread Author Time
Re: UNION and LIMIT issue ljb 01:41

July 22, 2007

Thread Author Time
The nested view from hell - Restricting a subquerry Bryce Nesbitt 03:10
Re: The nested view from hell - Restricting a subquerry Nis Jørgensen 09:06
Re: The nested view from hell - Restricting a subquerry Tom Lane 18:05
Re: The nested view from hell - Restricting a subquerry Bryce Nesbitt 18:57
how to download linux 7.3 image Jean-David Beyer 22:03

July 23, 2007

Thread Author Time
Re: The nested view from hell - Restricting a subquerry Nis Jørgensen 00:02
Re: The nested view from hell - Restricting a subquerry Gregory Stark 04:21
Re: The nested view from hell - Restricting a subquerry Nis Jørgensen 05:36
Re: how to download linux 7.3 image Aarni Ruuhimäki 07:42
Re: Database Synchronization Jyoti Seth 09:25
Re: The nested view from hell - Restricting a subquerry Gregory Stark 11:23
Re: The nested view from hell - Restricting a subquerry Nis Jørgensen 11:57
Re: The nested view from hell - Restricting a subquerry Gregory Stark 12:02
Re: Database Synchronization Andrew Sullivan 18:13

July 24, 2007

Thread Author Time
Re: Database Synchronization Jyoti Seth 07:45
is there a 'table' data type in pg? Louis-David Mitterrand 12:42
Re: is there a 'table' data type in pg? Gregory Stark 14:10
Re: is there a 'table' data type in pg? Louis-David Mitterrand 14:23
Re: is there a 'table' data type in pg? Peter Childs 14:33
inheriting a rule or a trigger? Louis-David Mitterrand 14:37

July 25, 2007

Thread Author Time
Database synchronization Jyoti Seth 10:12
Re: Database synchronization Richard Huxton 10:24
Re: Database synchronization Jyoti Seth 10:40
Re: Database synchronization Richard Huxton 12:39
Assistance with a trigger Paul Lambert 22:29
Re: Assistance with a trigger chester c young 23:23

July 26, 2007

Thread Author Time
Re: Assistance with a trigger Paul Lambert 00:26
Re: Database synchronization Jyoti Seth 04:50
Re: The nested view from hell - Restricting a subquerry Bryce Nesbitt 07:30
How to cast, if type has spaces in the name Bryce Nesbitt 07:33
Re: How to cast, if type has spaces in the name A. Kretschmer 07:39
Re: How to cast, if type has spaces in the name A. Kretschmer 07:42
Tunning PostgreSQL performance for views on Windows Ranieri Mazili 14:26
Re: Tunning PostgreSQL performance for views on Windows Bill Moran 14:49
Re: How to cast, if type has spaces in the name Stephan Szabo 15:00
Re: Tunning PostgreSQL performance for views on Windows Harald Armin Massa 15:17

July 27, 2007

Thread Author Time
unique index on fields with possible null values Dmitry Ruban 00:59
Join question Paul Lambert 01:33
problem join chester c young 01:39
Re: Join question Phillip Smith 01:46
Re: Join question Phillip Smith 01:48
Re: Join question Paul Lambert 02:18
Re: unique index on fields with possible null values Tom Lane 02:49
Re: calling webservice through postgresql function Dmitry Turin 06:40
strange result for select * from table where id=random()*900 Stefan Zweig 07:48
Re: strange result for select * from table where id=random()*900 Tommy Gildseth 07:56
Re: strange result for select * from table where id=random()*900 Achilleas Mantzios 08:12
Re: strange result for select * from table where id=random()*900 Kristo Kaiv 09:23
Re: Tunning PostgreSQL performance for views on Windows Merlin Moncure 13:38
Re: problem join Osvaldo Rosario Kussama 15:47
group by range of values Carol Cheung 19:05
Re: group by range of values Jon Sime 19:25
Re: group by range of values Rodrigo De León 19:28
Re: group by range of values Pavel Stehule 19:30
Re: group by range of values Rodrigo De León 19:31
Re: group by range of values Michael Glaesemann 20:43

July 28, 2007

Thread Author Time
raise exception and transaction handling Marcin Krawczyk 20:54

July 29, 2007

Thread Author Time
Re: raise exception and transaction handling Michal Kedziora 11:33
increment the primary key value without using sequences roopa perumalraja 12:00
Re: increment the primary key value without using sequences Michael Glaesemann 13:37

July 30, 2007

Thread Author Time
Migration from SQLite Help (Left Join) Mitchell Vincent 02:28
Re: Migration from SQLite Help (Left Join) Nis Jørgensen 05:30
Re: raise exception and transaction handling Bart Degryse 08:07
hi Penchalaiah P. 08:11
Re: [SQL] Tunning PostgreSQL performance for views on Windows Lewis Cunningham 12:22
Connection Limit Jon Horsman 21:29
Table-name as parameter to plpgsql Andreas Joseph Krogh 21:35
Re: Connection Limit Jon Horsman 21:41
Re: Connection Limit Andrew Sullivan 21:51
Re: Connection Limit Scott Marlowe 22:20

July 31, 2007

Thread Author Time
Re: Table-name as parameter to plpgsql Milen A. Radev 00:34
alter table table add column Ronald Rojas 04:19
Re: [NOVICE] alter table table add column Michael Glaesemann 04:32
Re: [NOVICE] alter table table add column Ronald Rojas 05:23
Re: Migration from SQLite Help (Left Join) Tom Lane 05:34
Re: [NOVICE] alter table table add column Michael Glaesemann 05:56

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 10 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31