Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] DB link from postgres to Oracle; how to query Dbname.tablename? | Jayadevan M | 07:26 |
| Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename? | Albe Laurenz | 07:58 |
| Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects | Sergey Klochkov | 14:44 |
| Re: [ADMIN] DB link from postgres to Oracle; how to query Dbname.tablename? | Chris Twombly | 17:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Help needed with Window function | David Johnston | 01:06 |
| Re: Help needed with Window function | gmb | 05:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Help needed with Window function | Akihiro Okuno | 03:08 |
| Unique index VS unique constraint | JORGE MALDONADO | 16:48 |
| Re: Unique index VS unique constraint | [email protected] | 17:41 |
| Re: Unique index VS unique constraint | Adrian Klaver | 19:43 |
| Re: Unique index VS unique constraint | Adrian Klaver | 19:49 |
| Advice on defining indexes | JORGE MALDONADO | 21:28 |
| Re: Advice on defining indexes | David Johnston | 22:09 |
| Re: Advice on defining indexes | JORGE MALDONADO | 22:23 |
| Re: Unique index VS unique constraint | David Johnston | 22:38 |
| Re: Advice on defining indexes | David Johnston | 22:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Unique index VS unique constraint | Steve Grey | 02:20 |
| Re: Unique index VS unique constraint | David Johnston | 03:42 |
| Re: Unique index VS unique constraint | JORGE MALDONADO | 22:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Unique index VS unique constraint | Sergey Konoplev | 00:59 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Kaleeswaran Velu | 16:23 |
| Re: | Plugge, Joe R. | 16:26 |
| Re: | Andreas Kretschmer | 16:28 |
| Many to many link tables with history? | Craig R. Skinner | 17:04 |
| Thread | Author | Time |
|---|---|---|
| Question about index/constraint definition in a table | JORGE MALDONADO | 22:23 |
| Re: Question about index/constraint definition in a table | David Johnston | 22:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Question about index/constraint definition in a table | David Johnston | 01:11 |
| Re: | Kaleeswaran Velu | 03:54 |
| generate a range within a view | Gary Stainburn | 10:26 |
| Re: generate a range within a view | Gary Stainburn | 11:03 |
| Re: Many to many link tables with history? | Craig R. Skinner | 20:23 |
| Re: Many to many link tables with history? | Dylan Sanders | 20:25 |
| Re: Many to many link tables with history? | Craig R. Skinner | 20:55 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects | luckyjackgao | 07:24 |
| Re: [SQL] Comparison semantics of CHAR data type | Bruce Momjian | 19:44 |
| Re: [SQL] Comparison semantics of CHAR data type | Kevin Grittner | 20:58 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Comparison semantics of CHAR data type | Thomas Fanghaenel | 17:57 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK | Craig R. Skinner | 12:50 |
| Re: PostgreSQL 9.2 tstzrange null/infinity CONSTRAINT CHECK | Craig R. Skinner | 14:41 |
| Re: [SQL] Comparison semantics of CHAR data type | Bruce Momjian | 18:17 |
| Thread | Author | Time |
|---|---|---|
| Advice - indexing on varchar fields where only last x characters known | Gary Stainburn | 11:20 |
| Re: Advice - indexing on varchar fields where only last x characters known | Jayadevan M | 11:35 |
| Re: Advice - indexing on varchar fields where only last x characters known | Craig R. Skinner | 11:45 |
| Re: Advice - indexing on varchar fields where only last x characters known | Gavin Flower | 18:27 |
| 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 |