Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| unsubscribe | Dinesh Pandey | 05:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Error from trigger | Leif B. Kristensen | 10:07 |
| Thread | Author | Time |
|---|---|---|
| lo function changed in PostgreSQL 8.1.1 | Premsun Choltanwanich | 08:54 |
| exporting Excel tables into PostgreSQL database with Python 📎 | Jürgen Kemeter | 10:55 |
| Re: lo function changed in PostgreSQL 8.1.1 | Tom Lane | 15:39 |
| DB design and foreign keys | Gianluca Riccardi | 18:16 |
| Re: DB design and foreign keys | John McCawley | 18:31 |
| Re: DB design and foreign keys | Tom Lane | 18:31 |
| Re: DB design and foreign keys | Jaime Casanova | 18:32 |
| Re: DB design and foreign keys | Richard Huxton | 18:59 |
| Re: DB design and foreign keys | Scott Marlowe | 18:59 |
| Re: exporting Excel tables into PostgreSQL database with Python | Christian Kratzer | 21:40 |
| # of 5 minute intervals in period of time ... | Marc G. Fournier | 22:34 |
| Multi-row update w. plpgsql function | Daniel Hertz | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Multi-row update w. plpgsql function | Daniel Hertz | 00:46 |
| Re: Extract date from week | Neil Dugan | 01:08 |
| selective updates | Gianluca Riccardi | 15:06 |
| RETURN SET OF DATA WITH CURSOR | grupos | 15:26 |
| Re: selective updates | Gianluca Riccardi | 15:35 |
| Re: RETURN SET OF DATA WITH CURSOR | Richard Huxton | 16:03 |
| Re: RETURN SET OF DATA WITH CURSOR | grupos | 16:58 |
| Re: RETURN SET OF DATA WITH CURSOR | Richard Huxton | 17:14 |
| Re: Defaulting a column to 'now' | Ken Winter | 17:20 |
| Thread | Author | Time |
|---|---|---|
| Need SQL Help Finding Current Status of members 📎 | Michael Avila | 01:31 |
| Re: Need SQL Help Finding Current Status of members | Michael Fuhr | 02:58 |
| Re: RETURN SET OF DATA WITH CURSOR | Patrick JACQUOT | 08:59 |
| Re: Need SQL Help Finding Current Status of members | Richard Huxton | 09:24 |
| Re: Need SQL Help Finding Current Status of members | Patrick JACQUOT | 10:12 |
| Re: Need SQL Help Finding Current Status of members | Michael Avila | 13:46 |
| Re: Need SQL Help Finding Current Status of members | Alvaro Herrera | 13:57 |
| Problem obtaining MAX values FROM TABLE | Michael Farewell | 15:42 |
| Re: Help on function creating | Alexandre Gonçalves Jacarandá | 16:03 |
| Commiting after certain no of rows have been deleted | Smita Mahadik | 19:37 |
| Rule causes baffling error | Ken Winter | 21:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Need SQL Help Finding Current Status of members | Michael Avila | 00:44 |
| Re: Help on function creating | Bruno Wolff III | 21:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Need SQL Help Finding Current Status of members | Michael Fuhr | 00:26 |
| Re: Need SQL Help Finding Current Status of members | Michael Avila | 00:34 |
| Does VACUUM reorder tables on clustered indices | frank church | 21:12 |
| Re: Does VACUUM reorder tables on clustered indices | Martin Marques | 21:41 |
| Re: Does VACUUM reorder tables on clustered indices | Alvaro Herrera | 22:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Rule causes baffling error | Richard Huxton | 09:15 |
| Querying date_time for date only ? | Aarni Ruuhimäki | 12:59 |
| Re: Querying date_time for date only ? | Michael Burke | 13:19 |
| Re: Querying date_time for date only ? | Aarni Ruuhimäki | 13:33 |
| Sub-query as function argument | Michael Burke | 13:42 |
| Re: Sub-query as function argument | Jaime Casanova | 14:52 |
| Re: Sub-query as function argument | Michael Burke | 15:04 |
| Re: Querying date_time for date only ? | Tom Lane | 15:05 |
| Re: Sub-query as function argument | Tom Lane | 15:07 |
| Re: Does VACUUM reorder tables on clustered indices | Jim C. Nasby | 21:41 |
| Re: Performance of a view | Tom Lane | 23:31 |
| Re: Does VACUUM reorder tables on clustered indices | ipv | 23:34 |
| unsubscribe | William Lai | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Does VACUUM reorder tables on clustered indices | Jim C. Nasby | 00:33 |
| Re: Help me do a LOOP | Richard Huxton | 09:34 |
| Re: Commiting after certain no of rows have been deleted | Richard Huxton | 09:38 |
| Re: Help on a complex query (avg data for day of the week) | Richard Huxton | 10:04 |
| Re: [PERFORM] need help | Alban Medici (NetCentrex) | 11:10 |
| Re: Problem obtaining MAX values FROM TABLE | Michael Fuhr | 17:56 |
| Re: Does VACUUM reorder tables on clustered indices | Chris Browne | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Help on a complex query (avg data for day of the week) | Matthew Smith | 00:59 |
| Re: Help on a complex query (avg data for day of the week) | Michael Fuhr | 02:37 |
| lo function changed in PostgreSQL 8.1.1 (ask again) | Premsun Choltanwanich | 02:44 |
| Re: Help on a complex query (avg data for day of the week) | Matthew Smith | 02:59 |
| Re: Does VACUUM reorder tables on clustered indices | Bruce Momjian | 04:07 |
| Re: Querying date_time for date only ? | Bruce Momjian | 16:01 |
| Re: How to increase row deletion efficiency? 📎 | Alexander Stanier | 17:13 |
| Re: Does VACUUM reorder tables on clustered indices | Andrew Sullivan | 18:59 |
| Thread | Author | Time |
|---|---|---|
| Merry Xmas and a Happy New Year | Achilleus Mantzios | 14:16 |
| The Information Schema vs the PG Catalog | Ken Winter | 18:24 |
| Re: Merry Xmas and a Happy New Year | Terry Lee Tucker | 19:13 |
| Thread | Author | Time |
|---|---|---|
| Re: The Information Schema vs the PG Catalog | George Pavlov | 17:11 |
| order and order line item | David Garamond | 17:52 |
| constraint and ordered value | David Garamond | 17:52 |
| Re: The Information Schema vs the PG Catalog | Ken Winter | 19:32 |
| "large" IN/NOT IN subqueries result in query returning wrong data | George Pavlov | 19:41 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | Tom Lane | 19:44 |
| Re: "large" IN/NOT IN subqueries result in query returning | John McCawley | 19:53 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | George Pavlov | 20:36 |
| Thread | Author | Time |
|---|---|---|
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | elein | 00:12 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | Tom Lane | 00:25 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | elein | 00:35 |
| Cursors and recursion | Don Croata | 14:29 |
| instead of trigger in pg | J Crypter | 15:28 |
| Re: "large" IN/NOT IN subqueries result in query returning wrong data | Greg Stark | 15:47 |
| Re: Cursors and recursion | Tom Lane | 15:48 |
| Re: instead of trigger in pg | Jaime Casanova | 16:03 |
| Re: Cursors and recursion | Michael Fuhr | 17:03 |
| Re: Cursors and recursion | Don Croata | 19:37 |
| DISTINCT with NULLs and INT fields | George Pavlov | 19:57 |
| Re: DISTINCT with NULLs and INT fields | Tom Lane | 20:19 |
| Re: DISTINCT with NULLs and INT fields | George Pavlov | 20:37 |
| Re: DISTINCT with NULLs and INT fields | Tom Lane | 20:46 |
| Re: DISTINCT with NULLs and INT fields | George Pavlov | 21:04 |
| Re: DISTINCT with NULLs and INT fields | Alvaro Herrera | 21:24 |
| Help with simple query | Collin Peters | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with simple query | Frank Bax | 00:41 |
| Re: Help with simple query | Tom Lane | 00:43 |
| Re: Help with simple query | PFC | 01:31 |
| Re: Help with simple query | George Pavlov | 01:47 |
| Re: DISTINCT with NULLs and INT fields | George Pavlov | 02:00 |
| Re: Cursors and recursion | Michael Fuhr | 02:48 |
| Re: DISTINCT with NULLs and INT fields | Tom Lane | 03:03 |
| Re: constraint and ordered value | Bruno Wolff III | 07:16 |
| Re: constraint and ordered value | Daryl Richter | 12:15 |
| Problem with simple update query | Simon Gardner | 15:11 |
| Arrays in PL/pgSQL routines? | Ken Winter | 17:46 |
| Re: constraint and ordered value | David Garamond | 17:48 |
| Re: Arrays in PL/pgSQL routines? | Bricklen Anderson | 17:52 |
| Re: Arrays in PL/pgSQL routines? | Michael Fuhr | 18:21 |
| Re: Arrays in PL/pgSQL routines? | Ken Winter | 18:23 |
| Re: Arrays in PL/pgSQL routines? | Tom Lane | 18:42 |
| Re: Arrays in PL/pgSQL routines? | Michael Fuhr | 18:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Does VACUUM reorder tables on clustered indices | Bruce Momjian | 03:00 |
| Re: Does VACUUM reorder tables on clustered indices | Tom Lane | 03:14 |
| Re: Does VACUUM reorder tables on clustered indices | Bruce Momjian | 03:25 |
| Thread | Author | Time |
|---|---|---|
| plpgsql triggers in rules | chester c young | 18:19 |
| session variables in 8.0 | chester c young | 18:21 |
| exceptions in rules | chester c young | 18:22 |
| Thread | Author | Time |
|---|---|---|
| avg() with floating-point types | George Pavlov | 00:40 |
| Re: avg() with floating-point types | Tom Lane | 01:25 |
| Re: avg() with floating-point types | Michael Fuhr | 01:27 |
| PostgreSQL and uuid/guid | Mario Splivalo | 13:26 |
| delete from a using b in postgres 8.1. | Peter Childs | 13:28 |
| Thread | Author | Time |
|---|---|---|
| Re: delete from a using b in postgres 8.1. | Jaime Casanova | 19:18 |
| getting a query column to return 0 if nothing matches | Dan Tenenbaum | 22:15 |
| Thread | Author | Time |
|---|---|---|
| Loading lots of data in a SQL command | frank church | 01:32 |
| Re: getting a query column to return 0 if nothing matches | Michael Fuhr | 02:42 |
| Re: Loading lots of data in a SQL command | Richard Huxton | 09:21 |
| Regular Expression Matching problem... | Mario Splivalo | 14:08 |
| Re: Regular Expression Matching problem... | A. Kretschmer | 14:50 |
| Re: Regular Expression Matching problem... | Michael Fuhr | 17:00 |
| JOIN question with multiple records | Scott, Casey | 19:54 |
| Thread | Author | Time |
|---|---|---|
| FOREIGN KEYs ... I think ... | Marc G. Fournier | 01:49 |
| Re: FOREIGN KEYs ... I think ... | Tom Lane | 01:54 |
| Re: FOREIGN KEYs ... I think ... | Marc G. Fournier | 03:12 |