Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Is it possible to redirect an update/insert/delete to a different table? | Andy Ballingall | 15:40 |
| Re: Is it possible to redirect an update/insert/delete to a different table? | Andreas Kretschmer | 16:17 |
| Re: Is it possible to redirect an update/insert/delete to a different table? | Andy Ballingall | 16:37 |
| Re: Is it possible to redirect an update/insert/delete to a different table? | Andreas Kretschmer | 16:42 |
| Re: Is it possible to redirect an update/insert/delete to a different table? | Andreas Kretschmer | 17:01 |
| Re: Is it possible to redirect an update/insert/delete to a different table? | Andy Ballingall | 17:15 |
| Please help to wite the constraint. | Grigory O. Ptashko | 19:32 |
| Re: Is it possible to redirect an update/insert/delete to a different table? | Adrian Klaver | 23:35 |
| Thread | Author | Time |
|---|---|---|
| max() unexpected type conversion | Hélder M. Vieira | 12:47 |
| Re: max() unexpected type conversion | Tom Lane | 15:03 |
| Re: A Not Join | stig erikson | 20:16 |
| tid_le comparison for tuple id (ctid) values? | george young | 21:00 |
| Re: tid_le comparison for tuple id (ctid) values? | Tom Lane | 21:19 |
| Storing HTML in table | Rob | 21:47 |
| Thread | Author | Time |
|---|---|---|
| argument type problem with plpgsql function | Luca Pireddu | 00:08 |
| Re: argument type problem with plpgsql function | Stephan Szabo | 00:13 |
| Re: argument type problem with plpgsql function | Luca Pireddu | 02:22 |
| Re: argument type problem with plpgsql function | Tom Lane | 03:24 |
| Re: argument type problem with plpgsql function | Luca Pireddu | 05:41 |
| Re: Triggers | Achilleus Mantzios | 08:44 |
| Default on update | lucas | 11:43 |
| what is going on in the PostgreSQL | Eugene E. | 11:54 |
| Re: Default on update | Richard Huxton | 12:22 |
| Re: Default on update | lucas | 13:56 |
| OUT OF THIS LIST...... | Fernando Garcia | 14:07 |
| Re: Default on update | Richard Huxton | 14:08 |
| sysid | A. R. Van Hook | 14:26 |
| Drop functions | Wim Audenaert | 15:21 |
| Re: sysid | Alvaro Herrera | 15:45 |
| Re: sysid | Jaime Casanova | 15:52 |
| Re: unplanned sub-select error? | Tom Lane | 17:23 |
| Re: what is going on in the PostgreSQL | Michael Fuhr | 18:09 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Ken Winter | 04:23 |
| Index wonder | Leif B. Kristensen | 11:16 |
| Re: | Oliver Elphick | 13:57 |
| Re: | Achilleus Mantzios | 15:18 |
| does indexes need statistics? | Mauricio Fernandez A. | 18:43 |
| Changing auth type in pg_hba.conf ineffective. Why? | Bryce Nesbitt | 21:18 |
| Updatable views: any decent front-ends? | Bath, David | 22:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Changing auth type in pg_hba.conf ineffective. Why? | Alvaro Herrera | 02:32 |
| Re: Changing auth type in pg_hba.conf ineffective. Why? | Tom Lane | 02:41 |
| Re: Changing auth type in pg_hba.conf ineffective. Why? | Bryce Nesbitt | 06:35 |
| Re: Changing auth type in pg_hba.conf ineffective. Why? | Bryce Nesbitt | 07:01 |
| Re: does indexes need statistics? | Andrew Sullivan | 12:37 |
| LISTEN/NOTIFY | Stéphane RIFF | 14:31 |
| Re: Updatable views: any decent front-ends? | Thomas Kellerer | 15:54 |
| Re: LISTEN/NOTIFY | Stéphane RIFF | 16:24 |
| Order of precedence between AND and OR. | David Pradier | 16:52 |
| Variable column names in PL/pgSQL RECORD referencces | Ken Winter | 18:01 |
| Re: Variable column names in PL/pgSQL RECORD referencces | Tom Lane | 19:22 |
| Re: Order of precedence between AND and OR. | Tom Lane | 19:59 |
| Thread | Author | Time |
|---|---|---|
| Re: sysid | Vivek Khera | 03:22 |
| How to change database owner in PostgreSQL 7.4? | frank church | 12:16 |
| Re: How to change database owner in PostgreSQL 7.4? | Andreas Kretschmer | 12:25 |
| MAX, MIN and arrays | Colton A Smith | 17:18 |
| Thread | Author | Time |
|---|---|---|
| Re: MAX, MIN and arrays | Andreas Kretschmer | 08:50 |
| Re: Storing HTML in table | Greg Stark | 20:33 |
| Thread | Author | Time |
|---|---|---|
| Anual Query | Mauricio Fernandez A. | 16:20 |
| Re: Anual Query | Frank Bax | 18:06 |
| DEFAULT Constraint based on table type? | Announce | 20:22 |
| Re: DEFAULT Constraint based on table type? | Rod Taylor | 21:57 |
| Re: DEFAULT Constraint based on table type? | Jaime Casanova | 22:14 |
| Thread | Author | Time |
|---|---|---|
| Re: join if all matches | Bruno Wolff III | 05:05 |
| Re: DEFAULT Constraint based on table type? | Oliver Elphick | 10:31 |
| Re: DEFAULT Constraint based on table type? | Oliver Elphick | 10:33 |
| Re: How to change database owner in PostgreSQL 7.4? | frank church | 10:43 |
| Strange bug | Leif B. Kristensen | 14:31 |
| Re: Strange bug | Tom Lane | 14:37 |
| Re: Strange bug | A. Kretschmer | 14:43 |
| Re: Strange bug | Leif B. Kristensen | 14:52 |
| Re: Strange bug | Leif B. Kristensen | 14:57 |
| Re: Strange bug | Leif B. Kristensen | 16:01 |
| 'AS' in 'DELETE/UPDATE' | engineer | 16:01 |
| Re: 'AS' in 'DELETE/UPDATE' | Bruce Momjian | 16:13 |
| Re: 'AS' in 'DELETE/UPDATE' | Jaime Casanova | 16:14 |
| Re: Strange bug | Leif B. Kristensen | 16:47 |
| Re: Triggers | Jan Wieck | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Help needed | NosyMan | 09:18 |
| Re: Help needed | Richard Huxton | 10:35 |
| Archives site down? | Neil Saunders | 12:57 |
| Re: Archives site down? | Martín Marqués | 13:16 |
| Re: [SQL] Archives site down? | Alvaro Herrera | 13:18 |
| Re: problems with array | george young | 17:58 |
| child fk problem | Luis Silva | 18:42 |
| quote_literal() fails with unmatched quotes | James M Doherty | 20:32 |
| Re: quote_literal() fails with unmatched quotes | Tom Lane | 21:04 |
| Quote_literal() | James M Doherty | 21:20 |
| Re: quote_literal() fails with unmatched quotes | James M Doherty | 21:22 |
| Re: child fk problem | Scott Marlowe | 21:23 |
| Re: Quote_literal() | Tom Lane | 22:27 |
| Thread | Author | Time |
|---|---|---|
| APPEND INTO? | Mark Fenbers | 14:23 |
| Re: APPEND INTO? | Jaime Casanova | 15:32 |
| Re: APPEND INTO? | Tom Lane | 15:32 |
| Thread | Author | Time |
|---|---|---|
| Sybase Connection_Property('number') equivalent in PostGre ? | Emil Rachovsky | 09:04 |
| Re: Sybase Connection_Property('number') equivalent in PostGre | Achilleus Mantzios | 10:36 |
| Just 1 in a series... | Mark Fenbers | 17:15 |
| Re: Just 1 in a series... | Tom Lane | 17:20 |
| Re: Just 1 in a series... | Mark Fenbers | 17:44 |
| rename idx's with table; avoid confusing idx names? | george young | 18:00 |
| Re: rename idx's with table; avoid confusing idx names? | Tom Lane | 22:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Quote_literal() | James M Doherty | 13:57 |
| question using 'between' in a sql query | Theodore Petrosky | 17:54 |
| Re: question using 'between' in a sql query | Michael Fuhr | 18:15 |
| Thread | Author | Time |
|---|---|---|
| SQL Statement Help needed 📎 | Michael Avila | 12:31 |
| Re: SQL Statement Help needed | Andreas Kretschmer | 13:36 |
| Re: question using 'between' in a sql query | Theodore Petrosky | 16:28 |
| How to get a count() where column < ''? | Joost Kraaijeveld | 21:12 |
| Re: How to get a count() where column < ''? | Stephan Szabo | 21:33 |
| Re: How to get a count() where column < ''? | Joost Kraaijeveld | 21:43 |
| Re: How to get a count() where column < ''? | Jim Johannsen | 22:17 |
| Re: How to get a count() where column < ''? | Stephan Szabo | 22:29 |
| Re: How to get a count() where column < ''? | Joost Kraaijeveld | 22:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Just 1 in a series... | Patrick JACQUOT | 10:43 |
| Database query: Notification about change? | Erik Sigra | 18:22 |
| Preventing or controlling runaway queries | Eric E | 19:02 |
| Database with "override" tables | Michael Burke | 19:06 |
| Re: Preventing or controlling runaway queries | Tom Lane | 19:35 |
| Re: Preventing or controlling runaway queries | Eric E | 20:12 |
| Re: Database query: Notification about change? | Bruno Wolff III | 20:40 |
| Re: Preventing or controlling runaway queries | Tom Lane | 20:57 |
| Re: Preventing or controlling runaway queries | Eric E | 21:33 |
| Re: Database with "override" tables | Lane Van Ingen | 22:37 |
| update question | Matthew Peter | 22:59 |
| Re: update question | Jaime Casanova | 23:08 |
| Re: update question | Matthew Peter | 23:41 |
| Re: update question | Matthew Peter | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] lost in system tables | Emil Rachovsky | 07:26 |
| Re: [SQL] lost in system tables | Emil Rachovsky | 07:39 |
| Help on function creating | Alexandre Gonçalves Jacarandá | 12:26 |
| constrains problem... | Jure Kodzoman | 12:38 |
| Re: Database with "override" tables | Michael Burke | 14:11 |
| How to increase row deletion efficiency? | Alexander Stanier | 14:36 |
| Re: How to increase row deletion efficiency? | Tom Lane | 15:11 |
| Re: constrains problem... | Richard Huxton | 18:57 |
| Re: Help on function creating | Aaron Koning | 19:36 |
| Error from trigger | Leif B. Kristensen | 23:06 |
| Re: Error from trigger | Tom Lane | 23:23 |
| Re: Error from trigger | Leif B. Kristensen | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Locale and pattern matching | Hélder M. Vieira | 01:37 |
| dow question | Keith Worthington | 02:03 |
| Re: dow question | Michael Glaesemann | 03:17 |
| Re: dow question | Keith Worthington | 03:33 |
| Re: Error from trigger | Tom Lane | 04:11 |
| cannot alter column data type to "date" | Noel Doydora | 07:12 |
| Re: cannot alter column data type to "date" | Michael Fuhr | 07:21 |
| Re: Locale and pattern matching | Peter Eisentraut | 08:21 |
| Re: Help on function creating | Alexandre Gonçalves Jacarandá | 11:24 |