Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Subselect returning 2 columns | Tom Lane | 01:26 |
| Re: SUM() & GROUP BY | Martin Kuria | 06:47 |
| Re: SUM() & GROUP BY | Richard Huxton | 08:00 |
| EXPORT / IMPORT | Freddy Villalba Arias | 08:20 |
| Re: EXPORT / IMPORT | Jerome Alet | 08:38 |
| Display format for column | Abdul Wahab Dahalan | 09:08 |
| Re: Display format for column | Karel Zak | 09:58 |
| Re: EXPORT / IMPORT | Andrew Sullivan | 11:16 |
| Re: not really SQL but I need info on BLOBs | Jeff Boes | 11:29 |
| Re: SUM() & GROUP BY | Martin Kuria | 11:32 |
| SELECT - ORDER BY Croatian characters .... | Kornelije | 11:51 |
| Re: SUM() & GROUP BY | Richard Huxton | 13:25 |
| Re: COUNT on a DISTINCT query | Suller András | 14:19 |
| Re: SUM() & GROUP BY | Jean-Luc Lachance | 17:31 |
| Re: SELECT - ORDER BY Croatian characters .... | Peter Eisentraut | 18:39 |
| \df | Jie Liang | 23:15 |
| Re: \df | Yasir Malik | 23:29 |
| Re: \df | Stefan Weiss | 23:39 |
| Re: \df | Jie Liang | 23:47 |
| Re: CONTEXT on PL/pgSQL | Gaetano Mendola | 23:50 |
| Thread | Author | Time |
|---|---|---|
| Re: SELECT - ORDER BY Croatian characters .... | Kornelije Rabuzin | 09:54 |
| Re: techniques for manual ordering of data ? | Bruno Wolff III | 16:36 |
| Adding MERGE to the TODO list (resend with subject) | elein | 21:37 |
| Re: Adding MERGE to the TODO list (resend with subject) | Bruce Momjian | 22:46 |
| Re: Adding MERGE to the TODO list (resend with subject) | elein | 23:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding MERGE to the TODO list (resend with subject) | Christopher Kings-Lynne | 01:50 |
| Re: Adding MERGE to the TODO list (resend with subject) | Alvaro Herrera | 03:54 |
| Re: Adding MERGE to the TODO list (resend with subject) | Christopher Kings-Lynne | 04:13 |
| Re: Adding MERGE to the TODO list (resend with subject) | Alvaro Herrera | 05:18 |
| Re: Adding MERGE to the TODO list (resend with subject) | Christopher Kings-Lynne | 05:32 |
| Re: not really SQL but I need info on BLOBs | Denis Braekhus | 12:43 |
| Re: Adding MERGE to the TODO list (resend with subject) | Alvaro Herrera | 16:09 |
| Thread | Author | Time |
|---|---|---|
| Trigger function to know which fields are being updated | Bernard Cheung | 02:47 |
| Re: Adding MERGE to the TODO list (resend with subject) | Bruce Momjian | 03:58 |
| working with schema | William Anthony Lim | 08:10 |
| Re: not really SQL but I need info on BLOBs | Theodore Petrosky | 11:41 |
| Re: working with schema | Christoph Haller | 12:49 |
| Exceptions when 0 rows affected. | Stef | 13:08 |
| Re: Adding MERGE to the TODO list (resend with subject) | Bricklen | 14:11 |
| Re: Adding MERGE to the TODO list (resend with subject) | Hannu Krosing | 21:23 |
| Re: Adding MERGE to the TODO list (resend with subject) | Bruce Momjian | 21:26 |
| Re: Trigger function to know which fields are being updated | Jeff Eckermann | 21:38 |
| Re: update table where rows are selected by inner join? | Stephan Szabo | 22:09 |
| update table where rows are selected by inner join? | Jeff Kowalczyk | 22:13 |
| Thread | Author | Time |
|---|---|---|
| Subqueries returning more than one value? | Adam Witney | 00:09 |
| Re: Subqueries returning more than one value? | CoL | 01:43 |
| Re: Exceptions when 0 rows affected. | Andrei Bintintan | 06:02 |
| Re: Adding MERGE to the TODO list (resend with subject) | Hannu Krosing | 06:59 |
| Re: Trigger function to know which fields are being updated | Bernard Cheung | 07:09 |
| Re: Trigger function to know which fields are being updated | Riccardo Facchini | 07:46 |
| Seconds To Time | Willem de Jong | 08:08 |
| Re: Adding MERGE to the TODO list (resend with subject) | Bruce Momjian | 13:44 |
| Re: Trigger function to know which fields are being updated | Jeff Eckermann | 13:59 |
| Re: Adding MERGE to the TODO list (resend with subject) | Bruce Momjian | 20:23 |
| \set | Jie Liang | 23:07 |
| Thread | Author | Time |
|---|---|---|
| view problem - too many rows out | Gary Stainburn | 10:02 |
| Re: [SQL] \set | Christian Kratzer | 10:13 |
| Re: working with schema | William Anthony Lim | 10:19 |
| How do i extract a certain bit from a bigint column 📎 | Mats Sjöberg | 11:05 |
| Re: How do i extract a certain bit from a bigint column | Mike Rylander | 12:17 |
| Re: How do i extract a certain bit from a bigint column | Tom Lane | 12:55 |
| Re: working with schema | scott.marlowe | 13:59 |
| solved Re: view problem - too many rows out | Gary Stainburn | 14:06 |
| where is this problem (trigger) | Theodore Petrosky | 17:57 |
| Re: How do i extract a certain bit from a bigint column | Bruno Wolff III | 18:16 |
| Re: [SQL] \set | Jie Liang | 21:59 |
| Re: [SQL] \set | Tom Lane | 23:05 |
| Re: [SQL] \set | Jie Liang | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Re: working with schema | William Anthony Lim | 05:25 |
| Re: a wierd query | Achilleus Mantzios | 07:34 |
| Re: a wierd query | sad | 07:34 |
| a wierd query | [email protected] | 08:07 |
| Re: a wierd query | Silke Trißl | 08:41 |
| Re: a wierd query | Peter Childs | 09:17 |
| Re: a wierd query | Yasir Malik | 13:24 |
| Re: Exceptions when 0 rows affected. | Stef | 14:49 |
| Re: a wierd query | Edmund Bacon | 15:27 |
| isolation level | Jaime Casanova | 18:13 |
| Re: isolation level | Bruno Wolff III | 18:24 |
| \d in 7.4.2 | Jaime Casanova | 21:15 |
| Ignore my last message | Jaime Casanova | 21:18 |
| \d in 7.4 | Jaime Casanova | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: a wierd query | sad | 03:45 |
| Re: a wierd query | Stephan Szabo | 05:24 |
| Re: isolation level | Greg Stark | 05:26 |
| Re: Multiple outer join on same table | Greg Stark | 05:40 |
| Re: where is this problem (trigger) | Stephan Szabo | 15:06 |
| Re: where is this problem (trigger) | Christoph Haller | 16:44 |
| view running query | Eric Anderson Vianet SAO | 17:17 |
| Re: [HACKERS] MERGE-esque Functionallity (was: Adding MERGE to the TODO list (resend with subject)) 📎 | Mike Rylander | 18:04 |
| Thread | Author | Time |
|---|---|---|
| Re: where is this problem (trigger) | Theodore Petrosky | 13:42 |
| Re: where is this problem (trigger) | Jean-Luc Lachance | 14:27 |
| Re: where is this problem (trigger) | Theodore Petrosky | 14:28 |
| Thread | Author | Time |
|---|---|---|
| Re: How to speed up a time dimension query | Gaetano Mendola | 11:42 |
| Thread | Author | Time |
|---|---|---|
| Re: a wierd query | sad | 07:12 |
| Re: a wierd query | Stijn Vanroye | 07:25 |
| Re: a wierd query | Stijn Vanroye | 07:31 |
| problem with spanish characters | Freddy Villalba Arias | 08:02 |
| Re: a wierd query | Stijn Vanroye | 09:24 |
| Re: [JDBC] problem with spanish characters | nahum castro | 14:05 |
| Re: view running query | Andrew Hammond | 14:32 |
| Replace function ... | Kornelije | 14:58 |
| Re: a wierd query | Stephan Szabo | 15:01 |
| Max Columns in a SQL Select | PS PS | 16:37 |
| Re: Unique Constraint with foreign Key | Karsten Hilbert | 16:51 |
| Re: Max Columns in a SQL Select | Richard Huxton | 18:06 |
| Re: Replace function ... | Yasir Malik | 19:34 |
| Thread | Author | Time |
|---|---|---|
| Re: a wierd query | Stijn Vanroye | 07:56 |
| Any sql repository | T Ullas | 08:26 |
| Opening and Fetching from a refcursor inside a function | kumar | 12:18 |
| Very slow search using basic pattern matching | Dan Field | 15:47 |
| Re: Very slow search using basic pattern matching | Bruno Wolff III | 16:12 |
| I'm baffled | hook | 16:19 |
| Re: How to speed up a time dimension query | Hans de Bruin | 16:56 |
| Re: Very slow search using basic pattern matching | Karsten Hilbert | 17:15 |
| Re: I'M Sorry! | Ricardo Maia | 18:30 |
| Using "Without OIDs" | Richard Huxton | 18:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Replace function ... | Benoît BOURNON | 10:24 |
| Re: a wierd query | Christoph Haller | 10:55 |
| Re: Very slow search using basic pattern matching | Dan Field | 11:33 |
| Re: Very slow search using basic pattern matching | Raphael A. Bauer | 11:51 |
| Preventing Deletions with triggers | Jeff Post | 14:19 |
| Function valid only for one table | Martin Knipper | 14:42 |
| Re: Function valid only for one table | Richard Huxton | 16:33 |
| SCHEMA's the easy way? | Chris Gamache | 16:38 |
| Re: SCHEMA's the easy way? | Tom Lane | 17:00 |
| Re: Function valid only for one table | Martin Knipper | 17:09 |
| rules | Jie Liang | 17:20 |
| Re: Replace function ... | Kornelije Rabuzin | 17:30 |
| Re: Replace function ... | Kornelije Rabuzin | 17:31 |
| Re: Function valid only for one table | Tom Lane | 17:33 |
| Re: Function valid only for one table | Martin Knipper | 17:41 |
| Re: rules | Jie Liang | 17:41 |
| Re: [SQL] rules | Stephan Szabo | 17:50 |
| Thread | Author | Time |
|---|---|---|
| where to start with this procedure ? | Andreas | 00:33 |
| Re: where to start with this procedure ? | Andrei Bintintan | 07:17 |
| Re: where to start with this procedure ? | Andreas | 14:46 |
| Re: where to start with this procedure ? | Stephan Szabo | 15:01 |
| XML data field | LSanchez | 15:58 |
| OR clause causing strange index performance | Doug Y | 17:32 |
| Simple view confuses PostgreSQL query planning | Manuel Sugawara | 17:33 |
| Re: OR clause causing strange index performance | Doug Y | 17:46 |
| v7.2 triggers and foreign keys | Paul Gimpelj | 18:32 |
| Re: Simple view confuses PostgreSQL query planning | Tom Lane | 19:06 |
| Re: Simple view confuses PostgreSQL query planning | Manuel Sugawara | 21:43 |
| Thread | Author | Time |
|---|---|---|
| Re: OR clause causing strange index performance | Tom Lane | 06:53 |
| Problem with JOINS | Charlie Clark | 07:28 |
| Re: v7.2 triggers and foreign keys | Richard Huxton | 08:11 |
| Re: Preventing Deletions with triggers | Achilleus Mantzios | 08:30 |
| Re: XML data field | Richard Huxton | 10:36 |
| Re: Problem with JOINS | Stephan Szabo | 14:17 |
| Re: Preventing Deletions with triggers | Manuel Sugawara | 15:01 |
| Re: Problem with JOINS | Tom Lane | 15:05 |
| Re: Preventing Deletions with triggers | Tom Lane | 15:28 |
| Thread | Author | Time |
|---|---|---|
| Memory usage on subselect | Alexander M. Pravking | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Memory usage on subselect | Tom Lane | 16:28 |
| Re: Memory usage on subselect | Alexander M. Pravking | 18:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Memory usage on subselect | Dan Field | 08:53 |
| Re: Memory usage on subselect | Tom Lane | 13:37 |
| Thread | Author | Time |
|---|---|---|
| Multitable uniqueness ? | Andreas | 03:13 |
| trigger function building | hook | 11:42 |
| Re: Multitable uniqueness ? | Bruno Wolff III | 12:20 |
| Re: Multitable uniqueness ? | Jan Wieck | 13:56 |
| Re: Multitable uniqueness ? | Jean-Luc Lachance | 14:00 |
| Re: trigger function building | Manuel Sugawara | 15:20 |
| Re: Memory usage on subselect | Dan Field | 15:51 |
| Re: Memory usage on subselect | Gaetano Mendola | 16:29 |
| Thread | Author | Time |
|---|---|---|
| Re: The PostgreSQL | sad | 03:56 |
| Re: Multitable uniqueness ? | Andreas | 07:07 |
| Re: Multitable uniqueness ? | Andreas | 07:22 |
| Re: sum ( time) problem | Willem de Jong | 11:14 |
| Re: Multitable uniqueness ? | Jean-Luc Lachance | 13:08 |
| PostgreSQL is hanging up !? | Louie Kwan | 20:43 |
| Thread | Author | Time |
|---|---|---|
| type regclass casting | sad | 09:29 |
| insert or update violates foreign key constraint.why? | Oleg Mayevskiy | 13:49 |
| Re: OR clause causing strange index performance | Atesz | 15:37 |
| Re: not really SQL but I need info on BLOBs | Jared Evans | 16:40 |
| About intervals | Pablo Velasquez Rivas | 18:27 |
| Re: About intervals | Bruno Wolff III | 21:23 |
| Thread | Author | Time |
|---|---|---|
| multi results with functions | kasper | 22:02 |
| Re: multi results with functions | CoL | 22:13 |
| Thread | Author | Time |
|---|---|---|
| passing new/old record in pl/pgsql trigger functions to other functions | basic | 05:51 |
| Re: passing new/old record in pl/pgsql trigger functions to other functions | Tom Lane | 06:14 |
| type regclass casting | sad | 07:52 |
| joining a table with a function | Jaime Casanova | 14:19 |
| Thread | Author | Time |
|---|---|---|
| Re: insert or update violates foreign key constraint.why? | Tom Lane | 02:05 |
| assistance on self join pls | email lists | 12:29 |
| Schemata & User-Defined-Type casting issues | Chris Gamache | 14:00 |
| Re: sum ( time) problem | Bruno Wolff III | 14:03 |
| Re: Schemata & User-Defined-Type casting issues | Tom Lane | 14:25 |
| Query becoming slower on adding a primary key | mallah | 19:21 |
| Re: Query becoming slower on adding a primary key | Tom Lane | 21:36 |
| Thread | Author | Time |
|---|---|---|
| most efficient way to manage ordering | Matthew Nuzum | 02:35 |
| Re: most efficient way to manage ordering | Rod Taylor | 03:10 |
| Re: Query becoming slower on adding a primary key | Rajesh Kumar Mallah | 08:50 |
| UNIQUE columnt depdening on other column??? | Andrei Bintintan | 11:39 |
| Re: UNIQUE columnt depdening on other column??? | Richard Huxton | 12:21 |
| Re: UNIQUE columnt depdening on other column??? | Reinoud van Leeuwen | 12:43 |
| Re: assistance on self join pls | Rajesh Kumar Mallah | 13:48 |
| function with a composite type calling another function - Mission Impossible? | Riccardo G. Facchini | 14:52 |