Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| How To Increment A Field Value By Function | cn | 03:17 |
| Outer Joins | Marc Rohloff | 08:02 |
| Re(2): Large Object dump ? | pgsql-sql | 09:34 |
| Re: Re(2): Large Object dump ? | Karel Zak | 10:18 |
| Re: Outer Joins | Grant Finnemore | 11:56 |
| Re(2): Re(2): Large Object dump ? | pgsql-sql | 13:44 |
| Help! Storing trees in Postgres | Sergei O . Naumov | 14:02 |
| Re: Problem with coalesce.. | Continuing Technical Education | 15:01 |
| Re: Problem with coalesce.. | Stephan Szabo | 16:50 |
| Re: Outer Joins | Josh Berkus | 17:01 |
| Re: INSERT [IGNORE] INTO TABLE | Najm Hashmi | 17:56 |
| Thread | Author | Time |
|---|---|---|
| Timespan / interval calculations? | Petter Reinholdtsen | 02:13 |
| Re: INSERT [IGNORE] INTO TABLE | Bruce Momjian | 03:38 |
| Re: Outer Joins | Marc Rohloff | 07:11 |
| Antw: Outer Joins | Gerhard Dieringer | 07:55 |
| Re: [SQL] Re: Problem with coalesce.. | Tom Lane | 08:09 |
| Re: Outer Joins | Josh Berkus | 16:37 |
| Re: Outer Joins | Josh Berkus | 16:55 |
| Re: Re(2): Re(2): Large Object dump ? | Tom Lane | 17:17 |
| PL/PGSQL beginning is hard.... | Bruno Boettcher | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: PL/PGSQL beginning is hard.... | Stephan Szabo | 00:49 |
| user defined functions in Java ? | Umashankar Kotturu | 03:32 |
| Connecting to Postgres from Windows | Umashankar Kotturu | 03:50 |
| Urgent trigger problem. | Carolyn Lu Wong | 11:41 |
| Subqueries in from clause | Pierre Habraken | 17:36 |
| Re: Subqueries in from clause | Tom Lane | 17:48 |
| need help urgent | Jie Liang | 19:35 |
| Re: user defined functions in Java ? | Peter Eisentraut | 20:02 |
| RE: [SQL] really need help 📎 | Schlobohm, Jack | 21:45 |
| Re: Connecting to Postgres from Windows | Indraneel Majumdar | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Meaning of "REMINDER from pgsql..." | [email protected] | 15:30 |
| Re: Help! Storing trees in Postgres | kovacsz | 20:09 |
| PLPGSQL performance | kovacsz | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Question about ordering views | hubert depesz lubaczewski | 11:44 |
| Time penalty on VIEWS on VIEWS | hubert depesz lubaczewski | 11:50 |
| Help with GROUP BY | Jean-Christophe Boggio | 18:03 |
| Conditional SQL query | Indraneel Majumdar | 19:03 |
| Re: Conditional SQL query | Cristóvão B. B. Dalla Costa | 21:46 |
| Re: Conditional SQL query | Cristóvão B. B. Dalla Costa | 22:44 |
| Thread | Author | Time |
|---|---|---|
| Returning Recordsets from Stored-procs | Marc Rohloff | 08:15 |
| Re: Conditional SQL query | Indraneel Majumdar | 09:07 |
| Re: Returning Recordsets from Stored-procs | Grant Finnemore | 09:39 |
| Re: Conditional SQL query | Indraneel Majumdar | 10:00 |
| Re: Conditional SQL query | Indraneel Majumdar | 10:23 |
| Re: Returning Recordsets from Stored-procs | Andreas Tille | 11:10 |
| Timing trouble with GROUP BY PostgreSQL / Oracle ? | Hervé Piedvache | 17:51 |
| Thread | Author | Time |
|---|---|---|
| UNION in views | Roberto Mello | 00:41 |
| SQL question regarding a couple of table joins. | Warren Vanichuk | 00:49 |
| RE: SQL question regarding a couple of table joins. | Edmar Wiggers | 01:14 |
| Re: UNION in views | Tom Lane | 01:49 |
| Re: Re: Returning Recordsets from Stored-procs | Najm Hashmi | 15:53 |
| RE: reinitialise serial counter | Edmar Wiggers | 16:55 |
| Trouble Converting Dates | Kate Collins | 17:18 |
| Cascading a pseudo-delete? | Brian Powell | 17:45 |
| Display of RI triggers | Larry Rosenman | 18:50 |
| reinitialise serial counter | Indraneel Majumdar | 21:30 |
| how to index a numeric(12,2) column? | Forest Wilkinson | 22:57 |
| Re: how to index a numeric(12,2) column? | Tom Lane | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Table secure problem. | Mateusz Mazur | 13:26 |
| Oracle, ODBC, MS IIS -> problem! | ANDREAS STEINBACH | 14:50 |
| ./configure problems | rocael | 17:24 |
| Re: how to index a numeric(12,2) column? | Forest Wilkinson | 18:49 |
| Re: how to index a numeric(12,2) column? | Tom Lane | 19:06 |
| shared memory problem | rocael | 19:17 |
| Thread | Author | Time |
|---|---|---|
| Re: shared memory problem | Tom Lane | 02:41 |
| alter table add column implementation undesirable? | Forest Wilkinson | 03:55 |
| alter pg_shadow | pgsql-sql | 06:26 |
| shared memory blocks? | rocael | 07:26 |
| insert value of form - checkboxes | Astrid Hexsel | 08:05 |
| Re: ./configure problems | Jerome Alet | 08:30 |
| Re: insert value of form - checkboxes | Antti Linno | 08:41 |
| Rules | Peeter Smitt | 08:50 |
| how to write it in most efficient way? | hubert depesz lubaczewski | 13:20 |
| Re: alter table add column implementation undesirable? | Tom Lane | 15:31 |
| Re: [SQL] alter pg_shadow | Peter Eisentraut | 15:53 |
| Re: [sql]Joins | Stephan Szabo | 16:24 |
| Re: Oracle, ODBC, MS IIS -> problem! | Josh Berkus | 16:25 |
| Requests for Development | Josh Berkus | 16:40 |
| Re: shared memory blocks? | Poul L. Christiansen | 16:45 |
| Re: [sql]Joins | Cristóvão B. B. Dalla Costa | 18:59 |
| Re: Requests for Development | Roberto Mello | 20:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Requests for Development | Andreas Tille | 07:43 |
| Re: Requests for Development | Gerhard Dieringer | 08:26 |
| Return from stored procedures | Graham Vickrage | 09:24 |
| Re: Re: Requests for Development | KuroiNeko | 10:00 |
| Re: Return from stored procedures | Kovacs Zoltan Sandor | 11:08 |
| sorting the text values as integers | Sandis Jerics | 11:55 |
| [sql]Joins | Najm Hashmi | 15:59 |
| SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Christophe Boyanique | 16:25 |
| Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Tom Lane | 16:35 |
| Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Christophe Boyanique | 16:45 |
| Re: SELECT FROM t1 WHERE id IN (SELECT id FROM t2 UNION SELECT id FROM t3) | Tomas Berndtsson | 18:10 |
| special caracters! | rocael | 19:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Using a postgres table to maintain unique id? | Dr Frog | 10:30 |
| Re: shared memory problem | Michael Teter | 12:17 |
| Re: shared memory problem | Tom Lane | 15:32 |
| Using a postgres table to maintain unique id? | Steve Wampler | 17:13 |
| Re: Using a postgres table to maintain unique id? | Poet/Joshua Drake | 17:26 |
| Re: Using a postgres table to maintain unique id? | Steve Wampler | 17:44 |
| Re: Using a postgres table to maintain unique id? | Forest Wilkinson | 18:53 |
| Re: Using a postgres table to maintain unique id? | Steve Wampler | 19:36 |
| how to continue a transaction after an error? | Cristi Petrescu-Prahova | 19:41 |
| Re: how to continue a transaction after an error? | Stephan Szabo | 19:57 |
| Re: how to continue a transaction after an error? | Ross J. Reedstrom | 20:08 |
| RE: how to continue a transaction after an error? | Edmar Wiggers | 20:13 |
| Re: Using a postgres table to maintain unique id? | Marten Feldtmann | 20:18 |
| Re: how to continue a transaction after an error? | Cristi Petrescu-Prahova | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Using a postgres table to maintain unique id? | Michael Teter | 02:22 |
| Re: how to continue a transaction after an error? | Philip Warner | 05:30 |
| Re: how to continue a transaction after an error? | Stephan Szabo | 06:23 |
| Re: how to continue a transaction after an error? | Philip Warner | 06:43 |
| Trigger cant find function | Graham Vickrage | 13:36 |
| Re: Trigger cant find function | Tom Lane | 16:05 |
| Re: Using a postgres table to maintain unique id? | Thomas Swan | 17:35 |
| Re: how to continue a transaction after an error? | Stephan Szabo | 17:38 |
| Re: Using a postgres table to maintain unique id? | Steve Wampler | 17:44 |
| Re: Using a postgres table to maintain unique id? | Marten Feldtmann | 20:11 |
| Using Array-Values in subselect | Alvar Freude | 20:51 |
| Re: Using Array-Values in subselect | Roberto Mello | 21:15 |
| RE: Using Array-Values in subselect | Edmar Wiggers | 21:36 |
| Re: Using Array-Values in subselect | Alvar Freude | 21:48 |
| Re: Using Array-Values in subselect | Stephan Szabo | 22:31 |
| Re: Using Array-Values in subselect | Tom Lane | 23:16 |
| Thread | Author | Time |
|---|---|---|
| FTI, paged, ranked searching and efficiency. | Paul | 01:23 |
| Re: Using Array-Values in subselect | Alvar Freude | 02:47 |
| Re: Requests for Development | Jan Wieck | 09:53 |
| Re: Re: Requests for Development | Jan Wieck | 10:20 |
| Index problem | Patrik Kudo | 16:21 |
| Re: [SQL] FTI, paged, ranked searching and efficiency. | Josh Berkus | 17:03 |
| Re: Re: [SQL] FTI, paged, ranked searching and efficiency. | Stephen van Egmond | 17:25 |
| Re: Re: [SQL] FTI, paged, ranked searching and efficiency. | Stephen van Egmond | 17:28 |
| Re: Re: [SQL] FTI, paged, ranked searching and efficiency. | Josh Berkus | 17:31 |
| Re: Re: [SQL] FTI, paged, ranked searching and efficiency. | Stephen van Egmond | 17:51 |
| Re: Index problem | Tom Lane | 18:19 |
| RE: how to continue a transaction after an error? | Mikheev, Vadim | 19:11 |
| Re: Index problem | Peter Eisentraut | 22:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Index problem | Tom Lane | 03:54 |
| [No subject] | Luis Farfn | 06:25 |
| [No subject] | turing2000 | 11:05 |
| search and replace possible on SQL? | Bruno Boettcher | 15:21 |
| Re: search and replace possible on SQL? | Jens Hartwig | 15:27 |
| [No subject] | turing2000 | 16:27 |
| Help with displaying data types. | Rob Burne | 23:25 |
| Thread | Author | Time |
|---|---|---|
| Re: how many rows? [was Re: fetching rows] | Robert B. Easter | 00:03 |
| Re: how many rows? [was Re: fetching rows]] | Roberto Mello | 00:11 |
| Re: [SQL] Requests for Development | Jonathan Ellis | 00:39 |
| Re: is there a mysql to postgresql sql converter? | Max Fonin | 12:08 |
| Re: how many rows? [was Re: fetching rows] | Johann Spies | 17:57 |
| newbie: execute an sql script | j.uy | 20:51 |
| Thread | Author | Time |
|---|---|---|
| psql question | Joe Conway | 01:38 |
| [No subject] | Sean Weissensee | 03:24 |
| Like seems to fail ! | Yves Martin | 07:28 |
| More stupid questions: prettyprinting of ints?? | Bruno Boettcher | 14:45 |
| Return number of rows update in query | Shane McEneaney | 15:08 |
| Re: More stupid questions: prettyprinting of ints?? | Bruno Boettcher | 15:08 |
| Re: MySQL -> Postgres dump converter | Clayton Cottingham | 15:18 |
| Re: MySQL -> Postgres dump converter | Clayton Cottingham | 15:18 |
| numeric conversions? | Bruno Boettcher | 15:51 |
| Re: Like seems to fail ! | Tom Lane | 15:53 |
| Re: numeric conversions? | Jonathan Ellis | 15:59 |
| pgpl-problem, what's wrong with my loop? | Bruno Boettcher | 16:21 |
| Re: pgpl-problem, what's wrong with my loop? | Tom Lane | 16:37 |
| Re: pgpl-problem, what's wrong with my loop? | Kovacs Zoltan Sandor | 17:06 |
| Re: pgpl-problem, what's wrong with my loop? | Kovacs Zoltan Sandor | 17:40 |
| Re: pgpl-problem, what's wrong with my loop? | Bruno Boettcher | 17:47 |
| Bug or feature 📎 | Kyle | 19:10 |
| MySQL -> Postgres dump converter | Max Fonin | 22:01 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | Peeter Smitt | 02:00 |
| [No subject] | Peeter Smitt | 02:08 |
| Postgres 7.0.X and arrow keys | Antti Linno | 07:29 |
| Persistent Connects (pg_pconnect) | Colleen Williams | 12:34 |
| Blob Upload | Aristeu Gil Alves Junior | 13:07 |
| Re: Persistent Connects (pg_pconnect) | Keith Wong | 13:25 |
| Re: Persistent Connects (pg_pconnect) | Keith Wong | 13:31 |
| Re: Blob Upload | Keith Wong | 13:42 |
| Re: Postgres 7.0.X and arrow keys | Peter Eisentraut | 16:29 |
| Re: Re: [SQL] Requests for Development | Jan Wieck | 17:43 |
| Problem with subquery joined to a view 📎 | Kyle | 17:51 |
| Re: Problem with subquery joined to a view | Tom Lane | 18:16 |