Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Triggers using PL/pgSQL | Thusitha Kodikara | 04:16 |
| Re: Triggers using PL/pgSQL | Aaron Bono | 04:52 |
| Re: Triggers using PL/pgSQL | Thusitha Kodikara | 05:30 |
| Re: Triggers using PL/pgSQL | Aaron Bono | 05:34 |
| Joining a result set from four (4) tables | John Tregea | 07:31 |
| Re: Joining a result set from four (4) tables | Aaron Bono | 08:12 |
| Re: primary keys as TEXT | Manlio Perillo | 08:57 |
| Re: DBD::Pg ... how would I format this prepare? | Mathieu Arnold | 11:56 |
| Re: Triggers using PL/pgSQL | John DeSoi | 12:17 |
| Re: Triggers using PL/pgSQL | Aaron Bono | 14:59 |
| Re: DBD::Pg ... how would I format this prepare? | Harald Fuchs | 15:30 |
| Re: Triggers using PL/pgSQL | Ken Hill | 15:47 |
| Re: Triggers using PL/pgSQL | John DeSoi | 15:53 |
| Re: Triggers using PL/pgSQL | Milen A. Radev | 16:12 |
| Re: Triggers using PL/pgSQL | George Weaver | 16:16 |
| Re: primary keys as TEXT | Aaron Bono | 19:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Joining a result set from four (4) tables | John Tregea | 00:12 |
| finding unused indexes? | George Pavlov | 16:05 |
| Re: finding unused indexes? | Jim Buttafuoco | 16:10 |
| Re: finding unused indexes? | Brad Nicholson | 16:11 |
| Re: Joining a result set from four (4) tables | Aaron Bono | 19:32 |
| viewing the description of tables from python DB-API | Daniel Joo | 22:30 |
| Re: viewing the description of tables from python DB-API | Alvaro Herrera | 23:00 |
| Re: viewing the description of tables from python DB-API | Rodrigo De Leon | 23:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Joining a result set from four (4) tables | John Tregea | 03:55 |
| alter column type from boolean to char with default doesn't work | Markus Bertheau | 12:46 |
| Problem while using lo_import and lo_export | Penchalaiah P. | 12:54 |
| How to cal function in one another | Penchalaiah P. | 12:55 |
| How to use table from one database to another | Penchalaiah P. | 12:57 |
| i need informarion regarding functions and arrays... | Penchalaiah P. | 13:02 |
| Re: How to use table from one database to another | Richard Broersma Jr | 13:12 |
| Re: alter column type from boolean to char with default doesn't work | Tom Lane | 13:19 |
| Re: alter column type from boolean to char with default | Rod Taylor | 13:56 |
| Re: viewing the description of tables from python DB-API | Scott Marlowe | 16:22 |
| Re: alter column type from boolean to char with default | Tom Lane | 16:36 |
| Re: Joining a result set from four (4) tables | Aaron Bono | 18:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Problem while using lo_import and lo_export | Aaron Bono | 00:09 |
| Re: How to cal function in one another | Aaron Bono | 00:11 |
| Re: i need informarion regarding functions and arrays... | Aaron Bono | 00:13 |
| Re: Joining a result set from four (4) tables | John Tregea | 00:51 |
| Re: Problem while using lo_import and lo_export | Rodrigo De León | 01:33 |
| Re: Problem while using lo_import and lo_export | Aaron Bono | 04:05 |
| Re: SELECT all fields except two | Andrew Hammond | 16:16 |
| Function not return zero record | Sylvain Racine | 16:58 |
| Error: out of memory in create table as 📎 | jason nordwick | 17:04 |
| Re: Function not return zero record | Richard Huxton | 17:29 |
| Re: alter column type from boolean to char with default | Andrew Hammond | 18:49 |
| Re: Error: out of memory in create table as | Tom Lane | 19:37 |
| Re: alter column type from boolean to char with default | Tom Lane | 19:40 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Jonathan Sinclair | 06:55 |
| autoupdating mtime column | David Garamond | 12:16 |
| Re: autoupdating mtime column | Richard Huxton | 12:49 |
| Re: autoupdating mtime column | David Garamond | 15:11 |
| Re: autoupdating mtime column | Rodrigo De León | 15:39 |
| Re: autoupdating mtime column | David Garamond | 15:51 |
| Re: autoupdating mtime column | Richard Huxton | 16:05 |
| Re: autoupdating mtime column | Tom Lane | 16:10 |
| Re: autoupdating mtime column | David Garamond | 17:36 |
| Re: autoupdating mtime column | Richard Huxton | 18:18 |
| select query optimization | sergey | 18:55 |
| to_dec() | Melvin Davidson | 21:23 |
| Thread | Author | Time |
|---|---|---|
| Re: autoupdating mtime column | David Garamond | 01:27 |
| Thread | Author | Time |
|---|---|---|
| Querying constraints? | Lexington Luthor | 15:38 |
| Change of data type | Judith | 17:38 |
| Re: viewing the description of tables from python DB-API | George Young | 19:20 |
| Re: Change of data type | jason nordwick | 20:43 |
| Re: Change of data type | Kumar Dev | 20:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Change of data type | Roman Neuhauser | 11:51 |
| Query response time | Jonathan Sinclair | 12:25 |
| Re: Query response time | Chris Mair | 12:48 |
| Re: Query response time | Richard Broersma Jr | 12:53 |
| Function Temp Table Woes | Chad Voelker | 17:24 |
| date arithmetic | chrisj | 21:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Function Temp Table Woes | Michael Fuhr | 02:12 |
| Re: Query response time | Roman Neuhauser | 17:24 |
| Thread | Author | Time |
|---|---|---|
| PL/pgSQL and PHP 5 | PostgreSQL Admin | 02:36 |
| Re: PL/pgSQL and PHP 5 | John DeSoi | 03:24 |
| Re: [SQL] PL/pgSQL and PHP 5 | Tom Lane | 03:40 |
| Re: PL/pgSQL and PHP 5 | PostgreSQL Admin | 03:42 |
| Re: [SQL] PL/pgSQL and PHP 5 | PostgreSQL Admin | 03:52 |
| Re: [SQL] PL/pgSQL and PHP 5 - thanks | PostgreSQL Admin | 04:01 |
| Re: PL/pgSQL and PHP 5 | John DeSoi | 06:12 |
| Re: Function Temp Table Woes | Chad Voelker | 11:52 |
| Re: timestamp (MS SQLServer's rowversion) functionality | Andrew Hammond | 13:28 |
| Re: date arithmetic | Osvaldo Rosario Kussama | 19:21 |
| Re: Querying constraints? | Chris Mair | 19:25 |
| Re: Querying constraints? | Chris Mair | 19:27 |
| Re: Change of data type | Shoaib Mir | 19:49 |
| how do I check for lower case 📎 | Juliann Meyer | 20:32 |
| Re: how do I check for lower case | Rodrigo De León | 21:39 |
| Re: how do I check for lower case | Daryl Richter | 21:46 |
| Re: how do I check for lower case | Scott Marlowe | 21:57 |
| Re: how do I check for lower case | Oisin Glynn | 22:49 |
| Breaking up a query | Saad Anis | 22:53 |
| Re: | Niklas Johansson | 23:30 |
| Thread | Author | Time |
|---|---|---|
| sql error creating function | TJ O'Donnell | 00:33 |
| Re: sql error creating function | Christopher Browne | 12:48 |
| Re: Query response time | Jonathan Sinclair | 13:58 |
| Can't find which return type is incorrect. | Chris Lukenbill | 14:45 |
| The Right Way to manage schemas in SCM systems | Andrew Hammond | 15:05 |
| Re: Can't find which return type is incorrect. | codeWarrior | 15:28 |
| Re: Can't find which return type is incorrect. | Chris Lukenbill | 15:49 |
| Undo an update | Judith | 17:26 |
| Re: Undo an update | Rodrigo De León | 17:41 |
| Re: timestamp (MS SQLServer's rowversion) functionality | Aaron Bono | 18:04 |
| Re: timestamp (MS SQLServer's rowversion) functionality | Andrew Hammond | 18:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Undo an update | Markus Schaber | 09:08 |
| Re: to_dec() | Aaron Bono | 15:57 |
| Re: Breaking up a query | Aaron Bono | 16:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Breaking up a query | Andrew Sullivan | 14:43 |
| Using bitmap index scans-more efficient | Kyle Bateman | 17:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Using bitmap index scans-more efficient | Florian Weimer | 06:40 |
| SQLMAP IBATIS insert values from web forms to a money type column | Emi Lu | 13:49 |
| Re: SQLMAP IBATIS insert values from web forms to a money type column | Andrew Sullivan | 14:34 |
| Multiple DB join | Sumeet Ambre | 21:26 |
| Re: Multiple DB join | Shoaib Mir | 22:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Using bitmap index scans-more efficient | Kyle Bateman | 01:06 |
| Re: Using bitmap index scans-more efficient | Tom Lane | 01:53 |
| Re: Multiple DB join | Andrew Sullivan | 10:36 |
| Re: Multiple DB join | Michael Fuhr | 11:38 |
| Re: Multiple DB join | Jorge Godoy | 12:01 |
| Re: Undo an update | Kis János Tamás | 12:20 |
| Re: Multiple DB join | Andrew Sullivan | 13:18 |
| Re: Multiple DB join | Jorge Godoy | 13:25 |
| Re: Query response time | Scott Marlowe | 13:49 |
| Re: Multiple DB join | Sumeet Ambre | 14:11 |
| Re: Breaking up a query | Scott Marlowe | 14:16 |
| Re: Multiple DB join | Andrew Sullivan | 14:17 |
| Re: Multiple DB join | Andrew Sullivan | 14:17 |
| Re: Multiple DB join | Sumeet | 14:35 |
| Re: Multiple DB join | Andrew Sullivan | 14:45 |
| Re: The Right Way to manage schemas in SCM systems | Aaron Bono | 19:18 |
| Re: Using bitmap index scans-more efficient | Kyle Bateman | 21:58 |
| Re: Using bitmap index scans-more efficient | Kyle Bateman | 23:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Undo an update | Markus Schaber | 08:41 |
| problem with sequence..... | Penchalaiah P. | 11:31 |
| Re: problem with sequence..... | Andrew Sullivan | 14:17 |
| Re: Undo an update | Rodrigo De León | 15:28 |
| OT: OpenDatabase Model ? | Jesper K. Pedersen | 16:12 |
| Re: Using bitmap index scans-more efficient | Tom Lane | 16:58 |
| DB creation script questions | Jon Horsman | 18:44 |
| Re: OT: OpenDatabase Model ? | Andrew Sullivan | 19:07 |
| Re: DB creation script questions | Andrew Sullivan | 19:10 |
| Re: OT: OpenDatabase Model ? | Jesper K. Pedersen | 20:03 |
| Re: Using bitmap index scans-more efficient | Kyle Bateman | 20:46 |
| Re: Using bitmap index scans-more efficient | Tom Lane | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Help with optional parameters | Rob Tester | 03:39 |
| Re: Help with optional parameters | Michael Fuhr | 05:21 |
| Re: OT: OpenDatabase Model ? | Andrew Sullivan | 10:26 |
| Re: Help with optional parameters | MaXX | 12:54 |
| NULL becomes default | Julian Scarfe | 18:11 |
| Re: NULL becomes default | Sumeet | 18:22 |
| About DBlink | Sumeet | 20:37 |
| Re: About DBlink | Michael Fuhr | 20:59 |
| Re: About DBlink | Sumeet | 21:14 |
| Re: About DBlink | Chris Mair | 21:25 |
| Re: About DBlink | Michael Fuhr | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with optional parameters | Rob Tester | 01:57 |
| Re: Multiple DB join | Sumeet | 15:07 |
| Re: Multiple DB join | Andrew Sullivan | 15:20 |
| trigger needs to check in multiple tables. | Jacobo García | 17:17 |
| Thread | Author | Time |
|---|---|---|
| Re: trigger needs to check in multiple tables. | Michael Fuhr | 01:01 |
| Re: NULL becomes default | Markus Schaber | 07:51 |
| Thread | Author | Time |
|---|---|---|
| Re: NULL becomes default | Julian Scarfe | 10:34 |
| Thread | Author | Time |
|---|---|---|
| Re: NULL becomes default | Andrew Sullivan | 10:27 |
| Triggers | Ezequias Rodrigues da Rocha | 12:03 |
| Re: Triggers | Kaloyan Iliev | 12:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Triggers | Kis János Tamás | 06:34 |
| to get DD-MM-YYYY format of data | Penchalaiah P. | 13:16 |
| Re: to get DD-MM-YYYY format of data | Alvaro Herrera | 13:27 |
| Re: to get DD-MM-YYYY format of data | Michael Fuhr | 13:27 |
| joining VIEWs | Brian Cox | 16:40 |
| Re: joining VIEWs | Stephan Szabo | 16:59 |
| Thread | Author | Time |
|---|---|---|
| SQL92 compliance | Daniel CAUNE | 01:40 |
| error with mor than 1 sub-select | chrisj | 01:47 |
| Re: SQL92 compliance | Michael Glaesemann | 01:54 |
| Re: error with mor than 1 sub-select | Osvaldo Kussama | 02:03 |
| Re: error with mor than 1 sub-select | Michael Fuhr | 02:06 |
| Re: error with mor than 1 sub-select | chrisj | 02:26 |
| Re: error with mor than 1 sub-select | Erik Jones | 14:57 |
| Re: SQL92 compliance | Peter Eisentraut | 16:11 |
| Re: SQL92 compliance | Tom Lane | 17:40 |
| The length of the sql query | Emi Lu | 17:53 |
| Re: SQL92 compliance | Scott Marlowe | 18:28 |
| All columns from table in a joined query | MHahn | 19:14 |
| Deleting Functions | Scott Petersen | 19:29 |
| Re: All columns from table in a joined query | Sumeet | 19:44 |
| Re: Deleting Functions | Jim Buttafuoco | 19:56 |
| Re: All columns from table in a joined query | Tom Lane | 21:26 |
| Re: Deleting Functions | Tom Lane | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL92 compliance | Peter Eisentraut | 06:42 |
| Re: SQL92 compliance | Peter Eisentraut | 06:43 |
| Re: The length of the sql query | Emi Lu | 12:58 |
| Re: The length of the sql query | Tom Lane | 14:34 |
| Importing data from csv | Sumeet | 14:47 |
| double precision vs. numeric | Aarni Ruuhimäki | 16:36 |
| Re: double precision vs. numeric | Peter Eisentraut | 16:51 |
| Function to retrieve the Id column | Ezequias Rodrigues da Rocha | 17:07 |
| Re: double precision vs. numeric | Michael Fuhr | 17:24 |
| Re: double precision vs. numeric | Tom Lane | 17:29 |