Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Help with quotes in plpgsql | Hector Villarreal | 00:00 |
| Re: Help with quotes in plpgsql | Tom Lane | 00:27 |
| Fetching BLOBs | Ashish Ahlawat | 03:25 |
| Re: Fetching BLOBs | Richard Huxton | 06:59 |
| Re: Fetching BLOBs | Ragnar | 08:48 |
| join/group/count query. | Gary Stainburn | 10:12 |
| Re: join/group/count query. | Ragnar | 11:09 |
| Re: Help with quotes in plpgsql | Richard Ray | 14:10 |
| Re: Help with quotes in plpgsql | Richard Huxton | 14:26 |
| Re: join/group/count query. | Erik Jones | 15:46 |
| Re: join/group/count query. | Gary Stainburn | 16:20 |
| Re: join/group/count query. | Erik Jones | 16:32 |
| Re: join/group/count query. | Hector Villarreal | 18:06 |
| Thread | Author | Time |
|---|---|---|
| NEED URGENT HELP.... | Sandip G | 07:41 |
| Re: join/group/count query. | Gary Stainburn | 09:46 |
| Thread | Author | Time |
|---|---|---|
| Changing character set when the damage is done | Alexis Paul Bertolini | 23:12 |
| Re: Changing character set when the damage is done | Ragnar | 23:52 |
| Thread | Author | Time |
|---|---|---|
| I would like to alter the COPY command | Mason | 03:08 |
| Fwd: I would like to alter the COPY command | Mason | 03:08 |
| Re: Changing character set when the damage is done | Alexis Paul Bertolini | 16:05 |
| Re: Changing character set when the damage is done | Michael Fuhr | 16:57 |
| Re: Changing character set when the damage is done | Alexis Paul Bertolini | 17:44 |
| Re: Changing character set when the damage is done | Michael Fuhr | 19:12 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] NEED URGENT HELP.... | Harpreet Dhaliwal | 17:32 |
| Related tables to a view | Jan Meyland Andersen | 21:52 |
| Re: NEED URGENT HELP.... | Guy Rouillier | 23:45 |
| Re: NEED URGENT HELP.... | Henrique P Machado | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Related tables to a view | Michael Fuhr | 04:10 |
| Re: Related tables to a view | Jan Andersen | 10:54 |
| Re: NEED URGENT HELP.... | Martijn van Oosterhout | 11:53 |
| Re: NEED URGENT HELP.... | Gurjeet Singh | 15:09 |
| Re: Related tables to a view | Jan Meyland Andersen | 20:10 |
| Re: Related tables to a view | Jim Buttafuoco | 20:27 |
| Thread | Author | Time |
|---|---|---|
| Re: NEED URGENT HELP.... | Iannsp | 00:28 |
| domains and serial | BillR | 03:10 |
| Re: Related tables to a view | Jan Meyland Andersen | 15:58 |
| Unable to drop table, error mentions "reltriggers" | Kashmira Patel (kupatel) | 19:52 |
| Re: Unable to drop table, error mentions "reltriggers" | Shoaib Mir | 20:09 |
| Thread | Author | Time |
|---|---|---|
| help with version checking | Arnau | 17:30 |
| Re: help with version checking | Daniel CAUNE | 17:45 |
| Re: help with version checking | Arnau | 17:50 |
| Re: help with version checking | Tom Lane | 17:56 |
| Re: help with version checking | Arnau | 18:14 |
| Re: help with version checking | Arnau | 18:20 |
| Re: help with version checking | Chris Dunworth | 18:32 |
| Thread | Author | Time |
|---|---|---|
| Help in altering the column lenght | roopa perumalraja | 01:05 |
| Re: help with version checking | Karsten Hilbert | 11:59 |
| Re: help with version checking | Arnau | 14:08 |
| How to reduce a database | Mario Behring | 15:09 |
| Re: help with version checking | Chris Dunworth | 17:17 |
| Re: How to reduce a database | Ragnar | 17:18 |
| Re: Fwd: I would like to alter the COPY command | Andrew Dunstan | 17:43 |
| Thread | Author | Time |
|---|---|---|
| Re: domains and serial | Bruce Momjian | 02:09 |
| or function | A. R. Van Hook | 17:43 |
| Re: or function | chester c young | 18:10 |
| Re: or function | Tom Lane | 18:11 |
| Thread | Author | Time |
|---|---|---|
| [SQL NOTIFY Help] sending NOTIFY to the external program | ramachandra.bhaskaram | 09:35 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | Richard Huxton | 10:22 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | ramachandra.bhaskaram | 13:59 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | Richard Huxton | 14:09 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | ramachandra.bhaskaram | 14:17 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | Richard Huxton | 14:22 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | Andrew Sullivan | 16:10 |
| Re: [SQL NOTIFY Help] sending NOTIFY to the external program | Dave Steinberg | 16:20 |
| Thread | Author | Time |
|---|---|---|
| quoted variables in pgsql | chester c young | 03:21 |
| Re: quoted variables in pgsql | Tom Lane | 03:26 |
| Re: How to reduce a database | Travis Whitton | 18:29 |
| Thread | Author | Time |
|---|---|---|
| how un-suscribe from this list | Manso Gomez, Ramon | 07:44 |
| Re: how un-suscribe from this list | Richard Broersma Jr | 14:49 |
| Help with Array | Jeremiah Elliott | 17:24 |
| Re: Help with Array | Aaron Bono | 18:35 |
| Table relationships | Curtis Scheer | 21:39 |
| Fwd: Table relationships | Aaron Bono | 22:42 |
| Re: Table relationships | Curtis Scheer | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Table relationships | D'Arcy J.M. Cain | 14:41 |
| Re: Table relationships | Aaron Bono | 15:13 |
| Re: Table relationships | D'Arcy J.M. Cain | 15:30 |
| Question about GUI | Judith | 23:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Question about GUI | Phillip Smith | 04:20 |
| Re: Question about GUI | Devrim GUNDUZ | 12:02 |
| Requirement for PostgreSQL Database Developer | Mark | 20:56 |
| How to aggregates this data | John Summerfield | 22:50 |
| Thread | Author | Time |
|---|---|---|
| Re: How to aggregates this data | Chad Wagner | 00:29 |
| Re: How to aggregates this data | Chad Wagner | 00:38 |
| a way to generate functions dynamically ? | Marc Mamin | 08:29 |
| Re: a way to generate functions dynamically ? | Richard Huxton | 10:19 |
| Aggregating both tables in a join? | Steve Sabljak | 12:22 |
| Re: How to aggregates this data | Bruno Wolff III | 19:51 |
| Re: Aggregating both tables in a join? | Aaron Bono | 19:55 |
| Conditional SQL Query | devil live | 21:34 |
| Re: Conditional SQL Query | M.P.Dankoor | 22:01 |
| Re: Conditional SQL Query | Chad Wagner | 22:03 |
| Re: Conditional SQL Query | Shane Ambler | 23:35 |
| Thread | Author | Time |
|---|---|---|
| deleting records from a table | Mario Behring | 17:45 |
| Re: deleting records from a table | Richard Broersma Jr | 17:53 |
| Re: deleting records from a table | Richard Broersma Jr | 18:30 |
| Re: deleting records from a table | Scott Marlowe | 18:48 |
| Re: deleting records from a table | Andrew Sullivan | 20:51 |
| Thread | Author | Time |
|---|---|---|
| update query taking 24+ hours | Ken | 06:33 |
| Re: update query taking 24+ hours | Tom Lane | 19:30 |
| Thread | Author | Time |
|---|---|---|
| Re: update query taking 24+ hours | Ken | 04:47 |
| vacuum process taking more than 33 hours | Mario Behring | 14:23 |
| Re: vacuum process taking more than 33 hours | Andrew Sullivan | 14:32 |
| Re: vacuum process taking more than 33 hours | Ezequiel Luis Pellettieri | 14:44 |
| Re: vacuum process taking more than 33 hours | Andrew Sullivan | 14:53 |
| Referencing tables are grinding UPDATE to a halt | William Scott Jordan | 21:26 |
| Re: Resolved - Referencing tables are grinding UPDATE to | William Scott Jordan | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Droping indexes | Mario Behring | 13:51 |
| Re: Droping indexes | Mario Behring | 14:43 |
| Re: Droping indexes | Alvaro Herrera | 15:08 |
| Removing CONTEXT message | Sabin Coanda | 15:38 |
| Re: Droping indexes | Mario Behring | 15:42 |
| Re: Droping indexes | Erik Jones | 15:48 |
| Re: Removing CONTEXT message | Tom Lane | 16:23 |
| Re: Droping indexes | Scott Marlowe | 16:24 |
| Re: Droping indexes | Frank Bax | 16:27 |
| Re: Droping indexes | Frank Bax | 16:30 |
| Re: Removing CONTEXT message | Sabin Coanda | 16:55 |
| Re: Droping indexes RESOLVED | Mario Behring | 16:57 |
| Re: Removing CONTEXT message | Tom Lane | 17:13 |
| Thread | Author | Time |
|---|---|---|
| Update query by joining multiple tables. | Moiz Kothari | 11:20 |
| Postgresql & Oracle Heteregenous services - strange behaviour | Marcin Stępnicki | 12:52 |
| Re: Update query by joining multiple tables. | Andrew Sullivan | 12:55 |
| Re: Postgresql & Oracle Heteregenous services - strange behaviour | Andrew Sullivan | 12:58 |
| Re: Postgresql & Oracle Heteregenous services - strange behaviour | Richard Huxton | 13:04 |
| Re: Postgresql & Oracle Heteregenous services - strange behaviour | Marcin Stępnicki | 13:25 |
| Re: Update query by joining multiple tables. | Shoaib Mir | 15:01 |
| Some help with functions-syntax | Jan Meyland Andersen | 22:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Some help with functions-syntax | John DeSoi | 00:50 |
| Re: Some help with functions-syntax | Jan Meyland Andersen | 07:38 |
| Re: Some help with functions-syntax | John DeSoi | 13:47 |
| Help ... Unexpected results when using limit/offset with select statement..DB corruption? | Barbara Cosentino | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Help ... Unexpected results when using limit/offset with | Stephan Szabo | 00:40 |
| Query to return schema/table/columname/columntype | paallen | 12:41 |
| Re: Postgresql & Oracle Heteregenous services - strange behaviour | Marcin Stępnicki | 13:14 |
| Re: Query to return schema/table/columname/columntype | paallen | 14:23 |
| Re: Query to return schema/table/columname/columntype | Bruno Wolff III | 15:45 |
| Re: Query to return schema/table/columname/columntype | chester c young | 16:28 |
| Re: Query to return schema/table/columname/columntype | codeWarrior | 16:39 |
| Permissions Query? | paallen | 19:11 |
| Re: Permissions Query? | Andrew Sullivan | 19:15 |
| Thread | Author | Time |
|---|---|---|
| select based on multi-column primary keys | mawrya | 00:44 |
| Re: select based on multi-column primary keys | Bruno Wolff III | 01:45 |
| Re: select based on multi-column primary keys | codeWarrior | 03:45 |
| Re: select based on multi-column primary keys | Richard Broersma Jr | 04:57 |
| Thread | Author | Time |
|---|---|---|
| Re: select based on multi-column primary keys | Andrew Sullivan | 15:28 |
| Changing point for commas and commas for point | Ezequias Rodrigues da Rocha | 18:41 |
| Re: Changing point for commas and commas for point | Tom Lane | 18:49 |
| Re: Changing point for commas and commas for point | Andreas Kretschmer | 18:56 |
| Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS? | Simon Kinsella | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS? | Tom Lane | 03:36 |
| list variable attributes in one select | Louis-David Mitterrand | 07:43 |
| Re: list variable attributes in one select | A. Kretschmer | 08:24 |
| FW: Possible to emulate pre-8.2 behaviour of SET CONSTRAINTS? | Simon Kinsella | 10:50 |
| server process (PID xxx) was terminated by signal 7 | Achilleas Mantzios | 11:12 |
| Re: server process (PID xxx) was terminated by signal 7 | Tom Lane | 16:01 |
| Re: server process (PID xxx) was terminated by signal 7 | Alvaro Herrera | 16:47 |
| Re: server process (PID xxx) was terminated by signal | Bruce Momjian | 17:27 |
| Schema sample | Ezequias Rodrigues da Rocha | 19:38 |
| Re: Schema sample | Marcin Stępnicki | 19:45 |
| Re: Schema sample | Aaron Bono | 19:54 |
| How to query by column names | Richard Ray | 22:25 |
| Re: How to query by column names | Jeff Frost | 23:29 |
| Re: How to query by column names | Richard Ray | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: How to query by column names | Jeff Frost | 00:20 |
| Re: How to query by column names | Richard Ray | 00:30 |
| Re: How to query by column names | Jeff Frost | 00:36 |
| Re: How to query by column names | Richard Ray | 01:25 |
| Re: How to query by column names | Jeff Frost | 01:32 |
| Re: How to query by column names | Josh Williams | 05:03 |
| Re: How to query by column names | Jeff Frost | 05:29 |
| Re: server process (PID xxx) was terminated by signal 7 | Achilleas Mantzios | 08:52 |
| Re: How to query by column names | John Summerfield | 11:56 |
| Re: How to query by column names | John Summerfield | 12:01 |
| Odbc configuration on Localhost | Ezequias Rodrigues da Rocha | 14:35 |
| Re: Odbc configuration on Localhost | Oisin Glynn | 14:52 |
| Re: select based on multi-column primary keys | codeWarrior | 21:07 |
| Re: select based on multi-column primary keys | Andrew Sullivan | 21:26 |
| Re: server process (PID xxx) was terminated by signal | Peter Eisentraut | 23:26 |
| Thread | Author | Time |
|---|---|---|
| Re: server process (PID xxx) was terminated by signal 7 | Achilleas Mantzios | 08:47 |
| Thread | Author | Time |
|---|---|---|
| Using Temporary Tables in postgres functions | Mario Splivalo | 14:39 |
| Re: Using Temporary Tables in postgres functions | Andrew Sullivan | 16:00 |
| Re: Using Temporary Tables in postgres functions | Stephan Szabo | 16:03 |
| Re: Using Temporary Tables in postgres functions | Tom Lane | 16:09 |
| Windows 2K Installation difficulties... | Neil Bibbins | 16:53 |
| Re: Windows 2K Installation difficulties... | Oisin Glynn | 18:28 |
| Looping recordset | Furesz Peter | 19:45 |
| shared_buffers and shmall,shmmax | Jie Liang | 20:11 |
| Re: shared_buffers and shmall,shmmax | Tom Lane | 20:14 |
| Re: shared_buffers and shmall,shmmax | Jie Liang | 20:58 |
| LEFT Join Question | Rob V | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: LEFT Join Question | Rob V | 00:09 |
| Re: Looping recordset | Hélder M. Vieira | 00:56 |
| Re: LEFT Join Question | codeWarrior | 02:13 |
| Intersection of two date interval | Suha Onay | 09:39 |
| implementing (something like) UNIQUE constraint using PL/pgSQL | Tomas Vondra | 09:41 |
| Re: Intersection of two date interval | A. Kretschmer | 09:50 |
| Re: Intersection of two date interval | Achilleas Mantzios | 10:02 |
| Re: Using Temporary Tables in postgres functions | Mario Splivalo | 10:46 |
| Re: Using Temporary Tables in postgres functions | Mario Splivalo | 10:47 |