Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Image Insert Postgresql DB | sreejith s | 04:21 |
| Re: Image Insert Postgresql DB | Vishal Kashyap @ [SaiHertz] | 04:37 |
| Re: Image Insert Postgresql DB | Kenneth Gonsalves | 05:18 |
| Image Insert Doubt | sreejith s | 06:50 |
| Re: Image Insert Postgresql DB | Premsun Choltanwanich | 07:18 |
| Re: Image Insert Postgresql DB | Kenneth Gonsalves | 07:40 |
| Re: Image Insert Postgresql DB | Premsun Choltanwanich | 08:19 |
| Re: Image Insert Postgresql DB | Kenneth Gonsalves | 09:29 |
| Re: Image Insert Postgresql DB | Premsun Choltanwanich | 09:45 |
| PG7.4.5: query not using index on date column | Dave Steinberg | 14:28 |
| Re: Image Insert Doubt | Vishal Kashyap @ [SaiHertz] | 18:39 |
| Re: NULLS and string concatenation | Andrew Hammond | 19:16 |
| Thread | Author | Time |
|---|---|---|
| Encrypt data type LO | Alberto Pia | 16:28 |
| Explicitly rolling back transaction from within a C-Language function | Mark Dilger | 19:23 |
| Re: Explicitly rolling back transaction from within a C-Language function | Michael Fuhr | 19:53 |
| Thread | Author | Time |
|---|---|---|
| Re: User defined types | Tom Lane | 18:29 |
| HowTo change encoding type.... 📎 | Andrew M | 18:43 |
| Re: PG7.4.5: query not using index on date column | Tom Lane | 18:44 |
| Type Inheritance | Andrew Thorley | 21:47 |
| Thread | Author | Time |
|---|---|---|
| select with a function | Jaime Casanova | 06:41 |
| Re: HowTo change encoding type.... | Peter Eisentraut | 07:30 |
| tutorials for complex.sql & complex.c | Andrew Thorley | 09:56 |
| Re: tutorials for complex.sql & complex.c | Richard Huxton | 10:26 |
| Querying a list field against another list | Aarni Ruuhimäki | 14:17 |
| Re: Querying a list field against another list | Bruno Wolff III | 15:56 |
| Re: Type Inheritance | Tom Lane | 18:14 |
| Way to stop recursion? | Jonathan Knopp | 21:03 |
| Re: Way to stop recursion? | Tom Lane | 21:31 |
| Re: Way to stop recursion? | Andrew Sullivan | 21:34 |
| Re: Way to stop recursion? | Andrew Sullivan | 21:36 |
| Re: Way to stop recursion? | Jonathan Knopp | 21:53 |
| Re: Way to stop recursion? | Pierre-Frédéric Caillaud | 22:21 |
| Re: Querying a list field against another list | m | 23:04 |
| Re: Way to stop recursion? | Jonathan Knopp | 23:56 |
| Thread | Author | Time |
|---|---|---|
| how many JOINs ? | Konstantin Danilov | 11:11 |
| Re: Type Inheritance | Andrew Thorley | 14:04 |
| Re: Type Inheritance | Andrew Thorley | 15:33 |
| update/insert data | Keith Worthington | 17:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [despammed] update/insert data | Kretschmer Andreas | 13:45 |
| Thread | Author | Time |
|---|---|---|
| count record in plpgsql | Nurdin | 02:31 |
| Re: count record in plpgsql | Tomasz Myrta | 09:30 |
| Re: count record in plpgsql | Richard Huxton | 09:42 |
| version 7.4 autocommit removed | Christoph Haller | 09:47 |
| INDEX and LIKE | T E Schmitz | 12:19 |
| Re: INDEX and LIKE | Olivier Hubaut | 13:45 |
| Re: PG7.4.5: query not using index on date column | Dave Steinberg | 16:19 |
| Crystal Report + Bytea field | sreejith s | 17:01 |
| stored procedures in postgresql user plpgsql | RobertD.Stewart | 18:37 |
| Re: Way to stop recursion? 📎 | Chris Travers | 19:13 |
| grouping a many to many relation set | Johan Henselmans | 20:26 |
| Re: stored procedures in postgresql user plpgsql | Michael Fuhr | 22:25 |
| Thread | Author | Time |
|---|---|---|
| create stored procedure from temporary table | Nurdin | 02:57 |
| Re: create stored procedure from temporary table | Christopher Browne | 04:09 |
| Re: TEXT::CIDR/INET::CIDR output confusion | Bruce Momjian | 04:49 |
| Re: stored procedures in postgresql user plpgsql | Michael Fuhr | 04:56 |
| Re: TEXT::CIDR/INET::CIDR output confusion | Tom Lane | 05:07 |
| session-wide autocommit off | Christoph Haller | 08:40 |
| Re: [despammed] session-wide autocommit off | Andreas Kretschmer | 09:03 |
| Re: grouping a many to many relation set | Richard Huxton | 09:25 |
| Re: session-wide autocommit off | Richard Huxton | 09:26 |
| Re: session-wide autocommit off | Christoph Haller | 12:08 |
| inserting values into types | Andrew Thorley | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: inserting values into types | Michael Fuhr | 00:17 |
| Re: grouping a many to many relation set | Johan Henselmans | 05:57 |
| order by problem | Simon Moses | 06:14 |
| SET AUTOCOMMIT TO OFF | Christoph Haller | 14:20 |
| Re: SET AUTOCOMMIT TO OFF | Tom Lane | 15:42 |
| find the "missing" rows | Kevin B. | 15:43 |
| Re: inserting values into types | Michael Fuhr | 17:53 |
| Found Large Files.. what objects are they? | Yudie | 18:07 |
| Query is slower | Sandro Joel Eller | 19:26 |
| Re: Found Large Files.. what objects are they? | Michael Fuhr | 20:09 |
| Re: Found Large Files.. what objects are they? | Tom Lane | 20:10 |
| Re: Query is slower | Michael Fuhr | 20:31 |
| Re: inserting values into types | Andrew Thorley | 21:58 |
| Re: inserting values into types | Tom Lane | 22:11 |
| Re: Query is slower | Stephan Szabo | 22:23 |
| Re: inserting values into types | Karsten Hilbert | 22:43 |
| Re: Found Large Files.. what objects are they? | Christopher Browne | 22:46 |
| Thread | Author | Time |
|---|---|---|
| Re: find the "missing" rows | Tom Lane | 01:53 |
| invalid 'having' clause | Iain | 02:22 |
| Re: grouping a many to many relation set | Michael Fuhr | 02:45 |
| Re: invalid 'having' clause | Tom Lane | 02:54 |
| Re: SET AUTOCOMMIT TO OFF | sad | 05:11 |
| Re: order by problem | Tomasz Myrta | 07:18 |
| Re: invalid 'having' clause | Iain | 07:46 |
| Re: SET AUTOCOMMIT TO OFF | Richard Huxton | 08:56 |
| Re: order by problem | Richard Huxton | 09:03 |
| Re: find the "missing" rows | Andrew - Supernews | 10:07 |
| Thread | Author | Time |
|---|---|---|
| Failed system call was shmget(key=1, size=1155072, 03600). | Andrew M | 09:00 |
| Re: Failed system call was shmget(key=1, size=1155072, 03600). | Achilleus Mantzios | 14:09 |
| Re: Failed system call was shmget(key=1, size=1155072, 03600). | Andrew Sullivan | 17:19 |
| Re: grouping a many to many relation set | Johan Henselmans | 20:02 |
| sum query | Keith Worthington | 21:33 |
| Thread | Author | Time |
|---|---|---|
| Re: [despammed] sum query | Andreas Kretschmer | 09:41 |
| Re: sum query | Andrew - Supernews | 12:38 |
| Re: sum query | Kretschmer Andreas | 15:14 |
| Thread | Author | Time |
|---|---|---|
| Re: inserting values into types | Yasir Malik | 04:13 |
| Making dirty reads possible? | Ellert van Koperen | 17:48 |
| Thread | Author | Time |
|---|---|---|
| Re: inserting values into types | Michael Fuhr | 04:03 |
| Postgesql 8 beta 5: ecpg and date type - Access violations | Paulo Assis | 04:18 |
| Making dirty reads possible? | pgsql-sql | 17:35 |
| Set Returning Function problem | Alvaro Nunes Melo | 18:06 |
| Re: Set Returning Function problem | Tom Lane | 18:47 |
| MO: SQL Query Performance tips | Michael Ossareh | 21:06 |
| Re: Making dirty reads possible? | Greg Stark | 21:28 |
| Re: Making dirty reads possible? | Josh Berkus | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Insert successful but data not found | Mian Yong Leow | 02:58 |
| Re: Making dirty reads possible? | Pierre-Frédéric Caillaud | 08:27 |
| Thread | Author | Time |
|---|---|---|
| Unresolved external: tgetent | Christoph Haller | 12:50 |
| Indexing Strategy | Matthew Engelbert | 19:21 |
| Thread | Author | Time |
|---|---|---|
| filtering | Kevin B. | 15:25 |
| parse error at or near "(" -- Huh??? | Alex Beamish | 20:19 |
| Thread | Author | Time |
|---|---|---|
| Query is not using index when it should | Tomas =?iso-8859-1?q?Sk=E4re?= | 11:40 |
| Cast NULL into Timestamp? | Wei Weng | 19:24 |
| Create Calendar | Muhyiddin A.M Hayat | 19:26 |
| Re: Indexing Strategy | Josh Berkus | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Re: [GENERAL] Query is not using index when it should | Tomas =?iso-8859-1?q?Sk=E4re?= | 08:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Similar tables, different indexes performance | Bruno Wolff III | 05:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexing Strategy | Josh Berkus | 02:29 |
| Updating column to link one table to another | Mark Collette | 10:07 |
| Join issue? | Marian POPESCU | 15:10 |
| Join issue? | Marian POPESCU | 15:21 |
| Re: Join issue? | Stephan Szabo | 15:46 |
| [Fwd: Majordomo results: unsubscribe] | Jodi Kanter | 16:01 |
| Re: [SQL] [Fwd: Majordomo results: unsubscribe] | Richard Huxton | 16:17 |
| Breadth first traversal in PLSQL (How to implement Queue?) | Richard Rowell | 18:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Breadth first traversal in PLSQL (How to implement Queue?) | Mike Rylander | 02:48 |
| Re: Breadth first traversal in PLSQL (How to implement Queue?) | Mike Rylander | 03:23 |
| Re: Breadth first traversal in PLSQL (How to implement Queue?) | Andrew - Supernews | 03:37 |
| Query aid | Roberto Fichera | 10:34 |
| question about index | Jerome Alet | 10:41 |
| Re: [despammed] question about index | Andreas Kretschmer | 11:01 |
| Re: Query aid | Janning Vygen | 11:21 |
| Re: question about index | D'Arcy J.M. Cain | 11:30 |
| Re: Query aid | Roberto Fichera | 11:41 |
| Re: [despammed] question about index | Bruno Wolff III | 14:10 |
| Re: [despammed] question about index | Andreas Kretschmer | 14:15 |
| get branches & childs from database | Marcus Krause | 21:23 |
| plpgsql.. SELECT INTO ... WHERE FIELD LIKE | Yudie | 23:53 |