Discussion for users on SQL related matters.
| 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 |
| Re: function with a composite type calling another function - Mission Impossible? | Tom Lane | 15:43 |
| Re: function with a composite type calling another function - Mission Impossible? | Riccardo G. Facchini | 15:55 |
| Thread | Author | Time |
|---|---|---|
| Re: create function atof? | Yasir Malik | 02:16 |
| SQL DDL: FOREIGN KEY construct and field mapping: unexpected behavior | Neil Zanella | 08:19 |
| Re: postgresql multiple insert slow | Harald Fuchs | 11:39 |
| Re: SQL DDL: FOREIGN KEY construct and field mapping: unexpected behavior | Tom Lane | 22:37 |
| Re: Formatting problems with negative intervals, TO_CHAR | Tom Lane | 22:40 |
| Thread | Author | Time |
|---|---|---|
| Re: ERROR: duplicate key violates unique constraint (SOLVED) | Khairul Azmi | 03:22 |
| Re: sum ( time) problem | Willem de Jong | 06:09 |
| empty string casting to typed value | sad | 06:37 |
| Re: Formatting problems with negative intervals, TO_CHAR | Karel Zak | 07:52 |
| Re: Formatting problems with negative intervals, TO_CHAR | Stefan Weiss | 09:08 |
| Re: Formatting problems with negative intervals, TO_CHAR | Karel Zak | 09:46 |
| Re: empty string casting to typed value | Bruno Wolff III | 13:59 |
| Re: empty string casting to typed value | Stephan Szabo | 14:34 |
| Re: pl/pgsql and transaction locks | Marcus Whitney | 18:24 |
| Getting FK relationships from information_schema | Kyle | 23:57 |
| Thread | Author | Time |
|---|---|---|
| Cursor returned from procedure ignores setFetchSize() on CallableStatement | Brian G. Huber | 05:40 |
| Re: Getting FK relationships from information_schema | Tom Lane | 05:53 |
| Re: Getting FK relationships from information_schema | Kyle | 15:13 |
| Re: Query becoming slower on adding a primary key | Rajesh Kumar Mallah | 18:41 |
| Re: Trigger problem | Mike Rylander | 18:57 |
| Trigger problem | kasper | 19:38 |
| simple addition of constraints problem | Michelle Murrain | 21:51 |
| a query question | Jaime Casanova | 22:05 |
| Re: [SQL] simple addition of constraints problem | Richard Poole | 22:55 |
| Re: simple addition of constraints problem | Stephan Szabo | 23:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Getting FK relationships from information_schema | Tom Lane | 05:04 |
| Last insert id | mixo | 06:24 |
| Re: Getting FK relationships from information_schema | Peter Eisentraut | 06:36 |
| Re: Last insert id | mkl | 06:54 |
| Re: Last insert id | Richard Huxton | 07:22 |
| Re: returning a recordset from PLpg/SQL | Richard Huxton | 08:58 |
| Re: Triggers | Richard Huxton | 09:01 |
| Schema + User-Defined Data Type Indexing problems... | Chris Gamache | 16:41 |
| search and replace | Jodi Kanter | 17:30 |
| Re: Trigger problem | Stephan Szabo | 20:30 |
| Thread | Author | Time |
|---|---|---|
| (No Subject) | William Anthony Lim | 04:36 |
| Re: Query becoming slower on adding a primary key [ SOLVED | Rajesh Kumar Mallah | 04:59 |
| casting int to bit | sad | 07:32 |
| Re: Converting integer to binary | Stephen Quinney | 07:54 |
| Re: search and replace | Benoît BOURNON | 08:16 |
| Re: (No Subject) | Franco Bruno Borghesi | 14:02 |
| pg_dump inside function (was: Re: (No Subject)) | Martin Knipper | 14:23 |
| plpgsql - Insert from a record variable? | Phil Endecott | 14:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Datetime problem | Achilleus Mantzios | 13:34 |
| Datetime problem | Eric Lemes | 14:08 |
| Re: Datetime problem | Stef | 14:31 |
| Re: Datetime problem | Tom Lane | 14:56 |
| max value from join | hook | 16:02 |
| RES: Datetime problem | Eric Lemes | 16:20 |
| query with =ALL | Jaime Casanova | 16:49 |
| a query with = ALL | Jaime Casanova | 17:06 |
| Re: RES: Datetime problem | Alexander M. Pravking | 17:10 |
| Re: query with =ALL | Stephan Szabo | 17:38 |
| Re: query with =ALL | Richard Huxton | 17:48 |
| Re: query with =ALL | Jaime Casanova | 18:01 |
| Re: query with =ALL | Jaime Casanova | 18:06 |
| Re: max value from join | Richard Poole | 18:26 |
| Re: query with =ALL | Stephan Szabo | 18:26 |
| Re: RES: Datetime problem | Tom Lane | 18:47 |
| Re: a query with = ALL | Tom Lane | 18:51 |
| Re: RES: Datetime problem | Tom Lane | 19:02 |
| Re: query with =ALL | Jaime Casanova | 19:07 |
| Re: a query with = ALL | Jaime Casanova | 19:11 |
| Scalar subqueries | Subbiah, Stalin | 19:33 |
| Scalar subqueries | Subbiah, Stalin | 19:38 |
| Re: query with =ALL | Tom Lane | 19:41 |
| Re: query with =ALL | Jaime Casanova | 19:53 |
| Re: query with =ALL | Tom Lane | 19:55 |
| Re: query with =ALL | Jaime Casanova | 20:04 |
| Re: query with =ALL | Stephan Szabo | 20:07 |
| Re: Scalar subqueries | Richard Poole | 20:44 |
| Prepare Statement | Jie Liang | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Last insert id | Andrei Bintintan | 07:05 |
| Re: Last insert id | Rod Taylor | 10:30 |
| Number of rows effected | Pankaj Chugh | 12:28 |
| Re: [SQL] Prepare Statement | Jie Liang | 16:44 |
| Re: Prepare Statement | Kris Jurka | 18:00 |
| Is there a faster way to do this? | Patrick Hatcher | 18:55 |
| Re: Is there a faster way to do this? | Richard Huxton | 20:17 |
| Re: Is there a faster way to do this? | Edmund Bacon | 20:20 |
| Re: Is there a faster way to do this? | Jean-Luc Lachance | 20:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Last insert id | Michalis Kabrianis | 06:47 |
| Re: Your question in postgresql.org forum (Diff. between two times as a numeric value in a stored proc) | Stijn Vanroye | 07:27 |
| How to delete the not DISTINCT ON entries | Christoph Haller | 11:52 |
| Re: How to delete the not DISTINCT ON entries | Achilleus Mantzios | 12:18 |
| Re: How to delete the not DISTINCT ON entries | Jean-Luc Lachance | 14:14 |
| Inheritance, plpgsql inserting, and revisions | Phil Endecott | 15:12 |
| help with Postgres function | ctrl | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Prepare Statement | Jie Liang | 00:53 |
| Re: Is there a faster way to do this? | Greg Sabino Mullane | 03:03 |
| Re: Prepare Statement | Kris Jurka | 04:30 |
| use of a composite type in CREATE TABLE? | Hannes Korte | 11:01 |
| Re: Optimal query suggestion needed | Richard Huxton | 13:36 |
| Re: use of a composite type in CREATE TABLE? | Tom Lane | 13:37 |
| Optimal query suggestion needed | Interzone | 14:46 |
| Re: Optimal query suggestion needed | Bruno Wolff III | 17:54 |
| Re: Prepare Statement | Jie Liang | 18:18 |
| Re: Prepare Statement | Kris Jurka | 18:59 |
| Re: Optimal query suggestion needed | InterZone | 19:06 |
| Re: Optimal query suggestion needed | InterZone | 19:22 |
| Re: Optimal query suggestion needed | Bruno Wolff III | 20:01 |
| Re: Prepare Statement | Jie Liang | 20:54 |
| Re: Prepare Statement | Kris Jurka | 22:25 |
| Re: Prepare Statement | Jie Liang | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Prepare Statement | Jie Liang | 03:09 |
| Re: Prepare Statement | Kris Jurka | 05:47 |
| Re: Prepare Statement | Kris Jurka | 05:51 |
| Re: Prepare Statement | Jie Liang | 16:43 |
| Re: Prepare Statement | Jie Liang | 16:52 |
| In 7.4 ensure you have DEFAULT now () with no spaces | David B | 18:29 |
| case stement when null | Jaime Casanova | 21:38 |
| Re: Prepare Statement | Kris Jurka | 21:47 |
| Re: Prepare Statement | Kris Jurka | 21:47 |
| Re: Prepare Statement | Oliver Jowett | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: plpgsql - Insert from a record variable? | Riccardo G. Facchini | 06:03 |
| Re: case stement when null | Riccardo G. Facchini | 06:21 |
| Re: case stement when null | V i s h a l Kashyap @ [Sai Hertz And Control Systems] | 10:20 |
| Re: In 7.4 ensure you have DEFAULT now () with no spaces | Peter Eisentraut | 12:25 |
| Re: plpgsql - Insert from a record variable? | Tom Lane | 18:39 |
| Re: In 7.4 ensure you have DEFAULT now () with no spaces | Tom Lane | 18:50 |
| Thread | Author | Time |
|---|---|---|
| pivot-like transformation | Torsten Lange | 19:44 |
| question about which column(s) are the right foreign key | Markus Bertheau | 21:22 |
| Re: pivot-like transformation | Joe Conway | 22:15 |
| Thread | Author | Time |
|---|---|---|
| Re: use of a composite type in CREATE TABLE? | Josh Berkus | 04:48 |
| Re: question about which column(s) are the right foreign key | Josh Berkus | 04:57 |