Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| import CSV file | T E Schmitz | 20:38 |
| Re: Maintence DB 📎 | Greg Toombs | 20:43 |
| Re: postgres configuration | Sumeet | 20:48 |
| Re: postgres configuration | Scott Marlowe | 21:07 |
| Re: postgres configuration | Tom Lane | 21:30 |
| Re: import CSV file | Alvaro Herrera | 22:27 |
| Re: import CSV file | D'Arcy J.M. Cain | 22:27 |
| Re: import CSV file | Jure Kodzoman | 22:35 |
| Re: import CSV file | T E Schmitz | 23:44 |
| Re: import CSV file | T E Schmitz | 23:48 |
| Re: import CSV file | T E Schmitz | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Maintence DB | Jonah H. Harris | 01:44 |
| Re: import CSV file | Rodrigo De León | 01:48 |
| How to declare cursor if tablename is a variable? | hu js | 08:14 |
| reindex database | Sabin Coanda | 12:44 |
| Re: reindex database | Achilleas Mantzios | 13:12 |
| Re: How to declare cursor if tablename is a variable? | Michael Fuhr | 14:09 |
| Re: import CSV file | T E Schmitz | 14:45 |
| Re: import CSV file | T E Schmitz | 15:09 |
| Joins on many-to-many relations. | Wiebe Cazemier | 15:39 |
| ordering by multiple columns | Pablo Barrón | 15:50 |
| Re: import CSV file | Andrew Sullivan | 15:58 |
| Re: ordering by multiple columns | Andreas Kretschmer | 16:12 |
| Re: ordering by multiple columns | Rodrigo De León | 16:14 |
| Re: Joins on many-to-many relations. | Frank Bax | 17:58 |
| unsubscribe | Stefan | 20:38 |
| [No subject] | Nigel Henry | 21:46 |
| Re: Joins on many-to-many relations. | Wiebe Cazemier | 21:59 |
| Thread | Author | Time |
|---|---|---|
| unsubscribe | Stefan Ionita | 06:50 |
| unsubscribe | Neelam Goyal | 08:40 |
| unsubscribe | Susan Evans | 11:56 |
| Alter Table | Shavonne Marietta Wijesinghe | 13:35 |
| Re: Alter Table | A. Kretschmer | 13:46 |
| Re: Joins on many-to-many relations. | Rodrigo De León | 14:05 |
| Re: Joins on many-to-many relations. | Wiebe Cazemier | 14:16 |
| join table with itself? | T E Schmitz | 15:45 |
| Re: join table with itself? | William Leite Araújo | 15:57 |
| Re: Alter Table | Scott Marlowe | 16:13 |
| Re: join table with itself? | T E Schmitz | 18:54 |
| Re: [SQL] PostgreSQL to Oracle | Robert Treat | 20:20 |
| Re: [SQL] PostgreSQL to Oracle | Jonah H. Harris | 20:47 |
| Thread | Author | Time |
|---|---|---|
| INSERT INTO | Shavonne Marietta Wijesinghe | 08:50 |
| Re: INSERT INTO | Bart Degryse | 09:03 |
| Re: INSERT INTO | Guillaume Lelarge | 09:16 |
| Fw: INSERT INTO | Shavonne Marietta Wijesinghe | 09:26 |
| Re: INSERT INTO | Shavonne Marietta Wijesinghe | 10:31 |
| Re: Joins on many-to-many relations. | Wiebe Cazemier | 11:56 |
| Re: INSERT INTO | Guillaume Lelarge | 12:07 |
| Re: INSERT INTO | Richard Broersma Jr | 13:02 |
| Re: INSERT INTO | Richard Broersma Jr | 13:08 |
| Re: INSERT INTO | Shavonne Marietta Wijesinghe | 13:37 |
| Re: INSERT INTO | Alvaro Herrera | 14:45 |
| Grabbing Newest Records From Duplicates | Travis Whitton | 15:28 |
| Re: Grabbing Newest Records From Duplicates | Tom Lane | 15:35 |
| log file permissions? | Gerardo Herzig | 15:50 |
| Re: Grabbing Newest Records From Duplicates | Travis Whitton | 15:55 |
| Re: Grabbing Newest Records From Duplicates | Tom Lane | 16:17 |
| Re: log file permissions? | Steve Crawford | 16:18 |
| Re: log file permissions? | Tom Lane | 16:21 |
| Re: [SQL] PostgreSQL to Oracle | Reece Hart | 17:18 |
| Re: [SQL] PostgreSQL to Oracle | David Fetter | 17:44 |
| Re: [SQL] PostgreSQL to Oracle | Jonah H. Harris | 18:20 |
| Thread | Author | Time |
|---|---|---|
| Re: INSERT INTO | Josh Williams | 01:19 |
| Rollback | Hetal Patel | 10:49 |
| Re: Rollback | Phillip Smith | 11:23 |
| Re: Rollback | Hetal Patel | 11:59 |
| Thread | Author | Time |
|---|---|---|
| triple self-join crawling | T E Schmitz | 19:51 |
| Thread | Author | Time |
|---|---|---|
| better approach: case or join | chester c young | 01:21 |
| Help with sub query | roopa perumalraja | 02:56 |
| Re: Help with sub query | Phillip Smith | 04:03 |
| create view with check option | Karthikeyan Sundaram | 05:38 |
| Re: [SQL] create view with check option | Tom Lane | 05:58 |
| Re: [SQL] create view with check option | hubert depesz lubaczewski | 07:29 |
| Re: triple self-join crawling | Andrew Sullivan | 08:12 |
| Re: triple self-join crawling | T E Schmitz | 08:22 |
| Encode | Ezequias R. da Rocha | 12:21 |
| Re: Encode | Shoaib Mir | 12:39 |
| Re: [SQL] create view with check option | Tom Lane | 14:16 |
| Re: triple self-join crawling | T E Schmitz | 16:09 |
| Re: triple self-join crawling | T E Schmitz | 16:10 |
| Multiple partition tables and faster queries | Maya Nigrosh | 16:40 |
| Re: create view with check option | Gaetano Mendola | 17:34 |
| Re: Encode | Jure Kodzoman | 18:35 |
| Re: create view with check option | Karthikeyan Sundaram | 20:41 |
| Re: triple self-join crawling | Martin Marques | 22:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Regular Expressions | Andrew Sullivan | 01:35 |
| Re: growth of the database | Hubertus Freiherr von Fuerstenberg | 10:40 |
| unsubscribe | Susan Evans | 11:55 |
| Subqueryes | Ezequias R. da Rocha | 13:48 |
| Re: Subqueryes | Alvaro Herrera | 13:56 |
| Re: Subqueryes | Richard Broersma Jr | 14:07 |
| Re: Subqueryes | Ezequias R. da Rocha | 14:42 |
| Dummy question | Ezequias R. da Rocha | 19:43 |
| Re: Dummy question | Joe | 20:17 |
| Re: Dummy question | Ezequias R. da Rocha | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: How to declare cursor if tablename is a variable? | Michael Fuhr | 11:47 |
| Thread | Author | Time |
|---|---|---|
| Selecting different views from a Boolean expression | Wilkinson, Jim | 13:36 |
| Shared Buffers | ezequias | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Re: timestamp subtraction (was Re: [SQL] formatting intervals with to_char) | Bruce Momjian | 01:50 |
| array_to_string | Sabin Coanda | 06:47 |
| select vs. select count | Claus Guttesen | 12:37 |
| Re: select vs. select count | Claus Guttesen | 12:39 |
| Foreign Unique Constraint | Jon Horsman | 13:21 |
| Re: Foreign Unique Constraint | A. Kretschmer | 13:36 |
| Re: select vs. select count | Peter Eisentraut | 14:20 |
| Re: Foreign Unique Constraint | Jon Horsman | 14:27 |
| Re: array_to_string | Tom Lane | 14:49 |
| Re: array_to_string | Richard Huxton | 14:59 |
| Re: array_to_string | Tom Lane | 15:35 |
| Re: array_to_string | Richard Huxton | 15:45 |
| Re: Foreign Unique Constraint | Peter Eisentraut | 15:58 |
| Re: select vs. select count | Tom Lane | 16:10 |
| Re: Foreign Unique Constraint | chester c young | 17:35 |
| Re: Regular Expressions | ezequias | 20:01 |
| Re: Regular Expressions | Richard Broersma Jr | 22:16 |
| Re: Foreign Unique Constraint | Phillip Smith | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Foreign Unique Constraint | Jon Horsman | 03:51 |
| Re: Foreign Unique Constraint | Peter Eisentraut | 09:08 |
| Re: Regular Expressions [progress] | ezequias | 12:25 |
| Re: Foreign Unique Constraint | Jon Horsman | 13:28 |
| union with count? | Gerardo Herzig | 14:04 |
| Re: Regular Expressions [progress] | Richard Broersma Jr | 14:10 |
| Re: union with count? | A. Kretschmer | 14:24 |
| Re: union with count? | Richard Broersma Jr | 14:27 |
| Re: union with count? | Gerardo Herzig | 15:23 |
| Re: Rules with sequence columns | Tom Lane | 16:17 |
| Re: union with count? | Andreas Kretschmer | 16:19 |
| Rules with sequence columns | Ray Madigan | 16:25 |
| How too select different views using a IF/THEN/ELSE procedure ? | Wilkinson, Jim | 19:04 |
| Track query status | Sumeet | 20:59 |
| Re: Track query status | Andrew Sullivan | 21:49 |
| Re: Foreign Unique Constraint | Phillip Smith | 22:21 |
| Thread | Author | Time |
|---|---|---|
| SELECT INSTEAD | Phillip Smith | 05:35 |
| Re: SELECT INSTEAD | Michael Fuhr | 06:48 |
| Re: SELECT INSTEAD | Richard Huxton | 06:49 |
| Re: SELECT INSTEAD | Phillip Smith | 06:58 |
| Temp tbl Vs. View | Radhika Sambamurti | 15:26 |
| Re: Temp tbl Vs. View | Richard Broersma Jr | 15:46 |
| Re: Temp tbl Vs. View | Rodrigo De León | 15:56 |
| Re: Empty Table | Rajesh Kumar Mallah | 18:16 |
| Empty Table | ezequias | 18:25 |
| Re: Empty Table | ezequias | 18:50 |
| Re: Empty Table | Rajesh Kumar Mallah | 19:34 |
| Re: Empty Table | Rajesh Kumar Mallah | 19:41 |
| Re: Track query status | Rajesh Kumar Mallah | 19:48 |
| Re: Foreign Unique Constraint | Jon Horsman | 21:23 |
| Re: olympics ranking query | Kyle Bateman | 21:33 |
| Thread | Author | Time |
|---|---|---|
| Re: select vs. select count | Claus Guttesen | 11:19 |
| using sql on v7.4 server to feed stored procedure | Brian Jarrett | 19:19 |
| Re: using sql on v7.4 server to feed stored procedure | Tom Lane | 20:14 |
| function return array | Karthikeyan Sundaram | 21:16 |
| Thread | Author | Time |
|---|---|---|
| plpgsql function return array | Karthikeyan Sundaram | 07:43 |
| Re: plpgsql function return array | Michael Fuhr | 12:55 |