Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] turning a table by 90 degrees | Peter Eisentraut | 00:18 |
| Re: [SQL] timestamp/now in views | Tom Lane | 01:15 |
| Re: [SQL] subquery, except and view | De Moudt Walter | 02:11 |
| Re: [SQL] select a part of a name | neko | 02:36 |
| Re: [SQL] subquery, except and view | marten | 08:08 |
| Re: [SQL] select a part of a name | [email protected] | 08:57 |
| Re: [SQL] timestamp/now in views | Jan Wieck | 15:18 |
| Re: [SQL] subquery, except and view | Jan Wieck | 15:27 |
| (no subject) | cristi voinicaru | 16:20 |
| (no subject) | cristi voinicaru | 16:21 |
| Re: [SQL] subquery, except and view | Tom Lane | 19:20 |
| Thread | Author | Time |
|---|---|---|
| numbered table? | UEBAYASHI 'UMA' Masao | 06:34 |
| Re: [SQL] numbered table? | UEBAYASHI 'UMA' Masao | 10:23 |
| Deleting large objects. | Czarny Marcin | 13:27 |
| Transactions and functions | <Miguel Sofer | 13:35 |
| INSERT and SELECT | Eric BARROCA | 15:46 |
| Re: [SQL] INSERT and SELECT | Stuart Rison | 16:31 |
| Re: [SQL] INSERT and SELECT | Vladimir Terziev | 16:38 |
| Re: [SQL] INSERT and SELECT | Nikolay Mijaylov | 16:43 |
| Re: [SQL] INSERT and SELECT | Eric BARROCA | 16:49 |
| Re: [SQL] INSERT and SELECT | Ross J. Reedstrom | 16:54 |
| Re: [SQL] INSERT and SELECT | Jan Wieck | 16:57 |
| Re: [SQL] INSERT and SELECT | neko | 17:12 |
| Re: [SQL] INSERT and SELECT | kaiq | 17:23 |
| Dilema. | Mitch Vincent | 21:36 |
| Re: [SQL] Dilema. | Tom Lane | 23:10 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Dilema. | Jan Wieck | 00:03 |
| Re: [SQL] Dilema. | Jan Wieck | 00:29 |
| Re: [SQL] Dilema. | Gene Selkov Jr. | 07:52 |
| polygon problem | Brent Wood | 21:32 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] polygon problem | Gene Selkov Jr. | 01:43 |
| Re: [SQL] polygon problem | Tom Lane | 05:53 |
| [No subject] | Bruno Mendonca | 20:13 |
| Thread | Author | Time |
|---|---|---|
| how to tell the difference between empty field and null field | Alex Howansky | 04:17 |
| Re: [SQL] how to tell the difference between empty field and null field | Tom Lane | 05:14 |
| Re: [SQL] how to tell the difference between empty field and null field | Alex Howansky | 05:31 |
| Problem copying polygon data into a table | Brent Wood | 06:36 |
| Re: [SQL] how to tell the difference between empty field and null field | Tom Lane | 07:29 |
| Re: [SQL] Problem copying polygon data into a table | Jan Wieck | 07:29 |
| Re: [SQL] Problem copying polygon data into a table | Tom Lane | 08:00 |
| Re: [SQL] how to tell the difference between empty field and null field | Moray McConnachie | 10:40 |
| How do I get column names? | Steven M. Wheeler | 20:30 |
| Re: [SQL] How do I get column names? | Tom Lane | 22:50 |
| Thread | Author | Time |
|---|---|---|
| System Attribute | Drew Whittle | 00:14 |
| Re: [SQL] System Attribute | Mathijs Brands | 00:33 |
| Re: [SQL] How do I get column names? | neko | 01:13 |
| SQL'92 web resources | Stoyan Genov | 10:49 |
| Deleting large objects from database. | Czarny Marcin | 11:53 |
| SQLDA or UPDATE WHERE CURRENT OF | Lendvary Gyorgy | 14:11 |
| wildcards with datetime columns | Harald Kirschner | 15:40 |
| Re: [SQL] Deleting large objects from database. | neko | 18:16 |
| Re: [SQL] SQL'92 web resources | De Moudt Walter | 20:21 |
| Thread | Author | Time |
|---|---|---|
| Search optimisation | Olwen Williams | 00:26 |
| Re: [SQL] Search optimisation | Tom Lane | 06:57 |
| Re: [SQL] numbered table? | UEBAYASHI Masao | 07:43 |
| Re: [SQL] SQL'92 web resources | Patrick JACQUOT | 10:37 |
| adding time to a datetime field ... how? | The Hermit Hacker | 13:31 |
| Re: [SQL] adding time to a datetime field ... how? | Margarit Nickolov | 14:01 |
| Re: [SQL] adding time to a datetime field ... how? | Vladimir Terziev | 16:21 |
| Re: [SQL] numbered table? | Tom Lane | 16:28 |
| Re: [GENERAL] Access rescrictions | brent wood | 17:39 |
| Re: [SQL] having with sub select? | Tom Lane | 23:33 |
| having with sub select? | kaiq | 23:47 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] having with sub select? | kaiq | 00:30 |
| TRANSACTIONS and TCP/IP | Barry Baldwin | 00:38 |
| Re: [SQL] having with sub select? | Tom Lane | 03:00 |
| Re: [SQL] TRANSACTIONS and TCP/IP | Tom Lane | 03:42 |
| Re: [SQL] Deleting large objects from database. | Howie | 05:51 |
| Re: [SQL] TRANSACTIONS and TCP/IP | George Moga | 07:04 |
| help | Rio | 07:13 |
| Re: [SQL] TRANSACTIONS and TCP/IP | Vladimir Terziev | 09:00 |
| REF function | Rahul Ravindrudu | 10:40 |
| RE: [SQL] Deleting large objects from database. | Czarny Marcin | 14:43 |
| manually set serial type | rob caSSon | 18:03 |
| RE: [SQL] TRANSACTIONS and TCP/IP | Barry Baldwin | 18:37 |
| Re:[OT]-[SQL] manually set serial type | rob caSSon | 19:22 |
| Re: [SQL] manually set serial type | kaiq | 19:22 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] adding time to a datetime field ... how? | Peter Eisentraut | 00:31 |
| Re:[OT]-[SQL] manually set serial type | Howie | 08:18 |
| Re: [SQL] adding time to a datetime field ... how? | Margarit Nickolov | 09:43 |
| select with group by problem | Stephan Bauer | 13:11 |
| Re: [SQL] select with group by problem | kaiq | 15:26 |
| Re: [SQL] select with group by problem | neko | 15:55 |
| Re: [SQL] select with group by problem | Tom Lane | 17:09 |
| simple sql select help | Kyle | 18:03 |
| Sub-select speed. | Mitch Vincent | 18:50 |
| indices on join | admin | 19:55 |
| can't join with indices | admin | 21:34 |
| Re: [SQL] Sub-select speed. | Tom Lane | 21:45 |
| making 'like' queries quicker | admin | 22:04 |
| Re: [SQL] Sub-select speed. | Bruce Momjian | 22:05 |
| avg() on numeric ? | kaiq | 22:44 |
| Re: [SQL] avg() on numeric ? | Tom Lane | 23:14 |
| Re: [SQL] Sub-select speed. | Tom Lane | 23:25 |
| Re: [SQL] avg() on numeric ? | Jan Wieck | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Sub-select speed. | Bruce Momjian | 00:32 |
| Re: [SQL] avg() on numeric ? | Tom Lane | 01:10 |
| count() question | Mitch Vincent | 03:56 |
| Oracle Pro*c books | Ranjan Polavarapu | 12:28 |
| Re: [SQL] making 'like' queries quicker | admin | 14:52 |
| Re: [SQL] count() question | Peter Eisentraut | 16:13 |
| Re: [SQL] making 'like' queries quicker | Peter Eisentraut | 16:13 |
| Re: [SQL] making 'like' queries quicker | [email protected] | 21:53 |
| Re: [SQL] making 'like' queries quicker | Tom Lane | 22:27 |
| Re: [SQL] [Q] Merging two queries? | Tom Lane | 22:48 |
| [Q] Merging two queries? | angelko | 23:00 |
| NOTICE: (transaction aborted): queries ignored until END | Alex Guryanow | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END | Mike Mascari | 01:58 |
| Re: [SQL] NOTICE: (transaction aborted): queries ignored until END | neko | 09:47 |
| Re: [SQL] making 'like' queries quicker | [email protected] | 10:20 |
| group by / having | Alain TESIO | 14:28 |
| group by / having | Alain TESIO | 16:04 |
| Re: [SQL] group by / having | Tom Lane | 16:54 |
| Re: [SQL] count() question | Mitch Vincent | 17:33 |
| Re: [SQL] count() question | Oleg Bartunov | 18:15 |
| New count() question | Mitch Vincent | 18:26 |
| Re: [SQL] group by / having | Alain TESIO | 18:41 |
| Right to create temp tables | Alain TESIO | 19:06 |
| Re: [GENERAL] NOTICE: (transaction aborted): queries ignored until END | Timothy Laswell | 20:09 |
| Rule Question | Mitch Vincent | 21:40 |
| Re: [SQL] New count() question | Tom Lane | 22:38 |
| Re: [SQL] Rule Question | Tom Lane | 22:52 |
| Thread | Author | Time |
|---|---|---|
| MINUS emulation? | Barry Baldwin | 01:47 |
| Re: [SQL] MINUS emulation? | [email protected] | 02:18 |
| Re: [SQL] MINUS emulation? | Tom Lane | 03:10 |
| Antw: Re: [SQL] group by / having | Gerhard Dieringer | 09:30 |
| Re: [SQL] select with group by problem | Vladimir Terziev | 09:58 |
| Inheriting Primary Keys | Dan Linderman | 15:00 |
| Trigger tables | Dan Linderman | 15:02 |
| Thread | Author | Time |
|---|---|---|
| problem with OR'ed AND queriess | Michael McCarthy | 21:05 |
| Re: [SQL] problem with OR'ed AND queriess | David C Hartwig Jr | 22:53 |
| Re: [SQL] problem with OR'ed AND queriess | Michael McCarthy | 23:33 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] problem with OR'ed AND queriess | Tom Lane | 00:02 |
| query result formatting | Stuart Gopen | 00:14 |
| Re: [SQL] problem with OR'ed AND queriess | David C Hartwig Jr | 02:47 |
| Re: [SQL] problem with OR'ed AND queriess | Bruce Momjian | 03:51 |
| Re: [SQL] problem with OR'ed AND queriess | Tom Lane | 04:13 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Bron Till | 03:22 |
| SQL features... | rjb | 16:50 |
| Thread | Author | Time |
|---|---|---|
| Sorting Problem | Mark Kirkwood | 01:04 |
| Re: [SQL] SQL features... | Howie | 05:51 |
| Re: [SQL] SQL features... | Jan Wieck | 11:46 |
| libpq test | Igor | 12:02 |
| Re: [SQL] libpq test | Tom Lane | 14:53 |
| Thread | Author | Time |
|---|---|---|
| Performance tuning!!! | Baris ULU | 11:38 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Performance tuning!!! | omid omoomi | 00:41 |
| Empty value for DATA field | 709394 | 10:46 |
| Problem with limit / union / etc. | M. Scott Smith | 16:17 |
| Re: [SQL] Problem with limit / union / etc. | Alain.Tesio | 18:29 |
| Re: [SQL] Problem with limit / union / etc. | Tom Lane | 20:13 |
| Oracle sql queries | Russ McBride | 21:39 |
| Oracle sql queries | Russ McBride | 21:56 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Oracle sql queries | Jan Wieck | 00:46 |
| Index scan on CIDR field ? | Margarit Nickolov | 08:46 |
| Index scan on CIDR field ? | Margarit Nickolov | 08:52 |
| Re: [NOVICE] Index scan on CIDR field ? | D. Duccini | 14:52 |
| unsubscribe | Steven Pennie | 15:15 |
| Re: [SQL] Index scan on CIDR field ? | Tom Lane | 15:47 |
| Thread | Author | Time |
|---|---|---|
| datetime fields have '60' in seconds field | Werner Fraga | 19:06 |
| datetime fields have '60' in seconds field | Werner Fraga | 20:18 |
| Thread | Author | Time |
|---|---|---|
| timespan problem | Tulassay Zsolt | 20:48 |
| Re: [SQL] timespan problem | Tom Lane | 23:58 |
| Thread | Author | Time |
|---|---|---|
| unsubscribe | lyman1 | 15:12 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] timespan problem | Thomas Lockhart | 07:38 |
| Re: [SQL] timespan problem | Thomas Lockhart | 08:48 |
| Re: [SQL] timespan problem | Tom Lane | 15:05 |
| restriction clause selectivity bad value | Wallingford, Ted | 17:00 |
| Re: [ADMIN] restriction clause selectivity bad value | Marcio Macedo | 17:15 |
| Re: [ADMIN] restriction clause selectivity bad value | Bruce Momjian | 17:19 |
| Re: [ADMIN] restriction clause selectivity bad valueu | Bruce Momjian | 17:20 |
| Thread | Author | Time |
|---|---|---|
| Triggers | Mitch Vincent | 15:04 |
| Re: [SQL] Triggers | Tom Lane | 15:55 |
| Re: [SQL] Triggers | Mitch Vincent | 16:21 |
| Re: [SQL] Triggers | Jan Wieck | 18:42 |
| Re: [SQL] Triggers | Matthew Hagerty | 19:27 |
| Thread | Author | Time |
|---|---|---|
| Calculation dependencies in views | Rick Delaney | 00:14 |
| Re: [SQL] datetime fields have '60' in seconds field | omid omoomi | 00:37 |
| Re: [SQL] Calculation dependencies in views | Jan Wieck | 01:03 |
| Re: [SQL] Calculation dependencies in views | Tom Lane | 05:35 |
| plpgsql bug(?) | Kovacs Zoltan | 10:25 |
| Re: [SQL] plpgsql bug(?) | Jan Wieck | 15:05 |
| Re: [SQL] datetime fields have '60' in seconds field | Tom Lane | 15:32 |
| Re: [SQL] Calculation dependencies in views | Rick Delaney | 20:14 |
| Re: [SQL] Calculation dependencies in views | Rick Delaney | 20:15 |
| Re: [SQL] Calculation dependencies in views | Jan Wieck | 21:49 |
| Re: [SQL] Calculation dependencies in views | Rick Delaney | 23:13 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Calculation dependencies in views | Jan Wieck | 00:10 |
| Autonumber column | Bron Till | 00:40 |
| Re: [SQL] Autonumber column | Bruce Momjian | 01:32 |
| Re: [SQL] Calculation dependencies in views | Tom Lane | 01:47 |
| Re: [SQL] Autonumber column | Vladimir Terziev | 08:24 |
| Re: [SQL] Calculation dependencies in views | Rick Delaney | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Serial field starting at 100 ? | Richard Walker | 02:35 |
| Re: [SQL] Serial field starting at 100 ? | Vladimir Terziev | 15:56 |
| Is there something wrong with datatype float8 ??? | Ana Roizen | 17:00 |
| Re: [SQL] datetime fields have '60' in seconds field | Werner Fraga | 19:19 |
| Thread | Author | Time |
|---|---|---|
| createdb -D xxxx not working | Chris Griffin | 06:02 |
| Re: [SQL] createdb -D xxxx not working | Tom Lane | 06:47 |
| Could this be done better...? | The Hermit Hacker | 07:03 |
| Thread | Author | Time |
|---|---|---|
| can't seem to use index | admin | 21:33 |