Home > mailing lists

Mailing lists [pgsql-sql]

6 March 2007

08:01 Re: GiST index question: performance Peter Eisentraut
12:20 Time of executed query Ezequias Rodrigues da Rocha
12:31 Re: Time of executed query Bart Degryse
12:37 Re: Time of executed query Ezequias Rodrigues da Rocha
12:42 convert to a string Shavonne Marietta Wijesinghe
12:43 Re: Time of executed query Shoaib Mir
12:48 Re: Time of executed query Bart Degryse
12:54 Re: convert to a string Bart Degryse
12:55 Re: Time of executed query Ezequias Rodrigues da Rocha
12:57 Re: convert to a string A. Kretschmer
13:01 Re: Time of executed query Shoaib Mir
13:02 Re: Time of executed query Bart Degryse
13:32 Re: convert to a string Shavonne Marietta Wijesinghe
13:38 Re: convert to a string Bart Degryse
13:49 Re: convert to a string Shavonne Marietta Wijesinghe
14:06 Selecting exactly one row for each column value Florian Weimer
14:17 Re: Selecting exactly one row for each column value A. Kretschmer
14:20 [Fwd: View Vs. Table] Radhika Sambamurti
14:32 Re: Selecting exactly one row for each column value Tom Lane
14:37 Re: Time of executed query Rodrigo De León
14:39 Re: Time of executed query Rodrigo De León
14:46 Re: Selecting exactly one row for each column value Florian Weimer
14:53 Re: [Fwd: View Vs. Table] Andrew Sullivan
15:55 Inc Ezequias Rodrigues da Rocha
16:15 Re: Inc Richard Huxton
16:29 Re: Inc Ezequias Rodrigues da Rocha
16:41 Re: Inc Richard Broersma Jr
16:43 Re: GiST index question: performance Steve Midgley
16:46 Re: Inc Andreas Kretschmer
16:53 Re: Inc Andreas Kretschmer
17:02 Re: Inc Ezequias Rodrigues da Rocha
17:14 Re: Selecting exactly one row for each column value Stefan Becker
17:14 Re: Inc Richard Huxton
17:57 Re: GiST index question: performance Oleg Bartunov
18:09 Re: Inc Ezequias Rodrigues da Rocha
20:49 best index for ~ ordering? Gerardo Herzig
21:28 Re: best index for ~ ordering? Andrew Sullivan

7 March 2007

00:16 Re: How to union table without union statement? calendarw
02:18 Re: best index for ~ ordering? gherzig@fmed.uba.ar
10:36 PRIMARY KEY Shavonne Marietta Wijesinghe
10:53 Re: PRIMARY KEY Richard Huxton
10:59 Re: PRIMARY KEY M.P.Dankoor
11:52 Re: PRIMARY KEY M.P.Dankoor
12:16 Re: PRIMARY KEY Shavonne Marietta Wijesinghe
14:53 tesearch2 question Sumeet
17:32 Re: best index for ~ ordering? Andrew Sullivan
18:02 Re: tesearch2 question Oleg Bartunov
19:11 SHA-1 vs MD5 Ezequias Rodrigues da Rocha
19:17 Re: SHA-1 vs MD5 Andrew Sullivan
19:31 Re: SHA-1 vs MD5 Andrej Ricnik-Bay
19:40 Re: tesearch2 question Sumeet
19:49 Re: tesearch2 question Oleg Bartunov
20:44 Re: SHA-1 vs MD5 Chad Wagner

8 March 2007

10:39 Re: SHA-1 vs MD5 Ezequias Rodrigues da Rocha
13:52 Re: SHA-1 vs MD5 Chad Wagner
18:06 A form of inheritance with PostgreSQL Greg Toombs
19:03 Re: A form of inheritance with PostgreSQL Richard Huxton
19:05 Re: A form of inheritance with PostgreSQL Richard Broersma Jr
19:25 Re: inheritance chester c young
20:46 Re: inheritance Shane Ambler
21:11 Re: inheritance Richard Broersma Jr
21:20 Re: inheritance chester c young
21:27 Re: inheritance Richard Broersma Jr
23:42 [Re: PRIMARY KEY] Phillip Smith
23:42 View Vs. Table Radhika Sambamurti
23:45 Select when table have missing data Lars Gregersen
23:50 Re: inheritance Shane Ambler

9 March 2007

