Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] MAX() of 0 records. | Tom Lane | 18:35 |
| Thread | Author | Time |
|---|---|---|
| Finding entries not in table..differnce? | Zot O'Connor | 00:29 |
| Re: Finding entries not in table..differnce? | Stephan Szabo | 00:43 |
| Re: Finding entries not in table..differnce? | Erol Oz | 00:50 |
| Creating timestamps in queries? | Rob S. | 05:26 |
| Re: Creating timestamps in queries? | Patrik Kudo | 07:07 |
| SQL-92 SQLSTATE in PostgreSQL ?! | Adam Walczykiewicz | 07:16 |
| Checking for existence of table | Paul McGarry | 07:28 |
| Change type of column | Volker Paul | 07:31 |
| Re: Supported Encoding | Volker Paul | 07:38 |
| RE: Change type of column | Rob S. | 15:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Creating timestamps in queries? | Frank Bax | 00:39 |
| RE: Creating timestamps in queries? | Rob S. | 01:07 |
| Re: Supported Encoding | Toshihide Tony Nakamura | 02:44 |
| Opposite of LOCK | Antti Linno | 08:11 |
| Re: Opposite of LOCK | Jan Wieck | 11:41 |
| Re: SERIAL type does not generate new ID ? | Jean-Marc Libs | 14:02 |
| Re: join if there, blank if not | Jacques Williams | 14:41 |
| join if there, blank if not | Gary Stainburn | 15:34 |
| Bug in to_char() | Brian Powell | 16:24 |
| Re: date comparision ??? | Ross J. Reedstrom | 16:55 |
| Re: Opposite of LOCK | Tom Lane | 17:06 |
| SQL | DATAPUC-Frederico Papatella Guerino | 17:11 |
| Re: importing in sql | Ross J. Reedstrom | 17:55 |
| Re: importing in sql | jmr | 18:19 |
| RE: join if there, blank if not | Henry Lafleur | 18:51 |
| Thread | Author | Time |
|---|---|---|
| RE: Re: Matching and Scoring with multiple fields | Tim Johnson | 00:13 |
| Antw: RE: join if there, blank if not | Gerhard Dieringer | 07:01 |
| Re: lztext and compression ratios... | Tom Lane | 07:07 |
| Re: lztext and compression ratios... | Hannu Krosing | 07:39 |
| Re: Bug in to_char() | Karel Zak | 08:56 |
| Re: join if there, blank if not | Patrick Jacquot | 10:59 |
| RE: join if there, blank if not | Henry Lafleur | 13:11 |
| update some elements in the array 📎 | Bernie Huang | 16:48 |
| Re: update some elements in the array 📎 | Bernie Huang | 17:55 |
| Re: update some elements in the array | Tom Lane | 18:22 |
| Thread | Author | Time |
|---|---|---|
| case-sensitivity and the serial type | John BEPPU | 09:21 |
| nevermind... | John BEPPU | 09:28 |
| Trigger | Carolyn Lu Wong | 14:11 |
| Re: nevermind... | Tom Lane | 15:09 |
| Re: Trigger | Tom Lane | 15:49 |
| transactions within stored procedures | Nathan Young | 16:02 |
| Re: transactions within stored procedures | Thomas Mack | 16:19 |
| Thread | Author | Time |
|---|---|---|
| Applying SUM twice in the same query. | Rodger Donaldson | 05:31 |
| Re: Applying SUM twice in the same query. | Tom Lane | 15:59 |
| Select by priority | Prasanth A. Kumar | 17:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Select by priority | omid omoomi | 00:51 |
| Re: Select by priority | Prasanth A. Kumar | 08:15 |
| Re: Select by priority | Peter Eisentraut | 14:45 |
| How to get count of rows in cursor | Robert B. Easter | 22:02 |
| Thread | Author | Time |
|---|---|---|
| SQL question | Carolyn Lu Wong | 02:07 |
| Re: SQL question | Philip Warner | 02:18 |
| Re: SQL question | Carolyn Lu Wong | 03:41 |
| Re: SQL question | Philip Warner | 04:11 |
| Re: SQL question | Tom Lane | 05:48 |
| Re: SQL question | Thomas Lockhart | 06:23 |
| Re: SQL question | Tom Lane | 06:26 |
| Re: SQL question | Philip Warner | 06:31 |
| Re: SQL question | Tom Lane | 07:03 |
| RE: Select by priority | Gary J. Farmer | 22:12 |
| Thread | Author | Time |
|---|---|---|
| Database authentication and configuration | Carolyn Lu Wong | 02:01 |
| Re: Select by priority | Prasanth A. Kumar | 02:37 |
| strange error message | Gerhard Dieringer | 06:29 |
| describe table in 7.0.2 | Tubagus Nizomi | 07:00 |
| using a self referencing table | drfrog | 16:05 |
| Re: Median | Jan Wieck | 19:35 |
| Re: Median | Tom Lane | 21:43 |
| Re: Database authentication and configuration | Peter Eisentraut | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: using a self referencing table | andrew | 00:19 |
| Re: Median | Thomas Lockhart | 02:12 |
| out-subject : thanks | Patrick Coulombe | 02:15 |
| Can I create a function that returns many records? | Joel Burton | 17:13 |
| Re: Can I create a function that returns many records? | Tom Lane | 18:21 |
| Re: Database authentication and configuration | Rodger Donaldson | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Order by in Select 📎 | Bernie Huang | 00:25 |
| Re: Order by in Select | Stephan Szabo | 00:38 |
| synchronizing databases | Nathan Young | 00:55 |
| from not null field to nullable field? | Carolyn Lu Wong | 06:13 |
| primary key question | Carolyn Lu Wong | 07:26 |
| Re: primary key question | Wim Ceulemans | 07:45 |
| Re: from not null field to nullable field? | Wim Ceulemans | 07:55 |
| test | Emils Klotins | 08:53 |
| Re: primary key question | omid omoomi | 14:03 |
| Nested Aggregates? | John | 16:02 |
| Thread | Author | Time |
|---|---|---|
| Re: create function - user permissions | Tom Lane | 06:03 |
| query optimazation & starting postmaster with -B option | sathya priya | 08:34 |
| Re: Why do I need to set UPDATE permissions for fkey check? | Jan Wieck | 09:01 |
| Re: create function - user permissions | Jan Wieck | 09:11 |
| Re: query optimazation & starting postmaster with -B option | Mitch Vincent | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Is there any way to speed up PL/TCL functions? | Robert B. Easter | 05:15 |
| Re: Is there any way to speed up PL/TCL functions? | Tom Lane | 06:04 |
| Alter table with arrays | igor | 13:54 |
| altering column constraints 📎 | Kyle | 16:30 |
| Re: Alter table with arrays | Tom Lane | 16:41 |
| TCL updates 📎 | Kyle | 17:00 |
| Select by priority again 📎 | Bernie Huang | 18:20 |
| Re: Select by priority again | D'Arcy J.M. Cain | 19:20 |
| Re: Select by priority again 📎 | Bernie Huang | 21:15 |
| RULES on PostgreSQL | Jesus Aneiros | 22:25 |
| Re: password encryption | Aaron Sethman | 22:37 |
| Re: TCL updates | Jan Wieck | 22:47 |
| Views on Unions | Zot O'Connor | 23:09 |
| Thread | Author | Time |
|---|---|---|
| [Fwd: inserting integer in Table] | Thomas SMETS | 02:02 |
| command in C++ | Jerome Raupach | 16:28 |
| RE: primary key question | Pablo Niklas | 16:37 |
| Re: command in C | Michael Richards | 18:13 |
| pg_dump | sathya priya | 22:14 |
| Index selection on a large table | Michael Richards | 23:03 |
| Re: pg_dump | Tom Lane | 23:05 |
| Re: [SQL] Index selection on a large table | Tom Lane | 23:30 |
| Change attribute of a column 📎 | Bernie Huang | 23:34 |
| Thread | Author | Time |
|---|---|---|
| Exec query | Jerome Raupach | 10:55 |
| Re: Change attribute of a column | Volker Paul | 12:01 |
| optimize sql | pgsql-sql | 14:11 |
| Re: optimize sql | Ross J. Reedstrom | 15:51 |
| Thread | Author | Time |
|---|---|---|
| Re(2): optimize sql | pgsql-sql | 02:40 |
| Classes, Inheritance, and Children | Thomas Swan | 07:06 |
| Large text insertion | Vladimir Terziev | 08:30 |
| Re: Classes, Inheritance, and Children | Oliver Elphick | 09:01 |
| Re: Large text insertion | Jan Wieck | 09:39 |
| Antw: Re: Large text insertion | Gerhard Dieringer | 11:20 |
| RE: Re(2): optimize sql | Henry Lafleur | 13:15 |
| Compile | Jerome Raupach | 13:48 |
| Aggregates and Primary Keys | Itai Zukerman | 14:00 |
| Conditional rule? | André Næss | 14:43 |
| Re: Conditional rule? | Itai Zukerman | 15:05 |
| Automatic Deletes? | Itai Zukerman | 15:12 |
| Re: Conditional rule? | Tom Lane | 15:36 |
| Re: Conditional rule? | André Næss | 17:21 |
| Re: Conditional rule? | André Næss | 18:01 |
| Re: Conditional rule? | Robert B. Easter | 18:55 |
| Re: Conditional rule? | Robert B. Easter | 19:06 |