Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: PostGres Tables in ArcSDE and ArcCatalog. | Michael Andrew Babb | 00:58 |
| Re: polygon overlay | Tom Lane | 13:42 |
| Thread | Author | Time |
|---|---|---|
| SUM the result of a subquery. 📎 | negora | 12:17 |
| SUM the result of a subquery. 📎 | negora | 12:19 |
| Re: SUM the result of a subquery. | Jayadevan M | 12:28 |
| Re: SUM the result of a subquery. 📎 | negora | 12:36 |
| Thread | Author | Time |
|---|---|---|
| Generating Rows from a date and a duration | Tim Schumacher | 09:40 |
| procedure help between databases | Daniel Sobey | 10:49 |
| Thread | Author | Time |
|---|---|---|
| naming arguments in aggregate function | Viktor Bojović | 23:38 |
| Thread | Author | Time |
|---|---|---|
| Re: naming arguments in aggregate function | Tom Lane | 00:35 |
| Thread | Author | Time |
|---|---|---|
| is there a distinct function for comma lists ? | Andreas | 11:52 |
| Re: is there a distinct function for comma lists ? | Andreas Gaab | 12:19 |
| Sequential scan evaluating function for each row, seemingly needlessly | Bryce Nesbitt | 19:15 |
| Re: Sequential scan evaluating function for each row, seemingly needlessly | Tom Lane | 20:31 |
| Thread | Author | Time |
|---|---|---|
| Re: is there a distinct function for comma lists ? | Lew | 02:14 |
| Table returning functions | Jann Röder | 13:35 |
| Re: Generating Rows from a date and a duration | Tim Schumacher | 15:24 |
| Re: Generating Rows from a date and a duration | Joe Conway | 16:02 |
| Thread | Author | Time |
|---|---|---|
| Controlling join order with parenthesis | Marc Mamin | 12:51 |
| Re: Controlling join order with parenthesis | Tom Lane | 13:49 |
| Thread | Author | Time |
|---|---|---|
| sql disaster - subquery error but delete continues | Greg Caulton | 09:46 |
| Re: sql disaster - subquery error but delete continues | Thomas Kellerer | 10:07 |
| Thread | Author | Time |
|---|---|---|
| Question regarding indices | Steve | 12:29 |
| Question about PQexecParams | Steve | 12:44 |
| Re: Question regarding indices | Tom Lane | 15:04 |
| Re: Question regarding indices | Lew | 15:08 |
| Re: Question regarding indices | Steve | 17:08 |
| Re: Question regarding indices | Steve | 17:23 |
| Re: Question regarding indices | Tom Lane | 18:22 |
| Re: Question about PQexecParams | Dmitriy Igrishin | 21:52 |
| Thread | Author | Time |
|---|---|---|
| 9.0rc1 - query of view produces unexpected results | Nathan Grange | 01:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Question regarding indices | Steve | 00:03 |
| Thread | Author | Time |
|---|---|---|
| Re: 9.0rc1 - query of view produces unexpected results | Alvaro Herrera | 03:58 |
| Re: Question regarding indices | Frank Bax | 11:31 |
| Re: 9.0rc1 - query of view produces unexpected results 📎 | Nathan Grange | 16:56 |
| Re: 9.0rc1 - query of view produces unexpected results | Tom Lane | 17:51 |
| Thread | Author | Time |
|---|---|---|
| Use "CREATE USER" in plpgsql function | Tatarnikov Alexander | 04:05 |
| Re: Use "CREATE USER" in plpgsql function | Sergey Konoplev | 06:40 |
| Re: Use "CREATE USER" in plpgsql function | Sergey Konoplev | 07:55 |
| Re: Use "CREATE USER" in plpgsql function | Igor Neyman | 14:26 |
| Re: Use "CREATE USER" in plpgsql function | Asko Oja | 18:28 |
| Re: Use "CREATE USER" in plpgsql function - Found word(s) list error in the Text body | Igor Neyman | 19:06 |
| Re: Use "CREATE USER" in plpgsql function - Found word(s) list error in the Text body | Igor Neyman | 19:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Use "CREATE USER" in plpgsql function - Found word(s) list error in the Text body | Tatarnikov Alexander | 02:03 |
| with queries | Greg Quinn | 05:05 |
| with queries | Greg Quinn | 05:45 |
| Thread | Author | Time |
|---|---|---|
| all the table values equal | Michele Petrazzo - Unipex | 14:50 |
| Re: all the table values equal | Oliveiros d'Azevedo Cristina | 15:03 |
| Re: all the table values equal | Michele Petrazzo - Unipex | 15:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Table returning functions | Jann Röder | 23:04 |
| Re: Table returning functions | Tom Lane | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Table returning functions | Jann Röder | 07:43 |
| Jagged/ragged arrays | Florian Weimer | 08:54 |
| Re: all the table values equal | Oliveiros d'Azevedo Cristina | 09:29 |
| Re: Jagged/ragged arrays | Dmitriy Igrishin | 19:42 |
| Thread | Author | Time |
|---|---|---|
| insert into help | Nicholas I | 07:32 |
| Re: insert into help | Guillaume Lelarge | 07:35 |
| Re: insert into help | venkat | 07:35 |
| Re: Question about PQexecParams | Steve | 10:07 |
| pg_config -less | Rob Sargent | 19:51 |
| Thread | Author | Time |
|---|---|---|
| HowTo divide streetname from house-nr ? | Andreas | 01:25 |
| Re: HowTo divide streetname from house-nr ? | Craig Ringer | 02:08 |
| unique fields | Adrian Johnson | 03:30 |
| Re: HowTo divide streetname from house-nr ? 📎 | negora | 07:12 |
| Re: unique fields | Sergey Konoplev | 07:33 |
| Re: unique fields | Oliveiros d'Azevedo Cristina | 10:01 |
| Re: HowTo divide streetname from house-nr ? | Andreas Schmitz | 10:53 |
| Re: Proper case function | Jonathan Brinkman | 14:13 |
| Re: pg_config -less | Tom Lane | 14:49 |
| Question Regarding Unique Index on Table | Ozer, Pam | 17:18 |
| Re: Question Regarding Unique Index on Table | Kenneth Marshall | 18:33 |
| Re: pg_config -less | Rob Sargent | 18:43 |
| Re: pg_config -less | Rob Sargent | 18:46 |
| identifying duplicates in table with redundancies | Tarlika Elisabeth Schmitz | 21:39 |
| Thread | Author | Time |
|---|---|---|
| find and replace the string within a column | Nicholas I | 09:15 |
| Re: find and replace the string within a column | Jayadevan M | 09:33 |
| Re: insert into help | James Kitambara | 09:37 |
| Re: identifying duplicates in table with redundancies | Oliveiros d'Azevedo Cristina | 10:22 |
| Re: find and replace the string within a column | Craig Ringer | 11:34 |
| pgdump with insert command help | Nicholas I | 12:32 |
| Re: pgdump with insert command help | Guillaume Lelarge | 12:49 |
| Re: find and replace the string within a column | Leif Biberg Kristensen | 14:39 |
| Re: identifying duplicates in table with redundancies | Tarlika Elisabeth Schmitz | 16:12 |
| Re: identifying duplicates in table with redundancies | Oliver d'Azevedo Christina | 17:12 |
| Re: identifying duplicates in table with redundancies | Tarlika Elisabeth Schmitz | 17:39 |
| Thread | Author | Time |
|---|---|---|
| Re: pgdump with insert command help | Vibhor Kumar | 11:31 |
| Re: identifying duplicates in table with redundancies | Tarlika Elisabeth Schmitz | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Regexp matching | Eduardas Kazakas | 08:34 |
| eB7E2R | gangadhar bandaru | 09:02 |
| Re: identifying duplicates in table with redundancies | Oliveiros d'Azevedo Cristina | 10:34 |
| Re: is there a distinct function for comma lists ? | msi77 | 14:00 |
| Re: identifying duplicates in table with redundancies | Tarlika Elisabeth Schmitz | 20:36 |
| Thread | Author | Time |
|---|---|---|
| Shema with template | Thomas Andres | 06:42 |
| Re: identifying duplicates in table with redundancies | Andreas Schmitz | 08:40 |
| Re: identifying duplicates in table with redundancies | Tarlika Elisabeth Schmitz | 11:41 |
| Re: identifying duplicates in table with redundancies | Oliveiros d'Azevedo Cristina | 13:00 |
| Re: Regexp matching | Osvaldo Kussama | 13:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Question about PQexecParams | Kenneth Marshall | 17:12 |
| Re: Question about PQexecParams | Dmitriy Igrishin | 18:30 |
| Re: Question about PQexecParams | Kenneth Marshall | 19:14 |