Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Number of days in a tstzrange? | Craig R. Skinner | 20:46 |
| Re: Number of days in a tstzrange? | Jonathan S. Katz | 21:00 |
| Thread | Author | Time |
|---|---|---|
| index on values stored in a json array | Raphael Bauduin | 09:17 |
| Re: index on values stored in a json array | Jonathan S. Katz | 14:21 |
| Thread | Author | Time |
|---|---|---|
| Re: index on values stored in a json array | Raphael Bauduin | 07:30 |
| Thread | Author | Time |
|---|---|---|
| sum of until (running balance) and sum of over date range in the same query | M. D. | 03:42 |
| Re: sum of until (running balance) and sum of over date range in the same query | David Johnston | 04:17 |
| Re: Number of days in a tstzrange? | Craig R. Skinner | 11:34 |
| Re: Re: sum of until (running balance) and sum of over date range in the same query | M. D. | 13:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Number of days in a tstzrange? | Craig R. Skinner | 10:40 |
| Re: Number of days in a tstzrange? | Gavin Flower | 18:21 |
| Thread | Author | Time |
|---|---|---|
| json and aggregate | Diway | 20:22 |
| Re: json and aggregate | David Johnston | 20:38 |
| Re: json and aggregate | Diway | 21:05 |
| Re: json and aggregate | David Johnston | 21:15 |
| Thread | Author | Time |
|---|---|---|
| Query specific table using relative position in search path | George Woodring | 16:51 |
| How to script inserts where id is needed as fk | Michael Schmidt | 19:44 |
| Re: How to script inserts where id is needed as fk | Jonathan S. Katz | 19:48 |
| Re: Query specific table using relative position in search path | Sergey Konoplev | 20:42 |
| Re: Query specific table using relative position in search path | George Woodring | 20:57 |
| Re: Query specific table using relative position in search path | Sergey Konoplev | 21:32 |
| Thread | Author | Time |
|---|---|---|
| Find datatype of a column during the backend flow | Ishaya Bhatt | 15:27 |
| Re: How to script inserts where id is needed as fk | Michael Schmidt | 20:09 |
| Re: How to script inserts where id is needed as fk | Jonathan S. Katz | 21:15 |
| Re: How to script inserts where id is needed as fk | David Johnston | 21:55 |
| Re: How to script inserts where id is needed as fk | Michael Schmidt | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Find datatype of a column during the backend flow | Sergey Konoplev | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 18:17 |
| Re: Function args: TEXT -vs- VARCHAR? | Luca Vernini | 18:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Function args: TEXT -vs- VARCHAR? | Sergey Konoplev | 03:07 |
| Re: Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 13:03 |
| Re: Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 13:05 |
| Re: Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 14:17 |
| Re: Function args: TEXT -vs- VARCHAR? | Pavel Stehule | 14:20 |
| Re: Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 14:25 |
| Re: Function args: TEXT -vs- VARCHAR? | Adrian Klaver | 14:34 |
| Re: Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 15:51 |
| Re: Function args: TEXT -vs- VARCHAR? | Tom Lane | 16:36 |
| Re: Function args: TEXT -vs- VARCHAR? | David Johnston | 17:14 |
| Re: Function args: TEXT -vs- VARCHAR? | Tom Lane | 17:51 |
| Re: Function args: TEXT -vs- VARCHAR? | David Johnston | 17:59 |
| Re: Function args: TEXT -vs- VARCHAR? | Craig R. Skinner | 18:04 |
| Re: Function args: TEXT -vs- VARCHAR? | Tom Lane | 18:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Function args: TEXT -vs- VARCHAR? | Sergey Konoplev | 07:41 |
| Thread | Author | Time |
|---|---|---|
| Importing MySql dumped db into pgadmin | miks87 | 15:49 |
| Re: Importing MySql dumped db into pgadmin | Theodore Petrosky | 16:02 |
| Re: Importing MySql dumped db into pgadmin | Adrian Klaver | 16:08 |
| Re: Importing MySql dumped db into pgadmin | miks87 | 16:11 |
| Re: Importing MySql dumped db into pgadmin | miks87 | 16:21 |
| Re: Importing MySql dumped db into pgadmin | Jan Lentfer | 16:37 |
| Re: Importing MySql dumped db into pgadmin | Adrian Klaver | 17:06 |
| Thread | Author | Time |
|---|---|---|
| tab delimiter in output | Marcin Krawczyk | 11:14 |
| Re: tab delimiter in output | Ian Lawrence Barwick | 11:26 |
| Re: tab delimiter in output | Thomas Kellerer | 11:42 |
| Re: tab delimiter in output | Marcin Krawczyk | 12:00 |
| Re: tab delimiter in output | Marcin Krawczyk | 12:01 |
| Thread | Author | Time |
|---|---|---|
| isnumeric(varchar) by psql | Emi Lu | 21:46 |
| Re: isnumeric(varchar) by psql | Venky Kandaswamy | 21:54 |
| Thread | Author | Time |
|---|---|---|
| Re: tab delimiter in output | seikath | 09:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Results list String to comma separated int | David Johnston | 03:02 |
| Re: XMLELEMENT produce a lower case of element name | David Johnston | 03:19 |
| Thread | Author | Time |
|---|---|---|
| Scheduled Events | Dev Kumkar | 11:38 |
| Re: Scheduled Events | Dev Kumkar | 15:00 |
| Thread | Author | Time |
|---|---|---|
| NULLs and composite types | Dean Gibson (DB Administrator) | 00:19 |
| Re: [GENERAL] Scheduled Events | Vick Khera | 16:29 |
| Re: NULLs and composite types | David Johnston | 19:25 |
| Re: NULLs and composite types | Dean Gibson (DB Administrator) | 21:57 |
| Re: NULLs and composite types | Tom Lane | 23:57 |
| Thread | Author | Time |
|---|---|---|
| Re: NULLs and composite types | Dean Gibson (DB Administrator) | 04:31 |
| Thread | Author | Time |
|---|---|---|
| Query caching (with 8.3) | Achilleas Mantzios | 10:58 |
| Re: Query caching (with 8.3) | Vik Fearing | 23:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Query caching (with 8.3) | Achilleas Mantzios | 08:09 |
| Re: Query caching (with 8.3) | Vik Fearing | 10:32 |
| Re: [ADMIN] Scheduled Events | Marcin Krawczyk | 12:06 |
| Re: Query caching (with 8.3) | Achilleas Mantzios | 14:54 |
| Re: Query caching (with 8.3) | Gavin Flower | 18:37 |
| Re: Query caching (with 8.3) | Sergey Konoplev | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Query caching (with 8.3) | Achilleas Mantzios | 08:45 |
| Thread | Author | Time |
|---|---|---|
| Index on multiple columns VS multiple index | Brice André | 19:17 |
| Re: Index on multiple columns VS multiple index | Jonathan S. Katz | 19:22 |
| Re: Index on multiple columns VS multiple index | Jonathan S. Katz | 19:33 |
| Re: Index on multiple columns VS multiple index | Erik Darling | 19:41 |
| Re: Index on multiple columns VS multiple index | Brice André | 19:45 |
| Re: Index on multiple columns VS multiple index | Brice André | 20:00 |
| Re: Index on multiple columns VS multiple index | Jonathan S. Katz | 20:05 |
| Re: Index on multiple columns VS multiple index | Jonathan S. Katz | 20:06 |
| Re: Index on multiple columns VS multiple index | Brice André | 20:12 |
| Thread | Author | Time |
|---|---|---|
| An archiving query - is it safe? | Herouth Maoz | 11:06 |
| Re: An archiving query - is it safe? | Vik Fearing | 12:55 |
| Re: An archiving query - is it safe? | Herouth Maoz | 14:34 |
| Thread | Author | Time |
|---|---|---|
| debugging triggers - get original statement? | gmb | 08:52 |
| Re: debugging triggers - get original statement? | Luca Vernini | 11:22 |
| Re: debugging triggers - get original statement? | gmb | 11:30 |
| Re: debugging triggers - get original statement? | bricklen | 15:25 |
| Thread | Author | Time |
|---|---|---|
| about running plpgsqlo.sql | minsheng.bai | 08:02 |
| Re: about running plpgsqlo.sql | Adrian Klaver | 15:18 |
| Thread | Author | Time |
|---|---|---|
| Deferrable conditional unique constraints | Andreas Joseph Krogh | 01:34 |
| Re: Deferrable conditional unique constraints | Marc Mamin | 17:33 |
| Thread | Author | Time |
|---|---|---|
| consulting the question about the usage about SSH Tunnel function | minsheng.bai | 02:06 |
| find all views depend on a schema/table | Emi Lu | 15:55 |
| Re: find all views depend on a schema/table | Tom Lane | 16:23 |
| Re: consulting the question about the usage about SSH Tunnel function | Adrian Klaver | 16:29 |
| Re: consulting the question about the usage about SSH Tunnel function | Adrian Klaver | 16:48 |
| Re: find all views depend on a schema/table | Emi Lu | 17:04 |
| Thread | Author | Time |
|---|---|---|
| Detecting when field value changes in Foreign Table? | bobspero | 00:17 |
| How to detect values changed in field of foreign table? | Bob Spero | 00:20 |
| Re: find all views depend on a schema/table | Tim Landscheidt | 04:42 |
| Trigger function - variable for schema name | ssylla | 08:39 |
| Re: Trigger function - variable for schema name | Glyn Astill | 10:47 |
| Re: Trigger function - variable for schema name | Glyn Astill | 11:00 |
| Update ordered | Andreas Joseph Krogh | 14:36 |
| Re: Update ordered | Adrian Klaver | 14:56 |
| Re: Update ordered | Andreas Joseph Krogh | 15:01 |
| How to insert rows distributed evenly between referenced rows? | Herouth Maoz | 15:10 |
| Re: How to insert rows distributed evenly between referenced rows? | Erik Darling | 15:13 |
| Re: Update ordered | Adrian Klaver | 15:23 |
| Re: Update ordered | Andreas Joseph Krogh | 15:37 |
| Re: How to insert rows distributed evenly between referenced rows? | Herouth Maoz | 15:42 |
| Re: Update ordered | Adrian Klaver | 15:48 |
| Re: Update ordered | Achilleas Mantzios | 15:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Trigger function - variable for schema name [SOLVED] | ssylla | 06:26 |
| Re: How to insert rows distributed evenly between referenced rows? | Herouth Maoz | 11:30 |
| Thread | Author | Time |
|---|---|---|
| "Timestamp out of range" | Sandeep Devan | 13:41 |
| Re: "Timestamp out of range" | Adrian Klaver | 15:25 |
| Re: How to detect values changed in field of foreign table? | Adrian Klaver | 15:41 |
| Thread | Author | Time |
|---|---|---|
| List all Indexes of a schema or database in CREATE syntax | basti | 15:18 |