Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| plpgsql syntax | Kemin Zhou | 15:32 |
| Re: plpgsql syntax | Yasir Malik | 16:02 |
| Re: plpgsql syntax | Tom Lane | 16:19 |
| Re: raise is not working | CHRIS HOOVER | 16:31 |
| Re: raise is not working | Tom Lane | 16:52 |
| Re: raise is not working | CHRIS HOOVER | 17:04 |
| Re: raise is not working | Tom Lane | 17:11 |
| need "row number" | Karsten Hilbert | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Re: need ``row number`` | Ian Harding | 00:43 |
| Re: need ``row number`` | Karsten Hilbert | 07:21 |
| select column by position | Jennifer Lee | 11:50 |
| Re: need ``row number`` | Tom Lane | 14:20 |
| INDEX problem | Vladimir S. Tikhonjuk | 14:21 |
| How to insert values in bytea? | Oliver Nolden | 15:39 |
| Re: [SQL] need ``row number`` | Greg Stark | 20:34 |
| Re: select column by position | Chester Kustarz | 21:00 |
| Re: [SQL] need ``row number`` | Ian Harding | 21:49 |
| Thread | Author | Time |
|---|---|---|
| plpgsql - accessing fields of record type | Szálka Tamás | 16:15 |
| Re: plpgsql - accessing fields of record type | Michael Fuhr | 18:33 |
| Thread | Author | Time |
|---|---|---|
| Re: where clause on a left outer join | Stephan Szabo | 00:21 |
| Re: Problem with functions | Stephan Szabo | 00:34 |
| Re: postgres rpm | Devrim GUNDUZ | 06:31 |
| Re: COUNT(*) to find records which have a certain number of | T E Schmitz | 09:45 |
| Temp Tables | sad | 13:12 |
| Re: COUNT(*) to find records which have a certain number of dependencies | Greg Stark | 13:27 |
| Error : could not send data to client | vab ip | 16:34 |
| Thread | Author | Time |
|---|---|---|
| date_trunc'd timestamp index possible? | D. Duccini | 00:14 |
| Postgres Doubt | sreejith s | 03:27 |
| FOREIGN KEY and AccessExclusiveLock | Achilleus Mantzios | 06:14 |
| Re: Best way to know if there is a row | Achilleus Mantzios | 12:24 |
| Best way to know if there is a row | Martin Marques | 12:55 |
| Re: FOREIGN KEY and AccessExclusiveLock | Achilleus Mantzios | 13:34 |
| CHECK col A not NULL if col B='x' | T E Schmitz | 14:02 |
| Re: FOREIGN KEY and AccessExclusiveLock | Tom Lane | 14:05 |
| Re: CHECK col A not NULL if col B='x' | Martin Marques | 14:12 |
| Re: CHECK col A not NULL if col B='x' | Alexander M. Pravking | 14:15 |
| Re: Best way to know if there is a row | Tom Lane | 14:24 |
| Re: CHECK col A not NULL if col B='x' | T E Schmitz | 14:38 |
| Re: CHECK col A not NULL if col B='x' | T E Schmitz | 15:01 |
| Re: Doubt | Paul Thomas | 20:39 |
| Re: CHECK col A not NULL if col B='x' | Tom Lane | 22:36 |
| Thread | Author | Time |
|---|---|---|
| Re: FOREIGN KEY and AccessExclusiveLock | Achilleus Mantzios | 05:36 |
| Re: FOREIGN KEY and AccessExclusiveLock | Achilleus Mantzios | 13:19 |
| Re: Porting problem from Informix to Postgres... | Marco Gaiarin | 13:21 |
| SELECT with Function | Paulo Nievierowski | 13:51 |
| multiple insert | van Elsacker Frans | 17:12 |
| Thread | Author | Time |
|---|---|---|
| Re: FOREIGN KEY and AccessExclusiveLock | Achilleus Mantzios | 10:51 |
| Thread | Author | Time |
|---|---|---|
| psql variable interpolation from command line | Jeff Boes | 13:24 |
| Re: psql variable interpolation from command line | Jeff Boes | 13:28 |
| Re: SELECT with Function | Marcin Piotr Grondecki | 16:46 |
| Re: date_trunc'd timestamp index possible? | Bruno Wolff III | 18:28 |
| Re: date_trunc'd timestamp index possible? | D. Duccini | 18:28 |
| Re: date_trunc'd timestamp index possible? | Bruno Wolff III | 18:44 |
| Re: [SQL] date_trunc'd timestamp index possible? | Tom Lane | 18:49 |
| Re: date_trunc'd timestamp index possible? | Tom Lane | 21:17 |
| Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Tom Lane | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Bruno Wolff III | 00:50 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd | Gaetano Mendola | 08:43 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Peter Eisentraut | 17:41 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Tom Lane | 18:22 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd | Bruno Wolff III | 20:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd | Bruno Wolff III | 01:16 |
| [No subject] | Bosko Vukov | 07:36 |
| Concurrency problem | Dag Gullberg | 10:58 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd | Gaetano Mendola | 11:18 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Mike Rylander | 14:49 |
| Re: Postgres Doubt | John DeSoi | 15:50 |
| Re: Concurrency problem | Tom Lane | 17:15 |
| How to convert 3 colums to timestamp with timezone | Jens Arnfelt | 20:50 |
| Re: Stable function semantics (was Re: Mislabeled timestamp functions) | Tom Lane | 21:27 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Greg Stark | 21:49 |
| Re: Mislabeled timestamp functions (was Re: [SQL] [NOVICE] date_trunc'd timestamp index possible?) | Tom Lane | 22:37 |
| Re: How to convert 3 colums to timestamp with timezone | Bruno Wolff III | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Difference between IN and JOIN | Markus Bertheau | 08:39 |
| Re: Concurrency problem | Dag Gullberg | 11:35 |
| Re: Concurrency problem | Magnus Hagander | 11:39 |
| Re: Difference between IN and JOIN | Tom Lane | 14:17 |
| Re: Difference between IN and JOIN | Markus Bertheau | 14:23 |
| 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 |