Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Stuffing six separate columns into a single array? | C. Bensend | 03:56 |
| Re: Stuffing six separate columns into a single array? | Michael Fuhr | 07:04 |
| Re: Howto turn an integer into an interval? | Achilleus Mantzios | 11:44 |
| Howto turn an integer into an interval? | Erik Wasser | 12:07 |
| Re: Howto turn an integer into an interval? | Pierre-Frédéric Caillaud | 12:38 |
| Re: Stuffing six separate columns into a single array? | C. Bensend | 13:26 |
| Using timestamp in function | Silke Trissl | 15:37 |
| Re: Using timestamp in function | Tom Lane | 16:06 |
| Re: Using timestamp in function | Michael Fuhr | 16:19 |
| Stored Procedures returning a RECORD | Kent Anderson | 17:52 |
| Re: Stored Procedures returning a RECORD | Jeff Eckermann | 20:41 |
| Thread | Author | Time |
|---|---|---|
| Regex | Theo Galanakis | 00:52 |
| Database Backup | sreejith s | 02:39 |
| Re: Regex | Tom Lane | 03:36 |
| Re: Howto turn an integer into an interval? | sad | 05:01 |
| Re: Regex | Theo Galanakis | 05:44 |
| Re: Howto turn an integer into an interval? | Erik Wasser | 08:13 |
| Re: Database Backup | sklassen | 15:19 |
| Table locks | Jaime Casanova | 20:36 |
| Thread | Author | Time |
|---|---|---|
| Query from different Database | Abdul Wahab Dahalan | 08:52 |
| Re: Query from different Database | Robert Creager | 14:05 |
| Re: Query from different Database | Jaime Casanova | 20:58 |
| Thread | Author | Time |
|---|---|---|
| help on a query | Michelle Murrain | 03:03 |
| Re: help on a query | Thomas F.O'Connell | 03:10 |
| Re: help on a query | sad | 04:44 |
| Re: help on a query | CHRIS HOOVER | 13:02 |
| Re: help on a query | Achilleus Mantzios | 13:03 |
| Re: help on a query | Thomas F.O'Connell | 15:06 |
| Re: help on a query | Michelle Murrain | 15:19 |
| Record Count | sreejith s | 17:51 |
| Re: Record Count | Michael Fuhr | 19:32 |
| Thread | Author | Time |
|---|---|---|
| Re: help on a query | Greg Stark | 03:17 |
| Impact of foreign keys on a simple count(*) ? | C. Bensend | 03:37 |
| Re: Impact of foreign keys on a simple count(*) ? | Tom Lane | 03:49 |
| Re: Impact of foreign keys on a simple count(*) ? | C. Bensend | 04:13 |
| Re: SELECT with Function | Paulo Nievierowski | 15:11 |
| How do FKs work? | Marc G. Fournier | 18:08 |
| SQL confusion | Andrew Ward | 20:39 |
| Re: SQL confusion | Richard Poole | 21:11 |
| Re: SQL confusion | Michael Fuhr | 21:59 |
| Thread | Author | Time |
|---|---|---|
| Re: How do FKs work? | Tom Lane | 00:23 |
| Re: How do FKs work? | Marc G. Fournier | 00:43 |
| Re: How do FKs work? | Marc G. Fournier | 00:48 |
| Re: How do FKs work? | Janning Vygen | 12:24 |
| Re: How do FKs work? | Marc G. Fournier | 13:01 |
| SQL doubt - Date Add | sreejith s | 14:19 |
| Re: SQL doubt - Date Add | Gaetano Mendola | 14:36 |
| Re: SQL doubt - Date Add | Gaetano Mendola | 14:37 |
| Export tab delimited from mysql to postgres. | Theo Galanakis | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL doubt - Date Add | Richard Huxton | 09:21 |
| Re: Export tab delimited from mysql to postgres. | Harald Fuchs | 09:33 |
| table update using result from join | Gary Stainburn | 09:49 |
| Re: How do FKs work? | Janning Vygen | 11:03 |
| Re: Export tab delimited from mysql to postgres. | Theo Galanakis | 23:23 |
| Re: Export tab delimited from mysql to postgres. | Bruno Wolff III | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Export tab delimited from mysql to postgres. | Christopher Browne | 00:46 |
| [No subject] | Ramiro Batista da Luz | 00:52 |
| Re: Export tab delimited from mysql to postgres. | Theo Galanakis | 05:33 |
| Re: Export tab delimited from mysql to postgres. | Pierre-Frédéric Caillaud | 07:20 |
| the problem of createlang! | Fang Genjie | 08:01 |
| Information about the command SQL " create synonym". | Gerald.Laurent | 13:04 |
| PL/pgSQL, RETURN NEXT, ORDER | Markus Bertheau | 13:24 |
| Re: PL/pgSQL, RETURN NEXT, ORDER | Markus Bertheau | 13:41 |
| Re: Export tab delimited from mysql to postgres. | Tom Lane | 13:56 |
| JDBC +CIDR | Johann Robette | 15:54 |
| Re: SQL confusion | Thomas F.O'Connell | 17:01 |
| Re: Information about the command SQL " create synonym". | Peter Eisentraut | 17:37 |
| Re: Export tab delimited from mysql to postgres. | Theo Galanakis | 23:56 |
| Thread | Author | Time |
|---|---|---|
| help with to_date and to_char | Lori | 00:20 |
| Plperlu function & backticks return value -> truncated? | Philippe Lang | 15:07 |
| Re: Plperlu function & backticks return value -> truncated? | Richard Huxton | 15:25 |
| Re: Plperlu function & backticks return value -> truncated? | Philippe Lang | 15:42 |
| Re: Plperlu function & backticks return value -> truncated? | Michael Fuhr | 15:47 |
| Re: Plperlu function & backticks return value -> truncated? | Philippe Lang | 15:54 |
| Thread | Author | Time |
|---|---|---|
| libpq-fe: PQgetvalue() ? | sad | 12:34 |
| Thread | Author | Time |
|---|---|---|
| Re: libpq-fe: PQgetvalue() ? | ljb | 00:51 |
| Inserting into table only if the row does not already exist. | C. Bensend | 04:18 |
| Re: Inserting into table only if the row does not already exist. | Greg Stark | 05:10 |
| Re: libpq-fe: PQgetvalue() ? | Christoph Haller | 08:57 |
| Re: Inserting into table only if the row does not already | C. Bensend | 13:14 |
| Re: libpq-fe: PQgetvalue() ? | Tom Lane | 14:21 |
| Thread | Author | Time |
|---|---|---|
| need query advice | Stephan Fiebrandt | 09:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Inserting into table only if the row does not already | Steven Klassen | 00:49 |
| Re: Inserting into table only if the row does not already | C. Bensend | 01:09 |
| Database backup | sreejith s | 03:19 |
| Re: Database backup | Steven Klassen | 03:34 |
| Re: Inserting into table only if the row does not already | Greg Stark | 05:22 |
| Re: Inserting into table only if the row does not already | C. Bensend | 06:04 |
| Thread | Author | Time |
|---|---|---|
| Installation woes | Richard Sydney-Smith | 13:56 |
| Re: Installation woes | Magnus Hagander | 15:12 |
| bibliographic schema | Guillaume | 15:18 |
| Aggregate Function with Argument | David Siegal | 15:24 |
| Ordering a record returned from a stored procedure | Kent Anderson | 15:59 |
| Re: Aggregate Function with Argument | Bruno Wolff III | 16:05 |
| Re: Ordering a record returned from a stored procedure | Stephan Szabo | 16:25 |
| problems using phpPgAmin | beyaNet | 16:28 |
| Re: problems using phpPgAmin | Richard_D_Levine | 16:39 |
| Re: Database backup | Andreas | 16:39 |
| Re: Ordering a record returned from a stored procedure - date issue | Kent Anderson | 18:32 |
| Re: Ordering a record returned from a stored procedure - date issue | Kent Anderson | 19:17 |
| Re: problems using phpPgAmin | Oliver Elphick | 19:35 |
| Re: bibliographic schema | Josh Berkus | 20:10 |
| Thread | Author | Time |
|---|---|---|
| Re: bibliographic schema | Karsten Hilbert | 07:17 |
| Re: Ordering a record returned from a stored procedure - date | Richard Huxton | 08:21 |
| Re: problems using phpPgAmin | Mark Gibson | 11:47 |
| Re: bibliographic schema | Guillaume | 11:56 |
| Re: Aggregate Function with Argument | Mark Gibson | 14:50 |
| Re: help with to_date and to_char | Thomas F.O'Connell | 21:27 |
| Re: the problem of createlang! | Tom Lane | 21:31 |
| Re: help with to_date and to_char | Edmund Bacon | 23:00 |
| Re: help with to_date and to_char | Edmund Bacon | 23:05 |
| Re: help with to_date and to_char | lorid | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: need query advice | Pierre-Frédéric Caillaud | 00:14 |
| Which type of functions are best? | Postgres User | 02:41 |
| Re: help with to_date and to_char | Thomas F.O'Connell | 03:29 |
| Cross tabulations | Muhyiddin A.M Hayat | 04:43 |
| Re: Cross tabulations | Greg Stark | 06:35 |
| SQL update function faililed in Webmin Interface | Kathiravan Velusamy | 07:03 |
| Re: [SQL] SQL update function faililed in Webmin Interface | Richard Huxton | 07:37 |
| Re: SQL update function faililed in Webmin Interface | Scott Marlowe | 07:49 |
| Reuse previously calculated column in sql query? | Philippe Lang | 12:50 |
| Re: Reuse previously calculated column in sql query? | Rod Taylor | 13:05 |
| Re: the problem of createlang! | Weiping | 14:57 |
| time of constraint checking | Markus Bertheau | 15:58 |
| Re: time of constraint checking | Markus Bertheau | 16:16 |
| Re: time of constraint checking | Stephan Szabo | 16:56 |
| "copy from" in "create function" | Gifford Hesketh | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Reuse previously calculated column in sql query? | Iain | 01:31 |
| Offtopic: psql | sad | 11:58 |
| Re: Offtopic: psql | Achilleus Mantzios | 12:35 |
| Re: Aggregate Function with Argument | David Siegal | 15:26 |
| Finding duplicated values | Kent Anderson | 18:58 |
| Re: Finding duplicated values | Bricklen | 19:20 |
| Re: Finding duplicated values | Stephan Szabo | 20:09 |
| Trouble with explicit joins | Dmitry Tkach | 22:44 |
| Re: Finding duplicated values | lorid | 23:18 |
| Re: Trouble with explicit joins | Tom Lane | 23:32 |
| Re: Trouble with explicit joins | Dmitry Tkach | 23:36 |
| Thread | Author | Time |
|---|---|---|
| Question on the 8.0Beta Version | Davide Negri | 06:59 |
| Re: Finding duplicated values | Christoph Haller | 07:49 |
| now() + integer, not rounded to whole day | JN | 12:04 |
| Re: Functions return a select in a table, which data type I | Markus Bertheau | 13:38 |
| Log | Davide Negri | 13:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Question on the 8.0Beta Version | Gaetano Mendola | 22:08 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] Question on the 8.0Beta Version | Scott Marlowe | 01:06 |
| Re: Log | Scott Marlowe | 01:08 |
| Re: Question on the 8.0Beta Version | Harald Armin Massa | 10:19 |
| Thread | Author | Time |
|---|---|---|
| Create interval using column value? | Larry Lennhoff | 02:54 |
| Re: Create interval using column value? | Tom Lane | 03:11 |
| Re: Create interval using column value? | Michael Glaesemann | 03:13 |
| Re: Create interval using column value? | Larry Lennhoff | 03:18 |
| sql | cristivoinicaru | 08:13 |
| Re: Cross tabulations | Muhyiddin A.M Hayat | 08:49 |
| Re: now() + integer, not rounded to whole day | JN | 09:27 |
| Re: sql | Andrei Bintintan | 10:04 |
| Re: bibliographic schema | James Cloos | 10:36 |
| Re: sql | Mike Rylander | 11:20 |
| Re: sql | Andrew J. Kopciuch | 11:44 |
| Re: sql | Mike Rylander | 13:05 |
| Re: now() + integer, not rounded to whole day | Bruno Wolff III | 16:32 |
| Re: "copy from" in "create function" | Jan Wieck | 17:19 |
| plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) | Marinos Yannikos | 19:44 |
| Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND variable?) | Tom Lane | 20:02 |
| Re: plpgsql: PERFORM vs. SELECT INTO (PERFORM not setting FOUND | Edmund Bacon | 20:08 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Question on the 8.0Beta Version | Adrian Maier | 06:13 |
| How to recognize trigger-inserted rows? | Jeff Boes | 16:27 |
| How to recognize trigger-inserted rows? | Jeff Boes | 17:00 |
| How to re-sort a sorted query? | Yudie | 19:23 |
| How do you compare (NULL) and (non-NULL)? | Wei Weng | 20:23 |
| Re: How to re-sort a sorted query? | Oliver Elphick | 20:34 |
| Re: How do you compare (NULL) and (non-NULL)? | Stephan Szabo | 20:48 |
| Re: How do you compare (NULL) and (non-NULL)? | Jerome Alet | 21:01 |
| Re: How to re-sort a sorted query? | Yudie | 21:32 |
| Re: How to re-sort a sorted query? | Tom Lane | 21:43 |
| Re: How to re-sort a sorted query? | Oliver Elphick | 21:57 |
| Thread | Author | Time |
|---|---|---|
| JOIN not being calculated correctly | Scott Pederick | 11:02 |
| RULE and default nextval() column | Dmitry P. Ovechkin | 13:19 |
| Re: RULE and default nextval() column | Stephan Szabo | 14:11 |
| Foreign Key Non-Null Problem in 8.0 | Jon Uhal | 15:09 |
| Re: How to re-sort a sorted query? | Yudie | 15:30 |
| Re: How do you compare (NULL) and (non-NULL)? | Bruno Wolff III | 15:36 |
| Thread | Author | Time |
|---|---|---|
| Select Instead on a table | Markus Schaber | 10:03 |
| curious delay on view/where | Gary Stainburn | 10:16 |
| Re: extra info - curious delay on view/where | Gary Stainburn | 10:42 |
| Re: Select Instead on a table | Tom Lane | 14:22 |
| Re: curious delay on view/where | Tom Lane | 14:25 |
| Re: extra info - curious delay on view/where | andre.toscano | 14:53 |
| Re: curious delay on view/where | Gary Stainburn | 15:01 |
| Re: ORDER BY and NULLs | Murphy Pope | 16:52 |
| Re: Select Instead on a table | Markus Schaber | 16:58 |
| Re: ORDER BY and NULLs | Murphy Pope | 18:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Functions return a select in a table, which data type I | Markus Bertheau | 09:08 |
| paertially restoring a DB | Niall Linden | 14:04 |
| Re: How do you compare (NULL) and (non-NULL)? | Wei Weng | 15:59 |
| Re: extra info - curious delay on view/where | Markus Schaber | 17:46 |
| Re: How do you compare (NULL) and (non-NULL)? | Bruno Wolff III | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Re: ORDER BY and NULLs | Murphy Pope | 00:00 |
| Re: Foreign Key Non-Null Problem in 8.0 | Stephan Szabo | 06:22 |
| Thread | Author | Time |
|---|---|---|
| Re: paertially restoring a DB | Iain | 05:51 |
| 'show databases' in psql way? | Erik Wasser | 12:13 |