Home > mailing lists

Mailing lists [pgsql-sql]

1 July 2007

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

2 July 2007

00:16 Re: yet another simple SQL question Andrej Ricnik-Bay
08:24 Replace usage of a table in query with its array values Loredana Curugiu
22:45 Using escape strings in an insert statement. Paul Lambert
23:11 Re: Using escape strings in an insert statement. Michael Glaesemann
23:27 Re: Using escape strings in an insert statement. Paul Lambert

3 July 2007

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

4 July 2007

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

5 July 2007

07:29 'comp.databases.theory' Dmitry Turin
08:36 Re: 'comp.databases.theory' Michael Holzman
17:20 Re: separating improperly grouped page views Jeff Frost
19:01 Working with dates Ranieri Mazili
20:50 Re: [GENERAL] Working with dates Ranieri Mazili

6 July 2007

13:55 select from table and add rows. Gary Stainburn
14:14 Quote problem Bart Degryse
15:03 Re: select from table and add rows. Andrew Sullivan
16:15 Re: Iterate and write a previous row to a temp table? Bob Singleton
16:38 Re: select from table and add rows. Gary Stainburn
16:54 Re: select from table and add rows. Andrew Sullivan
17:18 Re: select from table and add rows. Jon Sime

10 July 2007

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

11 July 2007

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

12 July 2007

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

13 July 2007

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

14 July 2007

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

15 July 2007

15:36 data dependent sequences? Stuart McGraw
16:01 Re: data dependent sequences? Ragnar
16:07 Re: data dependent sequences? chester c young

16 July 2007

11:06 Having the sum of two queries Dani Castaños
11:16 Re: Having the sum of two queries Achilleas Mantzios
12:17 Re: Having the sum of two queries Roberto Spier
13:34 Re: [OBORONA-SPAM] calling webservice through postgresql function Dmitry Turin
22:01 Re: Having the sum of two queries Hélder M. Vieira

17 July 2007

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

18 July 2007

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

19 July 2007

02:40 Re: Inserting an IF statement in the middle of a SELECT in pl/pgSQL code Jaime Casanova
04:33 Re: Database Synchronization Jyoti Seth
22:07 UNION and LIMIT issue Howard Smith
22:28 Re: UNION and LIMIT issue Tom Lane

20 July 2007

01:41 Re: UNION and LIMIT issue ljb

22 July 2007

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

23 July 2007

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

24 July 2007

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

25 July 2007

10:16 Database synchronization Jyoti Seth
10:24 Re: Database synchronization Richard Huxton
10:43 Re: Database synchronization Jyoti Seth
12:42 Re: Database synchronization Richard Huxton
22:29 Assistance with a trigger Paul Lambert
23:23 Re: Assistance with a trigger chester c young

26 July 2007

00:26 Re: Assistance with a trigger Paul Lambert
05:13 Re: Database synchronization Jyoti Seth
07:30 Re: The nested view from hell - Restricting a subquerry Bryce Nesbitt
07:33 How to cast, if type has spaces in the name Bryce Nesbitt
07:39 Re: How to cast, if type has spaces in the name A. Kretschmer
07:43 Re: How to cast, if type has spaces in the name A. Kretschmer
14:26 Tunning PostgreSQL performance for views on Windows Ranieri Mazili
15:01 Re: How to cast, if type has spaces in the name Stephan Szabo

27 July 2007

01:28 unique index on fields with possible null values Dmitry Ruban
01:33 Join question Paul Lambert
01:39 problem join chester c young
01:47 Re: Join question Phillip Smith
01:48 Re: Join question Phillip Smith
02:18 Re: Join question Paul Lambert
02:49 Re: unique index on fields with possible null values Tom Lane
07:48 strange result for select * from table where id=random()*900 Stefan Zweig
07:56 Re: strange result for select * from table where id=random()*900 Tommy Gildseth
08:12 Re: strange result for select * from table where id=random()*900 Achilleas Mantzios
08:49 Re: calling webservice through postgresql function Dmitry Turin
09:23 Re: strange result for select * from table where id=random()*900 Kristo Kaiv
15:44 Re: problem join Osvaldo Rosario Kussama
19:05 group by range of values Carol Cheung
19:26 Re: group by range of values Jon Sime
19:30 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 Rodrigo De León
20:43 Re: group by range of values Michael Glaesemann

28 July 2007

21:00 raise exception and transaction handling Marcin Krawczyk

29 July 2007

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

30 July 2007

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

31 July 2007

00:35 Re: Table-name as parameter to plpgsql Milen A. Radev
04:20 alter table table add column Ronald Rojas
04:33 Re: [NOVICE] alter table table add column Michael Glaesemann
05:34 Re: Migration from SQLite Help (Left Join) Tom Lane
08:02 Re: Database synchronization Jyoti Seth
08:22 Re: Database synchronization Richard Huxton
13:07 Re: calling webservice through postgresql function Dmitry Turin
13:36 Re: Database synchronization Andrew Sullivan
18:03 Alternative to INTERSECT Andreas Joseph Krogh
18:59 Re: Alternative to INTERSECT Josh Trutwin
19:06 Re: Connection Limit Jon Horsman
19:45 Re: Alternative to INTERSECT Andreas Joseph Krogh
20:31 Re: Alternative to INTERSECT Rodrigo De León
21:09 Re: Alternative to INTERSECT Stephan Szabo