Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Object create date | Asko Oja | 12:34 |
| Question on Escape-string | John Zhang | 19:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Question on Escape-string | Steve Midgley | 17:48 |
| Thread | Author | Time |
|---|---|---|
| How to excute dynamically a generated SQL command? | John Zhang | 01:57 |
| EXECUTE with a prepared plan and NULL | sergey kapustin | 20:53 |
| Re: How to excute dynamically a generated SQL command? | Adrian Klaver | 21:04 |
| Re: EXECUTE with a prepared plan and NULL | Tom Lane | 23:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Any utility to convert MySQL to PGSQL? | Chris Browne | 17:06 |
| Re: How to excute dynamically a generated SQL command? | Steve Midgley | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Convite pessoal de Flavio Brito | Flavio Brito | 12:08 |
| Thread | Author | Time |
|---|---|---|
| some howto/theory book/tutorial on practical problem solving in SQL | Ivan Sergio Borgonovo | 16:32 |
| Re: some howto/theory book/tutorial on practical problem solving in SQL | Scott Marlowe | 18:19 |
| Seeking for the fore-part of the key | Havasvölgyi Ottó | 20:50 |
| Re: Seeking for the fore-part of the key | Andreas Kretschmer | 21:17 |
| Thread | Author | Time |
|---|---|---|
| Re: some howto/theory book/tutorial on practical problem solving in SQL | Ivan Sergio Borgonovo | 00:48 |
| Thread | Author | Time |
|---|---|---|
| Create index on xml field | Brad Balmer | 16:56 |
| Re: Create index on xml field | Peter Eisentraut | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Re: some howto/theory book/tutorial on practical problem solving in SQL | Erik Jones | 06:18 |
| Re: some howto/theory book/tutorial on practical problem solving in SQL | Ivan Sergio Borgonovo | 11:05 |
| Re: some howto/theory book/tutorial on practical problem solving in SQL | Steve Midgley | 18:51 |
| Thread | Author | Time |
|---|---|---|
| Derived columns / denormalization | Jamie Tufnell | 03:52 |
| Re: Derived columns / denormalization | Tom Lane | 04:06 |
| Re: Derived columns / denormalization | Erik Jones | 16:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Derived columns / denormalization | Jamie Tufnell | 00:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Way to eliminate pg_dump activity from pg_stat_all ? | Bryce Nesbitt | 19:27 |
| Re: Way to eliminate pg_dump activity from pg_stat_all ? | Erik Jones | 22:06 |
| Re: Way to eliminate pg_dump activity from pg_stat_all ? | Bryce Nesbitt | 22:25 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Bruce Momjian | 17:52 |
| Thread | Author | Time |
|---|---|---|
| problem using twice custom comparision operator | Marek Florianczyk | 20:42 |
| Re: problem using twice custom comparision operator | Tom Lane | 22:40 |
| Thread | Author | Time |
|---|---|---|
| Re: problem using twice custom comparision operator | Steve Midgley | 18:41 |
| Thread | Author | Time |
|---|---|---|
| Invitation to connect on LinkedIn | Suha Onay | 07:57 |
| aggregation problem: first/last/count(*) | Marc Mamin | 14:48 |
| Re: aggregation problem: first/last/count(*) | Volkan YAZICI | 15:27 |
| Re: aggregation problem: first/last/count(*) | Marc Mamin | 16:04 |
| Thread | Author | Time |
|---|---|---|
| Array iterator | Raj Mathur | 12:40 |
| Re: Array iterator | Achilleas Mantzios | 13:34 |
| Thread | Author | Time |
|---|---|---|
| plpgsql setof help | Matthew T. O'Connor | 23:37 |
| Thread | Author | Time |
|---|---|---|
| Re: plpgsql setof help | Tom Lane | 00:29 |
| Re: plpgsql setof help | Frank Bax | 00:49 |
| I need some magical advice | Andreas | 11:56 |
| Re: I need some magical advice | Oliveiros Cristina | 13:58 |
| Re: I need some magical advice | Andreas | 14:17 |
| Re: I need some magical advice | M.P.Dankoor | 14:52 |
| Re: I need some magical advice | Oliveiros Cristina | 15:04 |
| Re: I need some magical advice | Terry Fielder | 15:16 |
| Thread | Author | Time |
|---|---|---|
| regexp_replace and UTF8 | Bart Degryse | 10:26 |
| dynamic OUT parameters? | Gerardo Herzig | 11:01 |
| Re: regexp_replace and UTF8 | Gregory Stark | 11:14 |
| Re: regexp_replace and UTF8 | Harald Fuchs | 15:47 |
| Re: dynamic OUT parameters? | Craig Ringer | 17:00 |
| Re: dynamic OUT parameters? | Tom Lane | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Re: dynamic OUT parameters? | gherzig | 00:52 |
| Re: dynamic OUT parameters? | Craig Ringer | 06:18 |
| Re: regexp_replace and UTF8 | Jasen Betts | 11:47 |
| Thread | Author | Time |
|---|---|---|
| Re: dynamic OUT parameters? | gherzig | 01:13 |
| Re: dynamic OUT parameters? | Craig Ringer | 03:42 |
| Re: dynamic OUT parameters? | Ivan Sergio Borgonovo | 09:54 |
| Re: dynamic OUT parameters? | Pavel Stehule | 11:31 |
| Thread | Author | Time |
|---|---|---|
| Re: regexp_replace and UTF8 | Bart Degryse | 08:38 |
| Thread | Author | Time |
|---|---|---|
| Function Returning a Set of Composite Value | Nikhil teltia | 00:06 |
| Thread | Author | Time |
|---|---|---|
| Re: regexp_replace and UTF8 | Jasen Betts | 09:59 |
| postgre2postgre | F. | 21:57 |
| Re: postgre2postgre | Devrim GÜNDÜZ | 22:41 |
| Re: postgre2postgre | Chris | 22:42 |
| Thread | Author | Time |
|---|---|---|
| current_date vs 'now' | Jamie Tufnell | 06:05 |
| Re: current_date vs 'now' | Tom Lane | 15:34 |
| Must I use DISTINCT? | Michael B Allen | 21:57 |
| Re: current_date vs 'now' | Jamie Tufnell | 23:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Array iterator | Raj Mathur | 03:34 |
| Re: Must I use DISTINCT? | Rajesh Kumar Mallah | 03:59 |
| Re: Must I use DISTINCT? | Michael B Allen | 04:54 |
| test | Boycott TechForums | 05:01 |
| Re: Must I use DISTINCT? | Stephan Szabo | 06:11 |
| Re: Must I use DISTINCT? | Raj Mathur | 06:21 |
| Data length and data precision | Bart van Houdt | 09:41 |
| Re: Data length and data precision | A. Kretschmer | 10:04 |
| Re: Data length and data precision | Bart van Houdt | 10:13 |
| test | Boycott TechForums | 10:41 |
| 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 |