Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Return product category with hierarchical info | Richard Klingler | 12:19 |
| Re: Return product category with hierarchical info | Oliveiros Cristina | 12:28 |
| Re: Return product category with hierarchical info | Richard Klingler | 12:37 |
| Re: Return product category with hierarchical info | Oliveiros Cristina | 13:00 |
| Re: Return product category with hierarchical info | Steve Midgley | 16:42 |
| Thread | Author | Time |
|---|---|---|
| Clean up shop database | Richard Klingler | 11:03 |
| Re: Clean up shop database | Rob Sargent | 12:04 |
| Re: Clean up shop database | Richard Klingler | 12:40 |
| Re: Clean up shop database | Rob Sargent | 12:56 |
| Re: Clean up shop database | Richard Klingler | 13:17 |
| Re: Clean up shop database | Rob Sargent | 13:32 |
| Re: Clean up shop database | Richard Klingler | 13:37 |
| Re: Clean up shop database | Rob Sargent | 13:41 |
| RE: Clean up shop database | Mike Sofen | 13:51 |
| Re: Clean up shop database | Richard Klingler | 13:57 |
| RE: Clean up shop database | Richard Klingler | 13:59 |
| Re: Clean up shop database | Rob Sargent | 16:41 |
| Thread | Author | Time |
|---|---|---|
| [No subject] 📎 | Дмитрий Воронин | 08:42 |
| How can i pass variable in dblink_connect_u ? | aditya desai | 10:42 |
| Offline HTML manual. | Jian He | 11:10 |
| Re: Offline HTML manual. | Tatsuo Ishii | 11:22 |
| Re: Offline HTML manual. | Nicolas Mitchell | 11:32 |
| Re: Offline HTML manual. | Florents Tselai | 12:20 |
| Re: Offline HTML manual. | Tatsuo Ishii | 13:19 |
| Re: How can i pass variable in dblink_connect_u ? | Joe Conway | 13:41 |
| Re: Offline HTML manual. | Jian He | 14:18 |
| Re: | Steve Midgley | 16:15 |
| Re: | Michael Lewis | 20:10 |
| Thread | Author | Time |
|---|---|---|
| Re: 📎 | Дмитрий Воронин | 05:38 |
| Re: | David G. Johnston | 05:47 |
| Thread | Author | Time |
|---|---|---|
| Re: How can i pass variable in dblink_connect_u ? | aditya desai | 11:38 |
| Increase fetch fize of oracl_fdw(ALTER SERVER) | aditya desai | 11:40 |
| How best to work around the issue - regex string cannot contain brackets | Shaozhong SHI | 16:53 |
| Re: How best to work around the issue - regex string cannot contain brackets | Christophe Pettus | 16:58 |
| Re: How best to work around the issue - regex string cannot contain brackets | David G. Johnston | 17:04 |
| Thread | Author | Time |
|---|---|---|
| Is there a way to automatically scan a table and determine the format of data | Shaozhong SHI | 01:27 |
| Try catch error, return data | Shaozhong SHI | 02:13 |
| Is there a way to automatically scan a table and determine the format of data | Shaozhong SHI | 02:13 |
| Re: Try catch error, return data | Skylar Thompson | 03:08 |
| Re: Try catch error, return data | Karsten Hilbert | 10:01 |
| Re: Is there a way to automatically scan a table and determine the format of data | Karsten Hilbert | 10:03 |
| Thread | Author | Time |
|---|---|---|
| Advancing the capability of Postgres and PostGIS | Shaozhong SHI | 22:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Turn a json column into a table | Shaozhong SHI | 22:03 |
| Re: Re: Re: Turn a json column into a table | Shaozhong SHI | 22:40 |
| Re: Turn a json column into a table | Rob Sargent | 22:46 |
| Re: Turn a json column into a table | Shaozhong SHI | 23:22 |
| Re: Turn a json column into a table | Shaozhong SHI | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Turn a json column into a table | David G. Johnston | 00:18 |
| Re: Turn a json column into a table | Shaozhong SHI | 00:58 |
| Re: Turn a json column into a table | David G. Johnston | 01:08 |
| Re: Turn a json column into a table | Shaozhong SHI | 03:31 |
| Aw: Re: Turn a json column into a table | Karsten Hilbert | 09:07 |
| Thread | Author | Time |
|---|---|---|
| automatic scan a table, report on data formats in columns | Shaozhong SHI | 10:06 |
| Re: automatic scan a table, report on data formats in columns | Jian He | 12:45 |
| Re: automatic scan a table, report on data formats in columns | David G. Johnston | 16:27 |
| Re: automatic scan a table, report on data formats in columns | Steve Midgley | 16:59 |
| Re: automatic scan a table, report on data formats in columns | Shaozhong SHI | 19:54 |
| Thread | Author | Time |
|---|---|---|
| PSQL: "\set ECHO all" doesn't work with "\o" | Alberto Benini | 18:18 |
| Re: PSQL: "\set ECHO all" doesn't work with "\o" | David G. Johnston | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Is there any function for calculating angle between 2 line segments in 3D? | Shaozhong SHI | 10:39 |
| Array_reverse | Shaozhong SHI | 16:53 |
| Re: Array_reverse | Pavel Stehule | 16:59 |
| Thread | Author | Time |
|---|---|---|
| NORM(NO ORM) transform two one-many relationships into a single json. 📎 | Jian He | 13:58 |
| Global setting for ORDER BY ... NULLS FIRST / LAST | Sebastien Flaesch | 14:16 |
| Re: Global setting for ORDER BY ... NULLS FIRST / LAST | David G. Johnston | 14:41 |
| Re: Global setting for ORDER BY ... NULLS FIRST / LAST | Tom Lane | 15:02 |
| pg_stat_progress_copy not working as intended | asalias mark | 17:55 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_stat_progress_copy not working as intended | Ian Lawrence Barwick | 00:17 |
| Re: pg_stat_progress_copy not working as intended | asalias mark | 09:48 |
| Re: Global setting for ORDER BY ... NULLS FIRST / LAST | Sebastien Flaesch | 12:23 |
| Thread | Author | Time |
|---|---|---|
| Bug in tables column data in postgres database | Sarita Sharma | 16:45 |
| AW: Bug in tables column data in postgres database | 17:10 | |
| Re: Bug in tables column data in postgres database | Christophe Pettus | 17:18 |
| Re: Bug in tables column data in postgres database 📎 | MichaelDBA Vitale | 17:24 |
| RE: Bug in tables column data in postgres database | Voillequin, Jean-Marc | 18:06 |
| Re: Bug in tables column data in postgres database | Sarita Sharma | 18:41 |
| Re: Bug in tables column data in postgres database | Rob Sargent | 19:24 |
| Re: Bug in tables column data in postgres database | David G. Johnston | 19:27 |
| Re: Bug in tables column data in postgres database | Steve Midgley | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Bug in tables column data in postgres database | Sarita Sharma | 08:04 |
| Re: Bug in tables column data in postgres database | David G. Johnston | 08:15 |
| Re: Bug in tables column data in postgres database | Sarita Sharma | 08:29 |
| Re: Bug in tables column data in postgres database | Thomas Kellerer | 08:40 |
| Re: Bug in tables column data in postgres database | David G. Johnston | 08:51 |
| Re: Bug in tables column data in postgres database | mgbii bax | 10:10 |
| Re: Bug in tables column data in postgres database | Sarita Sharma | 10:28 |
| Re: Bug in tables column data in postgres database | David G. Johnston | 15:27 |
| Re: Bug in tables column data in postgres database | Sarita Sharma | 15:56 |
| Re: Bug in tables column data in postgres database | David G. Johnston | 16:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Bug in tables column data in postgres database | Sándor Daku | 10:08 |
| Re: Bug in tables column data in postgres database | [email protected] | 12:23 |
| Re: Bug in tables column data in postgres database | Sarita Sharma | 13:49 |
| Thread | Author | Time |
|---|---|---|
| ERROR: extra data after last expected column | Scott Macri | 01:59 |
| Re: ERROR: extra data after last expected column | Sándor Daku | 09:08 |
| Re: ERROR: extra data after last expected column | Rob Sargent | 09:57 |
| Best practice for naming temp table trigger functions | Sebastien Flaesch | 18:19 |
| Re: ERROR: extra data after last expected column | scott macri | 23:33 |
| Re: ERROR: extra data after last expected column | Steve Midgley | 23:54 |
| Re: ERROR: extra data after last expected column | Steve Midgley | 23:56 |
| Re: ERROR: extra data after last expected column | Rob Sargent | 23:57 |
| Thread | Author | Time |
|---|---|---|
| Re: ERROR: extra data after last expected column | Scott Macri | 01:40 |
| Re: ERROR: extra data after last expected column | Ron | 01:42 |
| Re: ERROR: extra data after last expected column | Scott Macri | 01:51 |
| Re: ERROR: extra data after last expected column | Rob Sargent | 02:40 |
| Re: ERROR: extra data after last expected column | scott macri | 03:47 |
| Re: Best practice for naming temp table trigger functions | Sebastien Flaesch | 15:38 |
| Re: Best practice for naming temp table trigger functions | David G. Johnston | 16:16 |
| RE: unique index with several columns | Voillequin, Jean-Marc | 16:59 |
| Re: Best practice for naming temp table trigger functions | Sebastien Flaesch | 17:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Best practice for naming temp table trigger functions | Sebastien Flaesch | 08:26 |
| Thread | Author | Time |
|---|---|---|
| Apparently table locks are the key issue to see red flags | Shaozhong SHI | 20:14 |
| Apparently table locks are the key issue to see red flags | Shaozhong SHI | 20:15 |
| Re: Apparently table locks are the key issue to see red flags | Ron | 20:21 |
| Re: Apparently table locks are the key issue to see red flags | Adrian Klaver | 20:23 |
| How to explicitly lock and unlock tables in pgsql? | Shaozhong SHI | 20:30 |
| How to explicitly lock and unlock tables in pgsql? | Shaozhong SHI | 20:30 |
| Apparently table locks are the key issue to see red flags | Shaozhong SHI | 20:32 |
| Re: How to explicitly lock and unlock tables in pgsql? | Fabrízio de Royes Mello | 20:35 |
| How to explicitly state unlock in sql? | Shaozhong SHI | 20:56 |
| Re: How to explicitly state unlock in sql? | Rob Sargent | 21:03 |
| Re: How to explicitly state unlock in sql? | Tom Lane | 21:06 |
| Thread | Author | Time |
|---|---|---|
| Re: How to explicitly lock and unlock tables in pgsql? | Laurenz Albe | 07:51 |
| Re: Apparently table locks are the key issue to see red flags | Jayson Hreczuck | 13:21 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL trigger on user logon | Kevin Tu | 14:46 |
| Re: How to explicitly lock and unlock tables in pgsql? | Merlin Moncure | 16:38 |
| Re: PostgreSQL trigger on user logon | Steve Midgley | 19:58 |
| Re: How to explicitly lock and unlock tables in pgsql? | Laurenz Albe | 22:48 |
| Thread | Author | Time |
|---|---|---|
| the order of operator computation | Jian He | 04:46 |
| Re: the order of operator computation | Tom Lane | 05:32 |
| Thread | Author | Time |
|---|---|---|
| How long does iteration over 4-5 million rows usually take? | Shaozhong SHI | 01:34 |
| How long does iteration over 4-5 million rows usually take? | Shaozhong SHI | 01:35 |
| Re: How long does iteration over 4-5 million rows usually take? | Adrian Klaver | 01:47 |
| Re: How long does iteration over 4-5 million rows usually take? | Ron | 02:18 |
| Re: How long does iteration over 4-5 million rows usually take? | Rob Sargent | 13:21 |
| Aw: Re: How long does iteration over 4-5 million rows usually take? | Karsten Hilbert | 13:46 |
| Re: Re: How long does iteration over 4-5 million rows usually take? | Shaozhong SHI | 14:16 |
| Re: Re: How long does iteration over 4-5 million rows usually take? | Benedict Holland | 14:34 |
| Re: How long does iteration over 4-5 million rows usually take? | Steve Midgley | 16:38 |
| Thread | Author | Time |
|---|---|---|
| How to just get the last in a recursive query | Shaozhong SHI | 22:14 |
| Re: How to just get the last in a recursive query | Rob Sargent | 22:16 |
| Re: How to just get the last in a recursive query | Shaozhong SHI | 23:21 |
| Re: How to just get the last in a recursive query | Rob Sargent | 23:24 |
| Re: How to just get the last in a recursive query | David G. Johnston | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: How to just get the last in a recursive query | Steve Midgley | 00:00 |
| Re: How to just get the last in a recursive query | David G. Johnston | 00:50 |
| RE: How to just get the last in a recursive query | Tchouante, Merlin | 13:03 |
| Histogram question. | Jian He | 14:34 |
| Re: Histogram question. | Steve Midgley | 15:14 |
| Thread | Author | Time |
|---|---|---|
| Does postgresql know the check condition is valid or not. or can check deduce from multiple conditions | Jian He | 04:07 |