Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: problem with update data sets from front ends 8.4, Ubuntu 10.04 | Dean le Roux | 15:00 |
| 9.0+ way of determining if a LISTEN channel has a backend listening? | James Robinson | 15:51 |
| Re: 9.0+ way of determining if a LISTEN channel has a backend listening? | Greg Sabino Mullane | 22:22 |
| Thread | Author | Time |
|---|---|---|
| selecting records X minutes apart | lists-pgsql | 19:52 |
| Thread | Author | Time |
|---|---|---|
| Re: selecting records X minutes apart | Kevin Crain | 01:01 |
| Re: selecting records X minutes apart | Jasen Betts | 11:45 |
| Re: selecting records X minutes apart | Kevin Crain | 15:49 |
| Re: selecting records X minutes apart | lists-pgsql | 18:58 |
| Re: selecting records X minutes apart | lists-pgsql | 19:15 |
| Re: selecting records X minutes apart | Richard Broersma | 20:09 |
| Re: [SQL] selecting records X minutes apart | Charlie | 20:42 |
| Re: selecting records X minutes apart | lists-pgsql | 20:49 |
| Thread | Author | Time |
|---|---|---|
| Re: selecting records X minutes apart | Kevin Crain | 00:51 |
| Re: selecting records X minutes apart | Kevin Crain | 00:56 |
| Re: selecting records X minutes apart | lists-pgsql | 01:36 |
| Re: selecting records X minutes apart | Richard Broersma | 02:10 |
| Re: [SQL] selecting records X minutes apart | Charlie | 04:02 |
| Re: selecting records X minutes apart | Masaru Sugawara | 11:52 |
| Re: selecting records X minutes apart | Masaru Sugawara | 12:06 |
| Re: selecting records X minutes apart | lists-pgsql | 19:42 |
| Thread | Author | Time |
|---|---|---|
| To find process that lock a table | manuel antonio ochoa | 23:16 |
| Re: To find process that lock a table | Scott Marlowe | 23:21 |
| Thread | Author | Time |
|---|---|---|
| need help with some aggregation magic | Andreas | 13:43 |
| Re: need help with some aggregation magic | Oliveiros d'Azevedo Cristina | 14:16 |
| Re: need help with some aggregation magic | Andreas | 16:13 |
| Re: need help with some aggregation magic | Richard Broersma | 16:20 |
| Re: need help with some aggregation magic | Andreas | 16:55 |
| Re: need help with some aggregation magic | Edgardo Portal | 21:22 |
| Re: need help with some aggregation magic | Kevin Crain | 21:39 |
| Thread | Author | Time |
|---|---|---|
| ANY for Array value check | Emi Lu | 15:10 |
| Thread | Author | Time |
|---|---|---|
| Returning a set of dates | C. Bensend | 04:28 |
| Re: Returning a set of dates | Samuel Gendler | 05:11 |
| Re: ANY for Array value check | Jasen Betts | 09:59 |
| Subselects not allowed? | Leif Biberg Kristensen | 15:01 |
| Re: Subselects not allowed? | Guillaume Lelarge | 15:08 |
| Re: Subselects not allowed? | Tom Lane | 15:14 |
| Re: Subselects not allowed? | Andreas Kretschmer | 15:23 |
| Re: Subselects not allowed? | Leif Biberg Kristensen | 15:23 |
| Re: Subselects not allowed? | Leif Biberg Kristensen | 15:39 |
| Re: Subselects not allowed? | Leif Biberg Kristensen | 20:09 |
| Re: Returning a set of dates | C. Bensend | 22:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Subselects not allowed? | Leif Biberg Kristensen | 08:22 |
| Re: Subselects not allowed? | Andreas Kretschmer | 08:37 |
| Re: selecting records X minutes apart | Gavin Flower | 21:50 |
| Thread | Author | Time |
|---|---|---|
| extract some column/value pairs via hstore | Tarlika Elisabeth Schmitz | 19:04 |
| Thread | Author | Time |
|---|---|---|
| Storage of Indian Language text in postgresql through PHP | INDER | 07:17 |
| Re: Subselects not allowed? | Florian Weimer | 14:00 |
| Sqlite to postgres database conversion.swedish chararacter issue | sara vanan | 17:37 |
| Re: Storage of Indian Language text in postgresql through PHP | Amitabh Kant | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Select For Update and Left Outer Join | greg.fenton | 01:01 |
| Merge overlapping time-periods | Jira, Marcel | 15:23 |
| Calling inner functions vs. Begin-End blocs | Charles N. Charotti | 15:40 |
| Re: Merge overlapping time-periods | F. BROUARD / SQLpro | 15:43 |
| Re: Merge overlapping time-periods | Oliveiros d'Azevedo Cristina | 16:37 |
| Re: Merge overlapping time-periods | Oliveiros d'Azevedo Cristina | 16:49 |
| finding gaps in temporal data | Samuel Gendler | 17:23 |
| Re: Storage of Indian Language text in postgresql through PHP | Jasen Betts | 20:02 |
| Re: finding gaps in temporal data | Samuel Gendler | 20:52 |
| "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres | Clem Dickey | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Re: "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres | Tom Lane | 05:59 |
| Re: "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres | Clem Dickey | 19:07 |
| Re: Sqlite to postgres database conversion.swedish chararacter issue | Viktor Bojović | 22:08 |
| Thread | Author | Time |
|---|---|---|
| pagination problem in postgresql need help | hatem gamal elzanaty | 22:43 |
| Thread | Author | Time |
|---|---|---|
| Append n Rows into a Single Row | Tripura | 00:20 |
| Re: Append n Rows into a Single Row | Samuel Gendler | 22:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Append n Rows into a Single Row | Rob Sargent | 03:33 |
| Re: Append n Rows into a Single Row | Samuel Gendler | 03:51 |
| Re: pagination problem in postgresql need help | Jasen Betts | 08:37 |
| Thread | Author | Time |
|---|---|---|
| Re: pagination problem in postgresql need help | Emi Lu | 13:29 |
| Query to select nested comments sorted by nesting and date | Cstdenis | 15:04 |
| Re: Append n Rows into a Single Row | Ross J. Reedstrom | 17:05 |
| Thread | Author | Time |
|---|---|---|
| problem with selecting from a function | Andreas | 01:55 |
| Re: problem with selecting from a function | Pavel Stehule | 03:56 |
| a strange order by behavior | Eyal Wilde | 10:37 |
| Thread | Author | Time |
|---|---|---|
| Re: a strange order by behavior | Samuel Gendler | 08:43 |
| Re: a strange order by behavior | Pavel Stehule | 08:45 |
| Re: a strange order by behavior | Samuel Gendler | 09:39 |
| Re: a strange order by behavior | Pavel Stehule | 10:01 |
| Re: a strange order by behavior | Samuel Gendler | 10:15 |
| Re: a strange order by behavior | Samuel Gendler | 10:39 |
| Re: a strange order by behavior | Samuel Gendler | 11:20 |
| Re: a strange order by behavior | Pavel Stehule | 13:44 |
| Re: a strange order by behavior | Tom Lane | 14:49 |
| Re: a strange order by behavior | Peter Eisentraut | 20:10 |
| Re: a strange order by behavior | Peter Eisentraut | 20:12 |
| Thread | Author | Time |
|---|---|---|
| Re: a strange order by behavior | Pavel Stehule | 03:57 |
| Re: a strange order by behavior | Samuel Gendler | 04:34 |
| Re: a strange order by behavior | Peter Eisentraut | 05:05 |
| Re: a strange order by behavior | Pavel Stehule | 07:18 |
| Union out performs the single statement | John Fabiani | 15:44 |
| Re: Union out performs the single statement | John Fabiani | 16:45 |
| Thread | Author | Time |
|---|---|---|
| best performance for simple dml | chester c young | 06:09 |
| Re: best performance for simple dml | Pavel Stehule | 06:35 |
| Re: best performance for simple dml | chester c young | 06:48 |
| Re: best performance for simple dml | Pavel Stehule | 07:05 |
| Re: best performance for simple dml | chester c young | 07:49 |
| Re: best performance for simple dml | Craig Ringer | 08:02 |
| Re: best performance for simple dml | chester c young | 13:02 |
| Re: best performance for simple dml | Pavel Stehule | 13:40 |
| Thread | Author | Time |
|---|---|---|
| How to remove a set of characters in text-columns ? | Andreas | 19:28 |
| Re: How to remove a set of characters in text-columns ? | Steve Crawford | 19:49 |
| Re: [SQL] How to remove a set of characters in text-columns ? | Charlie | 19:57 |