00:30 Re: Select when table have missing data Rodrigo De León
01:13 Creating views Kashmira Patel \(kupatel\)
07:28 Re: A form of inheritance with PostgreSQL Bart Degryse
07:34 Re: Creating views Richard Huxton
11:05 Table inherit & foreign key problem Moritz Kobel
11:35 Re: SHA-1 vs MD5 Ezequias Rodrigues da Rocha
11:38 Re: Table inherit & foreign key problem Richard Huxton
12:14 Re: SHA-1 vs MD5 Chad Wagner
12:56 CREATE TABLE Shavonne Marietta Wijesinghe
13:09 Re: CREATE TABLE Rodrigo De León
13:16 Fw: CREATE TABLE Shavonne Marietta Wijesinghe
13:17 Fw: CREATE TABLE Shavonne Marietta Wijesinghe
13:17 Re: CREATE TABLE Milen A. Radev
13:21 Re: CREATE TABLE Andrew Sullivan
13:22 Re: Fw: CREATE TABLE Andrew Sullivan
13:37 Re: CREATE TABLE Bart Degryse
14:09 index not being used. Why? Gerardo Herzig
14:48 Re: View Vs. Table Bruno Wolff III
14:49 Re: [Re: PRIMARY KEY] Bruno Wolff III
15:00 Re: index not being used. Why? Richard Huxton
15:02 Re: index not being used. Why? Andrew Sullivan
15:29 Re: index not being used. Why? Tom Lane
15:38 Re: A form of inheritance with PostgreSQL Steve Midgley
15:47 Re: index not being used. Why? Gerardo Herzig
16:22 Statistics Ezequias Rodrigues da Rocha
16:26 Re: SHA-1 vs MD5 Ezequias Rodrigues da Rocha
16:35 Re: Statistics Joe
16:35 Re: SHA-1 vs MD5 Chad Wagner
16:49 Re: SHA-1 vs MD5 Ezequias Rodrigues da Rocha
16:54 PostgreSQL to Oracle Ezequias Rodrigues da Rocha
17:00 Re: Statistics Frank Bax
17:01 Running in single instance mode Karthikeyan Sundaram
17:06 Re: PostgreSQL to Oracle Frank Bax
17:07 Re: Statistics Ezequias Rodrigues da Rocha
17:32 Re: PostgreSQL to Oracle Jonah H. Harris
17:58 Re: Running in single instance mode Rodrigo De León
18:32 Re: PostgreSQL to Oracle Ezequias Rodrigues da Rocha
18:58 Re: index not being used. Why? Scott Marlowe
19:24 Re: index not being used. Why? gherzig@fmed.uba.ar
21:40 Re: [Re: PRIMARY KEY] Phillip Smith

11 March 2007

14:20 Alternative Serial Ezequias Rodrigues da Rocha
15:09 Re: [pgadmin-support] Alternative Serial Ezequias Rodrigues da Rocha
16:05 There is acid without transactions ? Ezequias Rodrigues da Rocha
16:35 Re: There is acid without transactions ? Jonah H. Harris
16:39 Re: There is acid without transactions ? Ezequias Rodrigues da Rocha
16:42 Re: There is acid without transactions ? Michael Fuhr
16:42 Re: There is acid without transactions ? Ezequias Rodrigues da Rocha
16:53 Re: Alternative Serial A. Kretschmer
20:30 Re: There is acid without transactions ? Jonah H. Harris

12 March 2007

19:01 how to use a date range in a join chester c young
19:10 Re: how to use a date range in a join Andreas Kretschmer
20:42 Installing with libs of postgresql-libs
20:57 Re: Installing with libs of postgresql-libs Jorge Godoy

13 March 2007

00:08 Re: A form of inheritance with PostgreSQL Greg Toombs
01:24 Re: A form of inheritance with PostgreSQL Tom Lane
01:34 Re: A form of inheritance with PostgreSQL Greg Toombs
03:21 Re: A form of inheritance with PostgreSQL Alvaro Herrera
03:41 Re: A form of inheritance with PostgreSQL Greg Toombs
04:15 Re: A form of inheritance with PostgreSQL Tom Lane
13:02 Re: For loop Ezequias R. da Rocha
13:14 Re: For loop Bart Degryse
13:22 Re: For loop Ezequias R. da Rocha
13:28 Re: For loop Bart Degryse
13:28 Re: For loop Alvaro Herrera
13:32 Re: For loop Adrian Klaver
13:33 Re: For loop Ezequias R. da Rocha
13:39 Re: For loop Jonah H. Harris
13:41 Re: For loop Alvaro Herrera
13:42 Re: For loop Bart Degryse
13:43 Re: For loop A. Kretschmer
13:44 Re: For loop Adrian Klaver
13:50 For loop Ezequias R. da Rocha
14:06 Re: For loop Ezequias R. da Rocha
14:28 Re: For loop Alvaro Herrera
14:35 Re: For loop Ezequias R. da Rocha
15:59 PgAdmin 1.6.2 crashes when resize the collumn Ezequias Rodrigues da Rocha
16:13 Re: PgAdmin 1.6.2 crashes when resize the collumn Richard Huxton
16:38 PgAgent logging verbosity Ezequias Rodrigues da Rocha
16:43 Re: [GENERAL] PgAgent logging verbosity Dave Page
16:50 Re: [ADMIN] [GENERAL] PgAgent logging verbosity Ezequias R. da Rocha
16:53 Re: [ADMIN] [GENERAL] PgAgent logging verbosity Dave Page
17:14 postgres configuration Sumeet
18:06 Re: postgres configuration Andrej Ricnik-Bay
20:16 Maintence DB Ezequias R. da Rocha
20:42 Re: Maintence DB Greg Toombs
20:55 Re: postgres configuration Sumeet
21:07 Re: postgres configuration Scott Marlowe
21:30 Re: postgres configuration Tom Lane
22:12 import CSV file T E Schmitz
22:27 Re: import CSV file D'Arcy J.M. Cain
22:27 Re: import CSV file Alvaro Herrera
23:39 Re: import CSV file Jure Kodzoman
23:44 Re: import CSV file T E Schmitz
23:50 Re: import CSV file T E Schmitz
23:52 Re: import CSV file T E Schmitz

