Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| array variables | Marcin Krawczyk | 09:08 |
| Re: array variables | Marcin Krawczyk | 09:13 |
| Re: array variables | Pavel Stehule | 09:30 |
| Re: array variables | Achilleas Mantzios | 09:39 |
| Re: array variables | Marcin Krawczyk | 09:44 |
| Re: array variables | Tom Lane | 13:14 |
| Re: array variables | Pavel Stehule | 13:16 |
| Re: array variables | Tom Lane | 13:42 |
| Re: array variables | Pavel Stehule | 13:47 |
| Re: array variables | Tom Lane | 13:52 |
| Re: array variables | Pavel Stehule | 13:59 |
| Thread | Author | Time |
|---|---|---|
| uuid on windows | Sabin Coanda | 07:38 |
| Re: uuid on windows | Richard Huxton | 08:46 |
| Re: uuid on windows | Sabin Coanda | 10:26 |
| trapping a NULL querystring error | Gerardo Herzig | 10:29 |
| Re: uuid on windows | Richard Huxton | 10:39 |
| Re: trapping a NULL querystring error | A. Kretschmer | 10:55 |
| Re: uuid on windows | Sabin Coanda | 13:17 |
| Enc: Help to replace caracter | paulo matadr | 16:17 |
| raise doesn't add end of line | Sabin Coanda | 16:27 |
| Re: Enc: Help to replace caracter | Raymond O'Donnell | 16:39 |
| Re: Enc: Help to replace caracter | Marco Antonio | 16:55 |
| Query to match location transitions | sub3 | 19:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Enc: Help to replace caracter | Raj Mathur | 04:06 |
| Re: Query to match location transitions | Tomasz Myrta | 12:59 |
| Thread | Author | Time |
|---|---|---|
| Re: raise doesn't add end of line | Sabin Coanda | 08:40 |
| Re: raise doesn't add end of line | Pavel Stehule | 14:31 |
| Re: raise doesn't add end of line | Sabin Coanda | 15:01 |
| Thread | Author | Time |
|---|---|---|
| custom serial number | mahmoud ewiwi | 09:09 |
| Re: custom serial number | A. Kretschmer | 09:26 |
| Re: custom serial number | Pavel Stehule | 09:37 |
| Re: custom serial number | A. Kretschmer | 09:42 |
| Re: custom serial number | Pavel Stehule | 09:45 |
| Re: custom serial number | Gerardo Herzig | 18:17 |
| Left Join Question | Ryan Wells | 22:48 |
| Re: Left Join Question | ries van Twisk | 23:18 |
| Re: Left Join Question | Mark Roberts | 23:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Left Join Question | Richard Huxton | 07:45 |
| Re: custom serial number | A. Kretschmer | 07:45 |
| Re: custom serial number | mahmoud ewiwi | 08:52 |
| Query to retrieve all indexed columns | Bart van Houdt | 12:11 |
| Re: custom serial number | A. Kretschmer | 13:37 |
| VACUUM cannot be executed from multi-command string | Sabin Coanda | 15:26 |
| Re: Left Join Question | Ryan Wells | 15:30 |
| Re: VACUUM cannot be executed from multi-command string | Richard Huxton | 18:05 |
| Re: Query to retrieve all indexed columns | Tom Lane | 18:24 |
| Thread | Author | Time |
|---|---|---|
| date range query help | novice | 02:10 |
| Re: date range query help | Adam Rich | 02:42 |
| Re: date range query help | novice | 03:03 |
| Re: date range query help | brian | 03:28 |
| Re: date range query help | novice | 03:43 |
| Re: [SQL] date range query help | Rodrigo E. De León Plicet | 04:17 |
| Re: [SQL] [GENERAL] date range query help | Frank Bax | 04:19 |
| Re: [SQL] date range query help | novice | 04:32 |
| Re: [SQL] date range query help | brian | 04:33 |
| Re: [SQL] date range query help | novice | 04:41 |
| Re: [SQL] date range query help | Adam Rich | 04:42 |
| Re: [SQL] date range query help | Joshua D. Drake | 05:04 |
| Re: date range query help | Raymond C. Rodgers | 05:42 |
| UPDATE and DELEte with a lot of register is to slow... | John Dizaro | 10:20 |
| Re: UPDATE and DELEte with a lot of register is to slow... | Craig Ringer | 11:29 |
| Re: date range query help | Sam Mason | 11:49 |
| Re: [SQL] date range query help | Frank Bax | 13:22 |
| Re: date range query help | Tom Lane | 16:20 |
| Res: UPDATE and DELEte with a lot of register is to slow... | paulo matadr | 19:04 |
| Thread | Author | Time |
|---|---|---|
| Re: UPDATE and DELEte with a lot of register is to slow... | John Dizaro | 12:34 |
| BULK COLLECT | Paul Dam | 13:20 |
| function - string ends with | Kevin Duffy | 16:30 |
| Re: BULK COLLECT | Scott Marlowe | 16:46 |
| Re: function - string ends with | Kevin Duffy | 16:47 |
| Re: function - string ends with | Oliveiros Cristina | 16:53 |
| simple text parsing function | Kevin Duffy | 20:35 |
| Thread | Author | Time |
|---|---|---|
| Interval Format | Zagato | 01:34 |
| JOIN results of refcursor functions | Milan Oparnica | 01:37 |
| Re: Interval Format | Tom Lane | 02:15 |
| Re: JOIN results of refcursor functions | Tom Lane | 02:16 |
| Re: Interval Format | Zagato | 02:31 |
| Re: simple text parsing function | John DeSoi | 15:48 |
| Thread | Author | Time |
|---|---|---|
| Permission denied for create table | Pascal Tufenkji | 06:50 |
| Re: Permission denied for create table | Marcin Stępnicki | 07:17 |
| Re: BULK COLLECT | Paul Dam | 08:32 |
| Re: Permission denied for create table | Richard Huxton | 09:24 |
| Re: Permission denied for create table | Tom Lane | 13:17 |
| Sequence and nextval problem | Tk421 | 19:12 |
| Re: Sequence and nextval problem | Scott Marlowe | 19:20 |
| Re: Sequence and nextval problem | ries van Twisk | 21:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Sequence and nextval problem 📎 | Craig Ringer | 04:35 |
| Re: Sequence and nextval problem | Craig Ringer | 04:44 |
| Full text search ordering question | John Lister | 15:28 |
| Re: Sequence and nextval problem | Steve Midgley | 16:07 |
| Re: Full text search ordering question | Oleg Bartunov | 16:43 |
| Re: Full text search ordering question | John Lister | 16:54 |
| EXECUTE query INTO problem | Tk421 | 20:58 |
| Re: EXECUTE query INTO problem | Andreas Kretschmer | 21:16 |
| Re: EXECUTE query INTO problem | Pawel Socha | 22:07 |
| Thread | Author | Time |
|---|---|---|
| Re: JOIN results of refcursor functions | Milan Oparnica | 20:27 |
| Re: JOIN results of refcursor functions | Alvaro Herrera | 20:45 |
| Thread | Author | Time |
|---|---|---|
| Re: UPDATE and DELEte with a lot of register is to slow... | John Dizaro | 10:37 |
| wired behaviour | Lutz Steinborn | 13:51 |
| Re: wired behaviour | Paul Dam | 14:10 |
| Re: wired behaviour | ries van Twisk | 14:11 |
| Re: wired behaviour | Lutz Steinborn | 14:22 |
| Re: wired behaviour | Ragnar Hafstað | 14:54 |
| Re: wired behaviour | Shane Ambler | 15:09 |
| Re: wired behaviour | Lennin Caro | 15:22 |
| Re: Converting between UUID and VARCHAR | Helio Campos Mello de Andrade | 22:27 |
| Thread | Author | Time |
|---|---|---|
| Re: JOIN results of refcursor functions | Milan Oparnica | 23:13 |
| Thread | Author | Time |
|---|---|---|
| Re: JOIN results of refcursor functions | Alvaro Herrera | 02:08 |
| how to update 400 000 register not at the same time? | John Dizaro | 16:25 |
| Re: wired behaviour | Steve Crawford | 17:18 |
| Reg: Nested query | Vignesh Raaj | 18:39 |
| Re: [HACKERS] Reg: Nested query | Alvaro Herrera | 19:38 |
| Re: [pgsql-www] Reg: Nested query | Raymond O'Donnell | 22:33 |
| Re: JOIN results of refcursor functions | Milan Oparnica | 23:52 |
| Thread | Author | Time |
|---|---|---|
| DIVISION with Group By | hdhgdh mjhff | 02:57 |
| Re: JOIN results of refcursor functions | Pavel Stehule | 05:58 |
| Re: how to update 400 000 register not at the same time? | Shane Ambler | 16:30 |
| Re: JOIN results of refcursor functions | Milan Oparnica | 23:10 |
| Thread | Author | Time |
|---|---|---|
| constraint question (I think) | Gary Stainburn | 10:01 |
| array index access outside range | Achilleas Mantzios | 15:02 |
| Re: Trigger/Function - one solution - was constraint question (I think) | Gary Stainburn | 17:59 |
| Aggregates with NaN values | Sean Davis | 18:01 |
| Re: Trigger/Function - one solution - was constraint question (I think) | Rafael Domiciano | 19:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Aggregates with NaN values | Mark Roberts | 18:51 |
| Best way to "and" from a one-to-many joined table? 📎 | Bryce Nesbitt | 18:55 |
| Re: Aggregates with NaN values | Sean Davis | 19:08 |
| Re: Best way to "and" from a one-to-many joined table? | Oliveiros Cristina | 19:23 |
| Re: Best way to "and" from a one-to-many joined table? | Milan Oparnica | 20:16 |
| Re: Best way to "and" from a one-to-many joined table? 📎 | Bryce Nesbitt | 20:52 |
| Re: Best way to "and" from a one-to-many joined table? | Oliveiros Cristina | 22:38 |
| Thread | Author | Time |
|---|---|---|
| adding "order by" to a "group by" query | Louis-David Mitterrand | 17:10 |
| Re: adding "order by" to a "group by" query | Andreas Kretschmer | 17:26 |
| Re: adding "order by" to a "group by" query | Louis-David Mitterrand | 17:31 |
| Re: adding "order by" to a "group by" query | Scott Marlowe | 17:40 |
| Re: adding "order by" to a "group by" query | Andreas Kretschmer | 18:23 |
| Re: adding "order by" to a "group by" query | John Lister | 18:24 |
| Re: adding "order by" to a "group by" query | Louis-David Mitterrand | 18:36 |
| Public synonyms | Azzeddine Daddah | 22:22 |
| Re: Public synonyms | Bruce Momjian | 22:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Best way to "and" from a one-to-many joined table? | Steve Midgley | 02:27 |
| Re: Best way to "and" from a one-to-many joined table? | John Lister | 08:51 |
| Best way to restrict detail rows? | Christopher Maier | 20:56 |
| Re: Best way to restrict detail rows? | Scott Marlowe | 21:28 |
| Re: Best way to restrict detail rows? | Scott Marlowe | 21:29 |
| Re: Best way to restrict detail rows? | Richard Broersma | 21:31 |
| Re: Best way to restrict detail rows? | Scott Marlowe | 21:34 |
| Thread | Author | Time |
|---|---|---|
| A DISTINCT problem removing duplicates 📎 | Richard Huxton | 09:46 |
| store pdf files | ivan marchesini | 10:11 |
| Re: DIVISION with Group By | Richard Huxton | 11:08 |
| Re: A DISTINCT problem removing duplicates | Tom Lane | 13:50 |
| Re: A DISTINCT problem removing duplicates | Richard Huxton | 15:04 |
| Re: A DISTINCT problem removing duplicates | Tom Lane | 15:39 |
| Re: A DISTINCT problem removing duplicates | Richard Huxton | 16:12 |
| inconsistent automatic casting between psql and function | Stefano Buliani | 17:28 |
| Re: store pdf files | Frank Bax | 17:57 |
| Re: inconsistent automatic casting between psql and function | Richard Huxton | 18:02 |
| Re: store pdf files | Thomas Kellerer | 18:05 |
| Re: store pdf files | Andreas Joseph Krogh | 18:18 |
| Re: inconsistent automatic casting between psql and function | Richard Huxton | 18:33 |
| Re: inconsistent automatic casting between psql and function | Tom Lane | 18:37 |
| Thread | Author | Time |
|---|---|---|
| unique constraint on views | Jyoti Seth | 12:05 |
| Re: unique constraint on views | A. Kretschmer | 12:33 |
| Collapsing (select) row values into single text field. | Allan Kamau | 12:46 |
| Re: inconsistent automatic casting between psql and function | Bruce Momjian | 13:33 |
| Is there a bug in PostgreSQL ? | Pascal Tufenkji | 14:33 |
| Re: Collapsing (select) row values into single text field. | Filip Rembiałkowski | 14:45 |
| Re: Is there a bug in PostgreSQL ? | Tom Lane | 17:43 |
| Re: Is there a bug in PostgreSQL ? | Richard Huxton | 17:45 |
| Re: Best way to "and" from a one-to-many joined table? | Bryce Nesbitt | 18:54 |
| Re: Best way to "and" from a one-to-many joined table? | Oliveiros Cristina | 19:21 |
| Is it possible to only allow deletes from a table via referential integrity cascades? | Christopher Maier | 19:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Collapsing (select) row values into single text field. | Allan Kamau | 03:52 |
| Re: unique constraint on views | Jyoti Seth | 04:04 |
| Re: Is there a bug in PostgreSQL ? | Pascal Tufenkji | 09:33 |
| Re: Is there a bug in PostgreSQL ? | Pascal Tufenkji | 09:57 |
| Re: Is there a bug in PostgreSQL ? | Tom Lane | 14:40 |
| Thread | Author | Time |
|---|---|---|
| array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Corey Horton | 05:03 |
| Re: Is there a bug in PostgreSQL ? | Pascal Tufenkji | 07:33 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Tom Lane | 00:38 |
| Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Greg Stark | 00:52 |
| Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Tom Lane | 01:10 |
| Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Tom Lane | 18:16 |
| optimizing a query | Louis-David Mitterrand | 19:22 |
| Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Corey Horton | 19:26 |
| Re: Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Tom Lane | 19:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 | Corey Horton | 00:39 |
| Re: optimizing a query | Louis-David Mitterrand | 06:51 |
| "Subquery must return only one column" & query optimization | Philippe Lang | 12:12 |
| Re: "Subquery must return only one column" & query optimization | Tom Lane | 13:17 |
| Re: "Subquery must return only one column" & query optimization | Philippe Lang | 14:21 |
| create table with rownames as values in column of seciond table 📎 | Marco Lechner | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: create table with rownames as values in column of seciond table | George Pavlov | 00:06 |
| How can this be legal syntax | Asko Oja | 17:00 |
| Re: How can this be legal syntax | Alvaro Herrera | 17:05 |
| Re: How can this be legal syntax | Tom Lane | 17:16 |
| pg_clog/0202 Error | Judith Altamirano | 17:54 |
| Way to eliminate pg_dump activity from pg_stat_all ? 📎 | Bryce Nesbitt | 20:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Way to eliminate pg_dump activity from pg_stat_all ? | Erik Jones | 00:33 |
| Re: pg_clog/0202 Error | Tom Lane | 00:38 |
| archiving or versioning data? | Louis-David Mitterrand | 06:51 |