Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| count(distinct) | Zdravko Balorda | 14:03 |
| Re: count(distinct) | Richard Huxton | 14:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Implementing "access lists" (was: Must I use DISTINCT?) | Michael B Allen | 01:32 |
| Thread | Author | Time |
|---|---|---|
| Grass Root Protectionism | Boycott Tech Forums | 06:40 |
| Re: Grass Root Protectionism | Scott Marlowe | 06:50 |
| Re: Grass Root Protectionism | Scott Marlowe | 06:50 |
| Re: Grass Root Protectionism | Bruce Momjian | 13:49 |
| Re: Grass Root Protectionism | D'Arcy J.M. Cain | 14:06 |
| Re: Grass Root Protectionism | Tom Lane | 15:39 |
| Re: Grass Root Protectionism | D'Arcy J.M. Cain | 15:50 |
| Re: Grass Root Protectionism | Michael B Allen | 16:11 |
| Re: Grass Root Protectionism | John Hasler | 17:20 |
| Re: Grass Root Protectionism | John Hasler | 18:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Grass Root Protectionism | Oliveiros Cristina | 11:24 |
| RE: [SQL] Grass Root Protectionism | Bart van Houdt | 12:02 |
| Thread | Author | Time |
|---|---|---|
| Partitoning not working with RETURNING and INSERT/UPDATE | Frank Jördens | 03:55 |
| Thread | Author | Time |
|---|---|---|
| Funtion to clean up strings? | Andreas | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Funtion to clean up strings? | Dickson S. Guedes | 00:00 |
| Re: Funtion to clean up strings? | Andreas | 00:15 |
| Re: Funtion to clean up strings? | Raj Mathur | 04:27 |
| Re: Grass Root Protectionism | Tovo Rabemanantsoa | 13:18 |
| Thread | Author | Time |
|---|---|---|
| = or LIKE ? | Jesper Krogh | 17:57 |
| Re: = or LIKE ? | Tom Lane | 18:42 |
| Re: = or LIKE ? | Jesper Krogh | 19:20 |
| Re: = or LIKE ? | Jesper Krogh | 19:27 |
| Re: = or LIKE ? | Tom Lane | 19:34 |
| Thread | Author | Time |
|---|---|---|
| Re: = or LIKE ? | Craig Ringer | 04:40 |
| temp tables versus normal tables | John Lister | 11:00 |
| New datestyle(s) | Peter Koczan | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Is this possible? | johnf | 02:36 |
| Re: Is this possible? | A. Kretschmer | 06:32 |
| Re: Is this possible? | Scott Marlowe | 08:10 |
| Stored Procedure Generator? | Steve Nyemba | 12:30 |
| Re: Is this possible? | johnf | 14:20 |
| Re: Is this possible? | A. Kretschmer | 14:45 |
| How to find number of seconds between 2 timestamps | Woody Woodring | 15:08 |
| Re: How to find number of seconds between 2 timestamps | Richard Huxton | 15:30 |
| Re: Funtion to clean up strings? | Andreas | 15:32 |
| Re: Funtion to clean up strings? | Raj Mathur | 15:51 |
| Re: Funtion to clean up strings? | Andreas | 16:30 |
| Thread | Author | Time |
|---|---|---|
| How concat 3 strings if 2 are not empty? | Andreas | 11:50 |
| Re: How concat 3 strings if 2 are not empty? | A. Kretschmer | 12:08 |
| Re: How concat 3 strings if 2 are not empty? | Andreas | 12:32 |
| Re: Funtion to clean up strings? | Gregory Stark | 13:05 |
| Thread | Author | Time |
|---|---|---|
| Creating a function with single quotes | Shawn Tayler | 15:41 |
| Re: Creating a function with single quotes | Agustin Bialet | 16:00 |
| Fwd: Re: Creating a function with single quotes | Adrian Klaver | 16:03 |
| Re: Creating a function with single quotes | Craig Ringer | 16:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Creating a function with single quotes | Jasen Betts | 08:11 |
| Re: Creating a function with single quotes | Shawn Tayler | 14:03 |
| Re: Creating a function with single quotes | Leif B. Kristensen | 14:13 |
| Re: Creating a function with single quotes | Shawn Tayler | 14:22 |
| Fwd: Re: Creating a function with single quotes | Adrian Klaver | 14:27 |
| Re: Creating a function with single quotes | Leif B. Kristensen | 14:29 |
| Re: Fwd: Re: Creating a function with single quotes | Shawn Tayler | 14:30 |
| Re: Creating a function with single quotes | Adrian Klaver | 14:37 |
| Re: Creating a function with single quotes | Leif B. Kristensen | 15:02 |
| Re: How concat 3 strings if 2 are not empty? | M.P.Dankoor | 15:41 |
| JOIN and aggregate problem | Tarlika Elisabeth Schmitz | 18:04 |
| Re: JOIN and aggregate problem | Bob Henkel | 19:03 |
| Re: JOIN and aggregate problem | Richard Huxton | 19:06 |
| Re: JOIN and aggregate problem | Bob Henkel | 19:14 |
| Re: JOIN and aggregate problem | Stephan Szabo | 19:15 |
| Re: JOIN and aggregate problem | Bob Henkel | 19:23 |
| Thread | Author | Time |
|---|---|---|
| Re: JOIN and aggregate problem | Tarlika Elisabeth Schmitz | 16:00 |
| Thread | Author | Time |
|---|---|---|
| Re: JOIN and aggregate problem | Tarlika Elisabeth Schmitz | 14:17 |
| Re: JOIN and aggregate problem | Tarlika Elisabeth Schmitz | 15:00 |
| Re: JOIN and aggregate problem | Richard Huxton | 15:44 |
| Re: JOIN and aggregate problem | Tarlika Elisabeth Schmitz | 15:48 |
| Thread | Author | Time |
|---|---|---|
| alter column from varchar(32) to varchar(255) without view re-creation | Emi Lu | 15:27 |
| Re: alter column from varchar(32) to varchar(255) without view re-creation | Marcin Stępnicki | 16:09 |
| Best practices for geo-spatial city name searches? | Mark Stosberg | 16:19 |
| Re: Best practices for geo-spatial city name searches? | johnf | 19:42 |
| Re: Best practices for geo-spatial city name searches? | Fernando Hevia | 19:59 |
| Thread | Author | Time |
|---|---|---|
| Add column by using SELECT statement | John Zhang | 03:37 |
| Re: Add column by using SELECT statement | A. Kretschmer | 06:33 |
| Re: Best practices for geo-spatial city name searches? | Steve Midgley | 18:42 |
| Thread | Author | Time |
|---|---|---|
| row not deleted but updated (trigger?) | Ivan Sergio Borgonovo | 11:56 |
| Re: row not deleted but updated (trigger?) | Ivan Sergio Borgonovo | 12:21 |
| Re: row not deleted but updated (trigger?) | Igor Neyman | 15:06 |
| counts of groupings by date year-month | Carol Cheung | 21:02 |
| Re: counts of groupings by date year-month | Scott Marlowe | 21:47 |
| Re: counts of groupings by date year-month | Tom Lane | 21:50 |
| Re: counts of groupings by date year-month | Andreas Kretschmer | 21:52 |
| Thread | Author | Time |
|---|---|---|
| "union" vs. left join | Emi Lu | 20:26 |
| Re: "union" vs. left join | ries van Twisk | 20:33 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Jhonny Velasquez c. | 15:48 |
| uso de dblink en php | Jhonny Velasquez c. | 15:50 |
| Writing a generic delete rule for a view | Scott Cain | 18:20 |
| Re: uso de dblink en php | Oliveiros Cristina | 18:25 |
| Re: | Ivan Sergio Borgonovo | 19:02 |
| Re: uso de dblink en php | Andy Anderson | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Re: | Andreas Wenk | 17:42 |
| Thread | Author | Time |
|---|---|---|
| Inherits is not encouraged? | Emi Lu | 20:18 |
| Re: Inherits is not encouraged? | Tom Lane | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Inherits is not encouraged? | Karsten Hilbert | 08:23 |
| Thread | Author | Time |
|---|---|---|
| Problem with an Empty Column | hidura | 05:41 |
| Re: Problem with an Empty Column | Scott Marlowe | 06:17 |
| Convert text from UTF8 to ASCII | Paul Dam | 15:04 |
| Re: Convert text from UTF8 to ASCII | Claus Guttesen | 15:43 |
| Re: Convert text from UTF8 to ASCII | Leif B. Kristensen | 15:46 |
| Re: Convert text from UTF8 to ASCII | Paul Dam | 15:51 |
| Re: | F. Jovan Jester | 18:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field | Allan Kamau | 12:53 |
| Permanent alias for postgresql table | Marco Lechner | 12:59 |
| Re: Permanent alias for postgresql table | Thomas Kellerer | 13:55 |
| Re: Permanent alias for postgresql table | Marco Lechner | 14:26 |
| Re: Permanent alias for postgresql table | Joshua Tolley | 14:30 |
| Re: Permanent alias for postgresql table | Thomas Kellerer | 14:39 |
| select count of all overlapping geometries and return 0 if none. | Duffer Do | 17:28 |
| Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field | Allan Kamau | 18:10 |
| Re: Permanent alias for postgresql table | Lennin Caro | 18:54 |
| Thread | Author | Time |
|---|---|---|
| subquery question | Sebastian Böhm | 03:06 |
| Re: subquery question | Bob Henkel | 04:31 |
| Re: Convert text from UTF8 to ASCII | Paul Dam | 08:38 |
| xpath_table feature | Marcin Stępnicki | 11:34 |
| RE : [SQL] Convert text from UTF8 to ASCII | seb JACK | 12:49 |
| Re: select count of all overlapping geometries and return 0 if none. | Steve Midgley | 17:32 |
| Re: Permanent alias for postgresql table | Mina R Waheeb | 18:38 |
| Re: select count of all overlapping geometries and return 0 if none. | Peter Eisentraut | 19:43 |
| Thread | Author | Time |
|---|---|---|
| Oracle to PostgreSQL | Greenhorn | 23:35 |
| Re: Oracle to PostgreSQL | John R Pierce | 23:41 |
| Re: Oracle to PostgreSQL | Thomas Kellerer | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Oracle to PostgreSQL | John R Pierce | 00:06 |
| Re: [SQL] Oracle to PostgreSQL | Marcin Stępnicki | 14:30 |
| RE: [SQL] RE : [SQL] Convert text from UTF8 to ASCII | Paul Dam | 14:44 |
| Exclude fields from SELECT command | Charles Tam | 20:56 |
| Re: Exclude fields from SELECT command | Pavel Stehule | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Exclude fields from SELECT command | Ashish Karalkar | 05:17 |
| Re: Exclude fields from SELECT command | Pavel Stehule | 05:27 |
| Methods declaration | Gianvito Pio | 06:39 |
| diff b/w varchar(N) & text | sathiya psql | 11:02 |
| Re: Exclude fields from SELECT command | sathiya psql | 11:04 |
| Re: diff b/w varchar(N) & text | Frank Bax | 13:12 |
| SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps | Srikanth | 14:50 |
| Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps | Richard Huxton | 15:06 |
| Re: Methods declaration | Tom Lane | 16:56 |
| Re: Exclude fields from SELECT command | Steve Midgley | 18:49 |
| join | Ivan Sergio Borgonovo | 21:40 |
| How do I optimize this? | Wei Weng | 21:43 |
| Re: How do I optimize this? | Wei Weng | 22:37 |
| Thread | Author | Time |
|---|---|---|
| 2 left join taking in too many records, 1 join and 1 left join too few was: join | Ivan Sergio Borgonovo | 08:16 |
| Re: How do I optimize this? | Richard Huxton | 08:35 |
| Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps | Srikanth | 16:02 |
| Thread | Author | Time |
|---|---|---|
| alter table on a large db | Zdravko Balorda | 07:57 |
| Re: alter table on a large db | Achilleas Mantzios | 08:30 |
| Re: alter table on a large db | Scott Marlowe | 11:17 |
| Re: alter column from varchar(32) to varchar(255) without view re-creation | Emi Lu | 14:54 |
| Relatorio da composiçao de FKs e PKs | paulo matadr | 17:42 |
| Re: [SQL] Relatorio da composiçao de FKs e PKs | Oliveiros Cristina | 17:47 |
| Re: Re: [SQL] Relatorio da composiçao de FKs e PKs | Alvaro Herrera | 18:11 |
| Thread | Author | Time |
|---|---|---|
| simple SQL question | Kevin Duffy | 19:06 |
| Postgresql Rules | Staten Oliver | 19:54 |
| Re: simple SQL question | Kevin Duffy | 21:20 |
| pg_restore error - Any Idea? | DM | 22:40 |
| Thread | Author | Time |
|---|---|---|
| bash & postgres | Greenhorn | 04:03 |
| Re: bash & postgres | Harvey, Allan AC | 04:18 |
| pg_restore error - Any Idea? | DM | 05:44 |
| Re: pg_restore error - Any Idea? | Erik Jones | 06:17 |
| Re: [SQL] bash & postgres | Erik Jones | 06:31 |
| cast bool/int | Zdravko Balorda | 07:59 |
| Re: bash & postgres | Ivan Sergio Borgonovo | 08:09 |
| Re: cast bool/int | Achilleas Mantzios | 08:15 |
| Re: cast bool/int | Achilleas Mantzios | 08:18 |
| Re: [SQL] bash & postgres | Tom Lane | 14:05 |
| Re: cast bool/int | Joshua Tolley | 14:33 |
| Re: cast bool/int | Marcin Krawczyk | 14:44 |
| Re: cast bool/int | Zdravko Balorda | 14:45 |
| Re: pg_restore error - Any Idea? | DM | 15:04 |
| Re: [SQL] bash & postgres | Erik Jones | 19:04 |
| Re: [SQL] bash & postgres | Tom Lane | 19:55 |
| Thread | Author | Time |
|---|---|---|
| Alter Table/Indexing | Zdravko Balorda | 08:55 |
| Re: alter table on a large db | Jasen Betts | 09:15 |
| Re: cast bool/int | Jasen Betts | 09:28 |
| Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps | Jasen Betts | 09:39 |
| Re: Alter Table/Indexing | Tom Lane | 14:35 |
| Proper entry of polygon type data | Peter Willis | 15:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Alter Table/Indexing | Steve Midgley | 15:49 |
| Special sort querstion | Dominik Piekarski | 16:51 |
| Can we load all database objects in memory? | DM | 19:20 |
| Re: [SQL] Can we load all database objects in memory? | ries van Twisk | 19:59 |
| Re: [SQL] Can we load all database objects in memory? | ries van Twisk | 20:07 |
| Re: Can we load all database objects in memory? | Iñigo Martinez Lasala | 20:09 |
| Re: [SQL] Can we load all database objects in memory? | Iñigo Martinez Lasala | 20:11 |
| Re: [SQL] Can we load all database objects in memory? | Scott Marlowe | 20:12 |
| Thread | Author | Time |
|---|---|---|
| Table to Excel | Nicholas I | 06:35 |
| Re: Table to Excel | Pavel Stehule | 07:04 |
| Re: [ADMIN] Can we load all database objects in memory? | Albe Laurenz | 09:44 |
| Re: Table to Excel | Josh Trutwin | 14:05 |
| Re: Table to Excel | Pavel Stehule | 16:30 |
| Re: Can we load all database objects in memory? | Steve Midgley | 16:38 |
| Thread | Author | Time |
|---|---|---|
| Add: Special sort querstion | Dominik Piekarski | 12:10 |
| Re: Table to Excel | Greenhorn | 16:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Table to Excel | Jasen Betts | 11:57 |
| Thread | Author | Time |
|---|---|---|
| a bit confused about distinct() function | Tena Sakai | 17:27 |
| Re: a bit confused about distinct() function | Osvaldo Kussama | 17:44 |
| Re: a bit confused about distinct() function | Tom Lane | 17:49 |
| Re: a bit confused about distinct() function | Tena Sakai | 18:02 |
| Re: a bit confused about distinct() function | Tena Sakai | 18:03 |
| Thread | Author | Time |
|---|---|---|
| xpath_table, or something similair? | Mario Splivalo | 08:41 |