Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Advice - indexing on varchar fields where only last x characters known | Alvaro Herrera | 18:39 |
| Re: Advice - indexing on varchar fields where only last x characters known | Gavin Flower | 18:43 |
| Re: Advice - indexing on varchar fields where only last x characters known | David Johnston | 19:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Advice - indexing on varchar fields where only last x characters known | Gary Stainburn | 07:22 |
| Re: Re: Advice - indexing on varchar fields where only last x characters known | Craig R. Skinner | 11:37 |
| Re: Advice - indexing on varchar fields where only last x characters known | David Johnston | 13:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Advice - indexing on varchar fields where only last x characters known | Gary Stainburn | 09:52 |
| 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 |