14 March 2007

01:45 Re: Maintence DB Jonah H. Harris
01:49 Re: import CSV file Rodrigo De León
08:14 How to declare cursor if tablename is a variable? hu js
12:44 reindex database Sabin Coanda
13:12 Re: reindex database Achilleas Mantzios
14:09 Re: How to declare cursor if tablename is a variable? Michael Fuhr
14:45 Re: import CSV file T E Schmitz
15:09 Re: import CSV file T E Schmitz
15:40 Joins on many-to-many relations. Wiebe Cazemier
15:50 ordering by multiple columns Pablo Barrón
15:59 Re: import CSV file Andrew Sullivan
16:11 Re: ordering by multiple columns Andreas Kretschmer
16:14 Re: ordering by multiple columns Rodrigo De León
18:01 Re: Joins on many-to-many relations. Frank Bax
20:38 unsubscribe Stefan
21:47 ... Nigel Henry
21:59 Re: Joins on many-to-many relations. Wiebe Cazemier

15 March 2007

06:50 unsubscribe Stefan Ionita
08:41 unsubscribe Neelam Goyal
12:54 unsubscribe Susan Evans
13:35 Alter Table Shavonne Marietta Wijesinghe
13:46 Re: Alter Table A. Kretschmer
14:06 Re: Joins on many-to-many relations. Rodrigo De León
14:19 Re: Joins on many-to-many relations. Wiebe Cazemier
15:51 join table with itself? T E Schmitz
15:57 Re: join table with itself? William Leite Araújo
16:13 Re: Alter Table Scott Marlowe
18:55 Re: join table with itself? T E Schmitz

16 March 2007

08:50 INSERT INTO Shavonne Marietta Wijesinghe
09:03 Re: INSERT INTO Bart Degryse
09:17 Re: INSERT INTO Guillaume Lelarge
09:27 Fw: INSERT INTO Shavonne Marietta Wijesinghe
10:31 Re: INSERT INTO Shavonne Marietta Wijesinghe
11:56 Re: Joins on many-to-many relations. Wiebe Cazemier
12:07 Re: INSERT INTO Guillaume Lelarge
13:02 Re: INSERT INTO Richard Broersma Jr
13:08 Re: INSERT INTO Richard Broersma Jr
13:37 Re: INSERT INTO Shavonne Marietta Wijesinghe
14:45 Re: INSERT INTO Alvaro Herrera
15:29 Grabbing Newest Records From Duplicates Travis Whitton
15:35 Re: Grabbing Newest Records From Duplicates Tom Lane
15:55 Re: Grabbing Newest Records From Duplicates Travis Whitton
15:58 log file permissions? Gerardo Herzig
16:18 Re: Grabbing Newest Records From Duplicates Tom Lane
16:18 Re: log file permissions? Steve Crawford
16:22 Re: log file permissions? Tom Lane

17 March 2007

01:40 Re: INSERT INTO Josh Williams
10:56 Rollback Hetal Patel
11:19 Re: Rollback Phillip Smith
12:00 Re: Rollback Hetal Patel

18 March 2007

20:37 triple self-join crawling T E Schmitz

19 March 2007

