Discussion for users on SQL related matters.
| Thread | Author | Time | 
|---|---|---|
| Re: Difference between Access97 and PostgreSQL | Christopher Kings-Lynne | 00:29 | 
| Re: Difference between Access97 and PostgreSQL | Henshall, Stuart - WCP | 10:15 | 
| Compare with CHAR | Tomas Eriksson | 12:59 | 
| Re: test the existence of a database | Steve Brett | 13:29 | 
| Re: Index Management | Steve Brett | 13:32 | 
| pg_vlock / vacuum 📎 | David M. Richter | 14:36 | 
| syntax for using function parameter in to_char | Kevin Barrett | 17:57 | 
| Re: Compare with CHAR | Josh Berkus | 19:41 | 
| NOTICE: Vacuum: can not process indices, views and certain system tables | Diehl, Jeffrey | 20:25 | 
| Re: Again about foreign keys and inheritance | Stephan Szabo | 20:36 | 
| Re: What's wrong with this function - "returns setof" | Tom Lane | 20:36 | 
| Re: pg_vlock / vacuum | Tom Lane | 20:39 | 
| Re: syntax for using function parameter in to_char | Josh Berkus | 20:40 | 
| Re: NOTICE: Vacuum: can not process indices, views and certain system tables | Tom Lane | 21:19 | 
| Array slice subscripts (was Re: [SQL] plpgsql function with more than one array argument) | Tom Lane | 21:56 | 
| Thread | Author | Time | 
|---|---|---|
| Fractional Results | Paulo J. Matos | 01:26 | 
| Re: Fractional Results | Tom Lane | 04:39 | 
| casting question | A. Van Hook | 15:20 | 
| Re: test the existence of a database | Steve Boyle (Roselink) | 16:38 | 
| Re: casting question | Stephan Szabo | 18:58 | 
| Thread | Author | Time | 
|---|---|---|
| Database ownership | Rudi | 03:28 | 
| Re: Timestamp output | Barry Lind | 10:59 | 
| RULES - Difference between DO and DO INSTEAD | Luis Sousa | 11:26 | 
| Execute some of the elements of the RULE without a plan to the VIEW | Luis Sousa | 12:18 | 
| =?ISO-8859-1?Q?Privil=E9gios_s?=obre colunas | Sandro Joel Eller | 13:02 | 
| Re: Privil?gios sobre colunas | Roberto Mello | 15:03 | 
| WAL filling up disk | Roberto Mello | 16:54 | 
| indexes | Isabelle Brette | 17:05 | 
| Re: WAL filling up disk | Chris Ruprecht | 17:23 | 
| Re: WAL filling up disk | Tom Lane | 17:28 | 
| Re: indexes | Chris Ruprecht | 17:50 | 
| Re: WAL filling up disk | Chris Ruprecht | 18:00 | 
| Re: WAL filling up disk | Tom Lane | 18:18 | 
| Re: RULES - Difference between DO and DO INSTEAD | Josh Berkus | 18:20 | 
| Re: WAL filling up disk | Josh Berkus | 20:53 | 
| Re: WAL filling up disk | Tom Lane | 21:49 | 
| practical limitations to number of postgres user accounts | Murray Prior Hobbs | 22:37 | 
| Re: Database ownership | Rudi | 22:49 | 
| Thread | Author | Time | 
|---|---|---|
| Re: indexes | Isabelle Brette | 09:50 | 
| Re: indexes | Stephan Szabo | 15:29 | 
| Query with Parameters | Evil Azrael | 16:53 | 
| Re: WAL filling up disk | Vivek Khera | 17:28 | 
| Re: Query with Parameters | Ian Barwick | 17:57 | 
| Re: Query with Parameters | Jeff Eckermann | 19:24 | 
| JOIN between three *simple* tables ... | Marc G. Fournier | 20:47 | 
| Re: JOIN between three *simple* tables ... | Tom Lane | 21:14 | 
| Re: JOIN between three *simple* tables ... | Marc G. Fournier | 21:41 | 
| Thread | Author | Time | 
|---|---|---|
| type aliases in 7.0.3 | Christopher Kings-Lynne | 00:46 | 
| pg_shadow / pg_user | Rudi | 01:51 | 
| Re: pg_shadow / pg_user | Christopher Kings-Lynne | 02:05 | 
| Re: pg_shadow / pg_user | Rudi | 02:15 | 
| Re: pg_shadow / pg_user | Bruce Momjian | 02:31 | 
| Nested Transactions | John Hasler | 13:13 | 
| Re: Nested Transactions | Bruce Momjian | 17:00 | 
| How do you return more than one variable in a plpgsql function? | Mark Nielsen | 20:43 | 
| Looking for the correct solution for a generic problem. | Frank Joerdens | 20:52 | 
| Re: Looking for the correct solution for a generic problem. | Mark Nielsen | 20:53 | 
| Re: Help with a SQL query | Mark Nielsen | 21:02 | 
| Re: Looking for the correct solution for a generic problem. | Stephan Szabo | 21:31 | 
| Re: Looking for the correct solution for a generic problem. | Tom Lane | 21:50 | 
| Re: Looking for the correct solution for a generic problem. | Frank Joerdens | 22:04 | 
| ALTER TABLE and dropping a column | Frank Joerdens | 22:25 | 
| Re: ALTER TABLE and dropping a column | Josh Berkus | 23:22 | 
| Thread | Author | Time | 
|---|---|---|
| Re: How do you return more than one variable in a plpgsql function? | Vincent AE Scott | 02:13 | 
| Re: Help with a SQL query | Bill Cunningham | 03:47 | 
| Multiprocessor support for 7.2 📎 | David M. Richter | 09:05 | 
| Re: Multiprocessor support for 7.2 | Bruce Momjian | 14:02 | 
| Thread | Author | Time | 
|---|---|---|
| Adding a New Composite Constraint to an Existing Table. | Bhuvan A | 10:28 | 
| Re: Adding a New Composite Constraint to an Existing Table. | MindTerm | 12:57 | 
| Re: Adding a New Composite Constraint to an Existing Table. | Stephan Szabo | 17:43 | 
| Thread | Author | Time | 
|---|---|---|
| SQL Help - multi values | James Carrier | 06:34 | 
| Re: SQL Help - multi values | Oleg Bartunov | 08:49 | 
| Re: SQL Help - multi values | Bruno Wolff III | 16:04 | 
| Re: SQL Help - multi values | Greg Sabino Mullane | 17:53 | 
| Re: SQL Help - multi values | Andrew G. Hammond | 20:33 | 
| Re: SQL Help - multi values | David Stanaway | 22:43 | 
| Thread | Author | Time | 
|---|---|---|
| remove | Srikanth Rao | 16:28 | 
| Time Intervals | Michael Richards | 16:53 | 
| How long does it take? | Torbj=?ISO-8859-1?B?9g==?=rn Andersson | 19:14 | 
| Re: Time Intervals | Jason Earl | 19:23 | 
| Re: How long does it take? | clayton cottingham | 19:36 | 
| Re: Time Intervals | Michael Richards | 19:37 | 
| Re: How long does it take? | Tom Lane | 21:43 | 
| Re: Time Intervals | Tom Lane | 21:50 | 
| Thread | Author | Time | 
|---|---|---|
| No Interval Conversion Function in 7.2?!!? | Josh Berkus | 00:20 | 
| Re: No Interval Conversion Function in 7.2?!!? | Tom Lane | 00:33 | 
| Re: No Interval Conversion Function in 7.2?!!? | Tom Lane | 00:55 | 
| Re: SELECT... FOR UPDATE | David Griffiths | 01:49 | 
| Re: | Christopher Kings-Lynne | 04:36 | 
| Re: UNION and rows improperly unified: query optimization question | Marshall Spight | 07:25 | 
| Psql & Readline | Josh Berkus | 16:38 | 
| Re: Psql & Readline | Tom Lane | 17:40 | 
| More problems with 7.2 & functions | Josh Berkus | 18:10 | 
| Re: Join Statements | Mark Nielsen | 18:30 | 
| Re: More problems with 7.2 & functions | Tom Lane | 18:37 | 
| Re: More problems with 7.2 & functions | Josh Berkus | 18:52 |