Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: currval() without specifying the sequence name | ow | 14:53 |
| Re: Trying to make efficient "all vendors who can provide all items" | Michael Glaesemann | 14:58 |
| Re: currval() without specifying the sequence name | Achilleus Mantzios | 15:09 |
| Re: currval() without specifying the sequence name | Richard Huxton | 15:14 |
| Re: Dramatic slowdown of sql when placed in a function | Jeff Boes | 15:17 |
| Re: currval() without specifying the sequence name | Tom Lane | 16:10 |
| Re: currval() without specifying the sequence name | ow | 16:36 |
| Re: Help to simplify sample query | Daniel Henrique Alves Lima | 20:13 |
| Re: Help to simplify sample query | Bruno Wolff III | 20:18 |
| Re: bytea or blobs? | Richard Huxton | 21:02 |
| Re: Dramatic slowdown of sql when placed in a function | Mike Moran | 21:21 |
| correlated multi-set update? | Marty Scholes | 21:48 |
| Converting query to view - duplicate fields | Richard Grosse | 22:40 |
| Re: correlated multi-set update? | Stephan Szabo | 23:14 |
| Thread | Author | Time |
|---|---|---|
| Re: designer tool connect to PostgreSQL | azwa | 01:51 |
| Re: randomized order in select? | Iain | 05:31 |
| Re: randomized order in select? | Tom Lane | 06:40 |
| Re: Tsearch2 question: getting histogram of the vector elements | Oleg Bartunov | 09:01 |
| Re: About pg_dump | Rute Solipa | 15:01 |
| Re: Tsearch2 question: getting histogram of the vector elements | George Essig | 15:56 |
| Re: About pg_dump | Tom Lane | 16:03 |
| Re: Tsearch2 question: getting histogram of the vector elements | mallah | 16:03 |
| Re: Break a report in Run Time | Jonathan M. Gardner | 16:22 |
| Re: randomized order in select? | scott.marlowe | 16:28 |
| Re: designer tool connect to PostgreSQL | scott.marlowe | 17:14 |
| trace facility | beyaNet Consultancy | 17:39 |
| Re: Break a report in Run Time | Jonathan Gardner | 20:14 |
| Re: About pg_dump | Daniel Henrique Alves Lima | 21:13 |
| IMPORT TOOL | Louie Kwan | 21:17 |
| Problems with tsearch2: ERROR: datumGetSize: Invalid typLen 0 | postgres | 21:58 |
| Re: IMPORT TOOL | Chris Browne | 22:14 |
| Thread | Author | Time |
|---|---|---|
| sqlloader features | azwa | 09:05 |
| where not unique | Gary Stainburn | 13:02 |
| Re: where not unique | Daniel Henrique Alves Lima | 13:54 |
| Re: where not unique | Paul Thomas | 13:57 |
| Re: where not unique | Daniel Henrique Alves Lima | 14:05 |
| SQL query --- big question??? | Andrei Bintintan | 14:36 |
| Re: sqlloader features | Jeff Eckermann | 14:55 |
| Re: SQL query --- big question??? | Richard Huxton | 15:20 |
| pg_dump backwards compat issues | tomg | 19:58 |
| Thread | Author | Time |
|---|---|---|
| function returning resultset | William Anthony Lim | 02:47 |
| Object-relational features | Yasir Malik | 17:30 |
| Thread | Author | Time |
|---|---|---|
| Invalid Characters | Raman | 10:37 |
| Re: Invalid Characters | Paul Thomas | 11:42 |
| Re: Object-relational features | John DeSoi | 13:28 |
| Re: Object-relational features | Yasir Malik | 14:06 |
| Re: Object-relational features | Bruno Wolff III | 15:07 |
| Re: Object-relational features | Stephan Szabo | 15:13 |
| Thread | Author | Time |
|---|---|---|
| Line length in pl/pgsql function | David Olbersen | 00:47 |
| Re: Line length in pl/pgsql function | Tom Lane | 05:35 |
| Re: Line length in pl/pgsql function | Richard Huxton | 09:27 |
| Re: working with unix timestamp | Gary Stainburn | 11:17 |
| Re: Line length in pl/pgsql function 📎 | David Olbersen | 19:50 |
| Re: Line length in pl/pgsql function | David Olbersen | 19:52 |
| Re: Line length in pl/pgsql function | Tom Lane | 20:03 |
| Re: Line length in pl/pgsql function | David Olbersen | 20:07 |
| Re: Line length in pl/pgsql function | David Olbersen | 20:37 |
| Thread | Author | Time |
|---|---|---|
| Date format issue | Raman | 05:37 |
| Re: Date format issue | Stephan Szabo | 05:58 |
| perfomance question | sad | 06:41 |
| Re: Date format issue | Tom Lane | 15:55 |
| Re: perfomance question | Josh Berkus | 18:38 |
| Thread | Author | Time |
|---|---|---|
| Re: perfomance question | sad | 06:27 |
| Re: perfomance question | Adam Ruth | 07:14 |
| inverse of "day of year" | Martin Marques | 12:06 |
| psql: FATAL 1: IDENT authentication failed for user error - Urgent pls | Kumar | 12:39 |
| triggers on commit | Erik Thiele | 13:04 |
| Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls | Martin Marques | 13:05 |
| Re: inverse of "day of year" | Robert Creager | 13:47 |
| Re: psql: FATAL 1: IDENT authentication failed for user error | Devrim GUNDUZ | 14:23 |
| Re: inverse of "day of year" | Tom Lane | 15:10 |
| Re: psql: FATAL 1: IDENT authentication failed for user error - Urgent pls | Tom Lane | 15:12 |
| Re: triggers on commit | Tom Lane | 15:13 |
| CREATE TABLE LIKE question | Robert Creager | 15:26 |
| Re: triggers on commit | Erik Thiele | 15:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Import from Ms Excel | Hans de Bruin | 16:25 |
| Thread | Author | Time |
|---|---|---|
| special integrity constraints | Erik Thiele | 09:20 |
| Re: special integrity constraints | Achilleus Mantzios | 10:13 |
| Re: special integrity constraints | Erik Thiele | 10:26 |
| Re: special integrity constraints | Bruno Wolff III | 11:26 |
| Re: inverse of "day of year" | Martin Marques | 11:32 |
| Re: special integrity constraints | Achilleus Mantzios | 11:40 |
| Re: inverse of "day of year" | Bruno Wolff III | 12:50 |
| Re: special integrity constraints | Erik Thiele | 13:10 |
| Re: inverse of "day of year" | Martin Marques | 13:14 |
| Re: special integrity constraints | Stephan Szabo | 14:21 |
| Re: special integrity constraints | Bruno Wolff III | 15:12 |
| Re: inverse of "day of year" | Bruno Wolff III | 15:18 |
| Re: inverse of "day of year" | Dana Hudes | 15:56 |
| Re: special integrity constraints | Erik Thiele | 16:21 |
| Re: special integrity constraints | Erik Thiele | 16:25 |
| Re: special integrity constraints | Stephan Szabo | 16:34 |
| Thread | Author | Time |
|---|---|---|
| Re: function definition documentation | Gregory S. Williamson | 00:04 |
| Invalid Unicode Character Sequence found | Bulatovic Natasa | 12:24 |
| Thread | Author | Time |
|---|---|---|
| order of results | Gregor Rot | 13:23 |
| Using Bounding Box as a where predicate | Okeh, Sam | 19:21 |
| Thread | Author | Time |
|---|---|---|
| how to turn off autocommit in psql | Kemin Zhou | 01:25 |
| Re: how to turn off autocommit in psql | Paul Thomas | 08:59 |
| date_part stored procs | Tsoloane Moahloli | 14:19 |
| Re: Newbie Query question | Rod Taylor | 14:49 |
| autocommit | Kemin Zhou | 19:31 |
| Re: Invalid Unicode Character Sequence found | Tom Lane | 21:43 |
| Re: order of results | Bruno Wolff III | 21:53 |
| Re: date_part stored procs | Tom Lane | 23:03 |
| Thread | Author | Time |
|---|---|---|
| Re: autocommit | Tom Lane | 03:23 |
| Re: Invalid Unicode Character Sequence found | Markus Bertheau | 10:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow sub-selects, max and count(*) | Greg Stark | 06:31 |
| Thread | Author | Time |
|---|---|---|
| Re: date_part stored procs | Tsoloane Moahloli | 07:30 |
| Re: Invalid Unicode Character Sequence found | Bulatovic Natasa | 07:33 |
| Question on pgsql trigger | Jon Poulton | 17:12 |
| Re: Slow sub-selects, max and count(*) | Josh Berkus | 21:47 |
| Thread | Author | Time |
|---|---|---|
| Entered data appears TWICE in table!!? | Ron M. | 19:29 |
| plpgsql vs. SQL in stored procedures | Ivan Sergio Borgonovo | 22:08 |
| Thread | Author | Time |
|---|---|---|
| SQL Spec Compliance Questions | Josh Berkus | 04:50 |
| Re: [SQL] SQL Spec Compliance Questions | Tom Lane | 05:18 |
| Re: [SQL] SQL Spec Compliance Questions | Josh Berkus | 06:14 |
| Re: plpgsql vs. SQL in stored procedures | Christopher Browne | 08:31 |
| Timestamp manipulation | Stephen Quinney | 10:41 |
| Re: plpgsql vs. SQL in stored procedures | Ivan Sergio Borgonovo | 11:07 |
| Re: plpgsql vs. SQL in stored procedures | Richard Huxton | 12:06 |
| Is it normal that functions are so much faster than inline queries | Olivier Hubaut | 12:28 |
| Re: Is it normal that functions are so much faster than inline queries | Tom Lane | 15:33 |
| Simple insert not returning | Kyle | 18:06 |
| left join on a view takes significantly more time. | Manuel Sugawara | 18:55 |
| Re: [SQL] SQL Spec Compliance Questions | Josh Berkus | 22:41 |
| Re: left join on a view takes significantly more time. | Josh Berkus | 23:49 |