01:21 better approach: case or join chester c young
02:56 Help with sub query roopa perumalraja
04:03 Re: Help with sub query Phillip Smith
05:38 create view with check option Karthikeyan Sundaram
05:58 Re: create view with check option Tom Lane
08:12 Re: triple self-join crawling Andrew Sullivan
08:22 Re: triple self-join crawling T E Schmitz
12:23 Encode Ezequias R. da Rocha
12:39 Re: Encode Shoaib Mir
14:17 Re: [ADMIN] create view with check option Tom Lane
16:40 Multiple partition tables and faster queries Maya Nigrosh
18:19 Re: triple self-join crawling T E Schmitz
18:24 Re: triple self-join crawling T E Schmitz
18:36 Re: Encode Jure Kodzoman
20:41 Re: [ADMIN] create view with check option Karthikeyan Sundaram
21:57 Re: triple self-join crawling Martin Marques

20 March 2007

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

21 March 2007

02:51 Substitute Judith
03:02 Re: Substitute Milen A. Radev
03:03 Re: Substitute Michael Fuhr
03:32 Re: [ADMIN] ERROR: invalid byte sequence for encoding "UTF8": 0x92 Michael Fuhr
06:11 unsubscribe Stefan
07:16 unsubscribe Piotr Dabrowski
14:07 Regular Expressions Ezequias R. da Rocha
14:29 Re: Regular Expressions Bricklen Anderson
14:37 Re: Regular Expressions Guy Fraser
14:50 Anyone still using the sql_inheritance parameter? Tom Lane
16:21 job opportunity Max.Kaufmann@lazard.com
17:01 Re: Issue with copying data from a text file. Steve Midgley
17:26 growth of the database Karthikeyan Sundaram
17:39 Re: Regular Expressions Ezequias R. da Rocha
20:32 Re: Regular Expressions Guy Fraser
21:49 Monitor what command is executing at the backend Karthikeyan Sundaram
21:56 Re: Monitor what command is executing at the backend George Pavlov
22:16 Re: Monitor what command is executing at the backend Karthikeyan Sundaram
22:24 Re: Monitor what command is executing at the backend George Pavlov

22 March 2007

01:35 Re: Regular Expressions Andrew Sullivan
11:56 unsubscribe Susan Evans
13:50 Subqueryes Ezequias R. da Rocha
13:57 Re: Subqueryes Alvaro Herrera
14:08 Re: Subqueryes Richard Broersma Jr
14:23 Re: growth of the database Hubertus Freiherr von Fuerstenberg
14:44 Re: Subqueryes Ezequias R. da Rocha
19:46 Dummy question Ezequias R. da Rocha
20:18 Re: Dummy question Joe
20:29 Re: Dummy question Ezequias R. da Rocha

23 March 2007

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

26 March 2007

14:04 Selecting different views from a Boolean expression Wilkinson, Jim
20:43 Shared Buffers

27 March 2007

01:50 Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) Bruce Momjian
06:47 array_to_string Sabin Coanda
12:38 select vs. select count Claus Guttesen
12:39 Re: select vs. select count Claus Guttesen
13:22 Foreign Unique Constraint Jon Horsman
13:36 Re: Foreign Unique Constraint A. Kretschmer
14:20 Re: select vs. select count Peter Eisentraut
14:27 Re: Foreign Unique Constraint Jon Horsman
14:50 Re: array_to_string Tom Lane
15:08 Re: array_to_string Richard Huxton
15:36 Re: array_to_string Tom Lane
15:52 Re: array_to_string Richard Huxton
15:58 Re: Foreign Unique Constraint Peter Eisentraut
16:11 Re: select vs. select count Tom Lane
17:42 Re: Foreign Unique Constraint chester c young
19:44 Re: Regular Expressions
22:16 Re: Regular Expressions Richard Broersma Jr
22:17 Re: Foreign Unique Constraint Phillip Smith

28 March 2007

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

29 March 2007

05:36 SELECT INSTEAD Phillip Smith
06:48 Re: SELECT INSTEAD Michael Fuhr
06:58 Re: SELECT INSTEAD Phillip Smith
07:01 Re: SELECT INSTEAD Richard Huxton
15:26 Temp tbl Vs. View Radhika Sambamurti
15:46 Re: Temp tbl Vs. View Richard Broersma Jr
15:56 Re: Temp tbl Vs. View Rodrigo De León
18:07 Empty Table
18:17 Re: Empty Table Rajesh Kumar Mallah
18:39 Re: Empty Table
19:43 Re: Empty Table Rajesh Kumar Mallah
20:01 Re: Empty Table Rajesh Kumar Mallah
20:15 Re: Track query status Rajesh Kumar Mallah
21:23 Re: Foreign Unique Constraint Jon Horsman
21:56 Re: olympics ranking query Kyle Bateman

30 March 2007

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

31 March 2007

07:43 plpgsql function return array Karthikeyan Sundaram
12:56 Re: plpgsql function return array Michael Fuhr