Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 12:31 |
| [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 12:36 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Tom Lane | 14:23 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 14:26 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Stuart | 22:06 |
| Thread | Author | Time |
|---|---|---|
| best paging strategies for large datasets? | Louis-David Mitterrand | 05:41 |
| Re: best paging strategies for large datasets? | Pavel Stehule | 05:45 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | silly sad | 06:00 |
| Invalid message format Exception | Gnanakumar | 10:34 |
| Re: Invalid message format Exception | Rob Sargent | 14:51 |
| Re: best paging strategies for large datasets? | Justin Graf | 15:59 |
| Re: best paging strategies for large datasets? | Justin Graf | 16:26 |
| Greetings folks, dumb question maybe? | Josh | 17:32 |
| Re: Greetings folks, dumb question maybe? | Josh | 17:57 |
| Re: Greetings folks, dumb question maybe? | Richard Broersma | 21:04 |
| Re: Greetings folks, dumb question maybe? | Little, Douglas | 21:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Invalid message format Exception | Gnanakumar | 07:04 |
| Re: best paging strategies for large datasets? | silly sad | 07:36 |
| Re: best paging strategies for large datasets? | Louis-David Mitterrand | 07:43 |
| Re: best paging strategies for large datasets? | Louis-David Mitterrand | 07:47 |
| Re: best paging strategies for large datasets? | silly sad | 08:41 |
| Re: Greetings folks, dumb question maybe? | Jasen Betts | 10:09 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Jasen Betts | 10:51 |
| Re: Greetings folks, dumb question maybe? | Joshua Tolley | 12:37 |
| Re: best paging strategies for large datasets? | Justin Graf | 13:28 |
| Re: best paging strategies for large datasets? | Justin Graf | 13:57 |
| Re: Invalid message format Exception | Rob Sargent | 15:18 |
| Thread | Author | Time |
|---|---|---|
| Postgresql database | Trinath Somanchi | 08:42 |
| Re: Postgresql database | silly sad | 09:14 |
| Re: Postgresql database | Trinath Somanchi | 09:28 |
| Re: Postgresql database | Leif Biberg Kristensen | 09:51 |
| Re: Postgresql database | silly sad | 10:23 |
| Re: Postgresql database | Little, Douglas | 13:20 |
| Thread | Author | Time |
|---|---|---|
| import ignoring duplicates 📎 | Mark Fenbers | 18:38 |
| Thread | Author | Time |
|---|---|---|
| Re: import ignoring duplicates | Tim Landscheidt | 00:32 |
| Re: import ignoring duplicates | Scott Marlowe | 06:04 |
| Re: [Trigger] Help needed with NEW.* and TG_TABLE_NAME | Torsten Zühlsdorff | 08:57 |
| Thread | Author | Time |
|---|---|---|
| How to get CURRENT_DATE in a pl/pgSQL function | Kenneth Marshall | 19:08 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Richard Broersma | 19:12 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Pavel Stehule | 19:25 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Kenneth Marshall | 19:27 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Kenneth Marshall | 19:28 |
| plperlu user function. | David Harel | 21:29 |
| Re: plperlu user function. | Alex Hunsaker | 21:36 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Tim Landscheidt | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Brian Modra | 03:48 |
| Re: plperlu user function. | silly sad | 05:38 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | silly sad | 08:26 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Tim Landscheidt | 11:18 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Jasen Betts | 11:25 |
| Re: How to get CURRENT_DATE in a pl/pgSQL function | Kenneth Marshall | 12:27 |
| user function and bind | David Harel | 14:56 |
| Re: user function and bind 📎 | Justin Graf | 16:11 |
| Re: user function and bind | Gary Chambers | 17:16 |
| Thread | Author | Time |
|---|---|---|
| [No subject] | tlange | 00:52 |
| sorry, now with subject... trigger & nextval(seq) | tlange | 00:53 |
| Re: sorry, now with subject... trigger & nextval(seq) | Adrian Klaver | 01:46 |
| Re: | Richard Broersma | 01:56 |
| [Fwd: Re: sorry, now with subject... trigger & nextval(seq)] | tlange | 07:19 |
| Re: sorry, now with subject... trigger & nextval(seq) | tlange | 07:35 |
| Re: | Craig Ringer | 08:15 |
| Re: | Richard Broersma | 14:47 |
| Access Update error: solution. | Little, Douglas | 15:23 |
| Question about slow queries... | Good, Thomas | 15:44 |
| Re: Access Update error: solution. | Torsten Lange | 16:22 |
| Thread | Author | Time |
|---|---|---|
| return %ROWTYPE from function | Anton Prokofiev | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: return %ROWTYPE from function | jr | 01:15 |
| safely exchanging primary keys? | Louis-David Mitterrand | 08:51 |
| Re: safely exchanging primary keys? | jr | 11:46 |
| Re: safely exchanging primary keys? | Louis-David Mitterrand | 14:05 |
| Re: safely exchanging primary keys? | Tom Lane | 14:22 |
| Re: safely exchanging primary keys? | Rob Sargent | 14:22 |
| Re: safely exchanging primary keys? | Tim Landscheidt | 14:38 |
| Re: safely exchanging primary keys? | Louis-David Mitterrand | 17:00 |
| Re: safely exchanging primary keys? | Louis-David Mitterrand | 17:11 |
| User function that returns a set of rows. | David Harel | 18:33 |
| Re: User function that returns a set of rows. | Joshua Tolley | 22:14 |
| Thread | Author | Time |
|---|---|---|
| Re: safely exchanging primary keys? | Tim Landscheidt | 01:22 |
| Thread | Author | Time |
|---|---|---|
| inner join and limit | Michele Petrazzo - Unipex | 17:34 |
| Rules and sequences | Ben Morrow | 18:16 |
| Re: inner join and limit | Rolando Edwards | 19:04 |
| Re: inner join and limit | Luigi Antognini | 20:13 |
| Re: inner join and limit | Tim Landscheidt | 21:03 |
| Re: inner join and limit | Rolando Edwards | 21:24 |
| cast record type to array? | Gerardo Herzig | 22:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Rules and sequences | Tom Lane | 00:04 |
| Re: Rules and sequences | A. Kretschmer | 06:20 |
| Do not understand "SETOF RECORD" - therefore can not use ODBC-link | Harrie Rodenbach | 08:23 |
| Check set of date intervals | Anton Gavazuk | 10:07 |
| Re: Check set of date intervals | A. Kretschmer | 10:27 |
| Re: Check set of date intervals | A. Kretschmer | 10:43 |
| Re: Check set of date intervals | A. Kretschmer | 12:45 |
| Fw: Re: help | James Kitambara | 13:55 |
| Re: Question about slow queries... | Tom Lane | 14:03 |
| Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link | Tom Lane | 14:05 |
| Re: Question about slow queries... | A. Kretschmer | 14:09 |
| Re: Rules and sequences | Ben Morrow | 16:28 |
| Extending Regular Expression bounds limit of 255. | Brent DeSpain | 19:33 |
| Re: Extending Regular Expression bounds limit of 255. | Andrej | 20:59 |
| Re: Extending Regular Expression bounds limit of 255. | Brent DeSpain | 22:44 |
| Re: Extending Regular Expression bounds limit of 255. | Brent DeSpain | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Do not understand "SETOF RECORD" - therefore can not use ODBC-link | Harrie Rodenbach | 07:32 |
| ODBC-link returns zero rows, allthough query should return 3 rows | Reinier Suurenbroek | 08:07 |
| Re: cast record type to array? | Jasen Betts | 10:31 |
| Re: Extending Regular Expression bounds limit of 255. | alvherre | 15:14 |
| Re: Extending Regular Expression bounds limit of 255. | Brent DeSpain | 15:44 |
| Re: cast record type to array? | Gerardo Herzig | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Extending Regular Expression bounds limit of 255. | Jasen Betts | 10:27 |
| Re: Extending Regular Expression bounds limit of 255. | Tim Landscheidt | 18:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Extending Regular Expression bounds limit of 255. | Jasen Betts | 10:37 |
| Thread | Author | Time |
|---|---|---|
| Re: sorry, now with subject... trigger & nextval(seq) 📎 | Daniel Migowski | 11:05 |
| Thread | Author | Time |
|---|---|---|
| how to construct sql | Wes James | 16:48 |
| Re: how to construct sql | Oliveiros | 16:55 |
| Re: how to construct sql | Hiltibidal, Rob | 17:06 |
| Re: how to construct sql | Wes James | 17:31 |
| Re: how to construct sql | Plugge, Joe R. | 19:51 |
| Re: how to construct sql | Wes James | 19:52 |
| Re: how to construct sql | Wes James | 20:04 |
| Re: how to construct sql 📎 | Justin Graf | 20:44 |
| Re: how to construct sql 📎 | Justin Graf | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: inner join and limit | Harald Fuchs | 16:08 |
| Thread | Author | Time |
|---|---|---|
| sum an alias | Wes James | 02:16 |
| Re: sum an alias | A. Kretschmer | 05:54 |
| Re: how to construct sql | Jasen Betts | 10:01 |
| Re: sum an alias | Wes James | 13:30 |
| Re: sum an alias | Oliveiros d'Azevedo Cristina | 13:44 |
| Thread | Author | Time |
|---|---|---|
| Difference between these two queries ? | Nilesh Govindarajan | 02:30 |
| Re: [SQL] Difference between these two queries ? | Sergey Konoplev | 09:04 |
| Re: inner join and limit | msi77 | 14:58 |
| Re: [SQL] Difference between these two queries ? | Little, Douglas | 15:15 |
| Re: [SQL] Difference between these two queries ? | Sam Mason | 15:36 |
| Re: Difference between these two queries ? | Nilesh Govindarajan | 16:34 |
| Thread | Author | Time |
|---|---|---|
| Multiple subquery with insert into command ? | reyman | 16:22 |
| Re: Multiple subquery with insert into command ? | msi77 | 16:59 |
| Re: Multiple subquery with insert into command ? | reyman | 22:25 |
| Thread | Author | Time |
|---|---|---|
| Casts in foreign schemas | Ben Morrow | 14:33 |
| Re: Casts in foreign schemas | Tom Lane | 14:50 |
| Some insight on the proper SQL would be appreciated | Aaron Burnett | 17:04 |
| Re: Some insight on the proper SQL would be appreciated | Oliveiros d'Azevedo Cristina | 17:55 |
| Re: Some insight on the proper SQL would be appreciated | Mikhail V. Puzanov | 17:58 |
| Re: Some insight on the proper SQL would be appreciated | Aaron Burnett | 18:16 |
| Re: Some insight on the proper SQL would be appreciated | Aaron Burnett | 18:20 |
| Thread | Author | Time |
|---|---|---|
| what does this do | John | 09:22 |
| Re: what does this do | Tim Landscheidt | 10:57 |
| Re: what does this do | Richard Broersma | 13:42 |
| Re: what does this do | Little, Douglas | 13:46 |
| Re: what does this do | John | 14:03 |
| Re: what does this do | Tim Landscheidt | 14:56 |
| Returning to default (e.g. blank) table permissions after a revoke? | Bryce Nesbitt | 18:48 |
| Thread | Author | Time |
|---|---|---|
| is there a tutorial on window functions? | John | 14:17 |
| Re: is there a tutorial on window functions? | Andreas Kretschmer | 14:37 |
| Re: is there a tutorial on window functions? | Thomas Kellerer | 14:39 |
| Re: is there a tutorial on window functions? | Kenneth Marshall | 14:49 |
| Re: is there a tutorial on window functions? | John | 14:54 |
| Thread | Author | Time |
|---|---|---|
| oracle to postgres migration question | Joshua Gooding | 19:09 |
| Re: oracle to postgres migration question | Bruce Momjian | 19:54 |
| Re: oracle to postgres migration question | Scott Marlowe | 20:07 |
| Re: oracle to postgres migration question | Stephen Frost | 20:17 |
| Re: oracle to postgres migration question | Stephen Frost | 20:19 |
| Re: oracle to postgres migration question | Reinoud van Leeuwen | 21:10 |
| Re: oracle to postgres migration question | Scott Marlowe | 21:14 |
| Re: oracle to postgres migration question | Bruce Momjian | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: oracle to postgres migration question | silly sad | 05:02 |
| Re: oracle to postgres migration question | Joshua Gooding | 11:50 |
| Re: oracle to postgres migration question | Stephen Frost | 12:28 |
| Re: oracle to postgres migration question | Chris Browne | 19:42 |
| Re: oracle to postgres migration question | Scott Marlowe | 20:53 |
| Thread | Author | Time |
|---|---|---|
| running scripts like oracle sqlplus | Steven Dahlin | 22:24 |
| Thread | Author | Time |
|---|---|---|
| error on line 1 trying to execute a script using psql | Steven Dahlin | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Re: running scripts like oracle sqlplus | Kenneth Marshall | 18:52 |
| Re: running scripts like oracle sqlplus | Brian Sherwood | 21:01 |
| Re: error on line 1 trying to execute a script using psql | Tim Landscheidt | 21:44 |
| Thread | Author | Time |
|---|---|---|
| Re: error on line 1 trying to execute a script using psql | A. Kretschmer | 05:08 |
| How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL | venkat | 10:48 |
| Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL | Thom Brown | 14:38 |
| Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL | Stephane Bortzmeyer | 14:40 |
| Re: [SQL] How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL | Pavel Stehule | 14:40 |
| ORDER BY is case insensitive | Bryan White | 20:52 |
| Re: ORDER BY is case insensitive | Gerardo Herzig | 21:32 |
| Re: ORDER BY is case insensitive | Tom Lane | 21:40 |
| Thread | Author | Time |
|---|---|---|
| Re: How to Insert and retrieve multilingual (Hindi "an Indian language") into PostgreSQL | silly sad | 06:11 |
| Re: ORDER BY is case insensitive | Jasen Betts | 13:45 |
| Re: COPY command and required file permissions | bruno.scovoli | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Re: ORDER BY is case insensitive | silly sad | 04:49 |
| question about partitioning | Joshua Gooding | 13:05 |
| Re: question about partitioning | Jasen Betts | 15:06 |
| Re: ORDER BY is case insensitive | Bryan White | 17:26 |
| Re: question about partitioning | Joshua Gooding | 19:31 |
| Re: question about partitioning | Little, Douglas | 19:37 |
| Re: question about partitioning | Joshua Gooding | 19:51 |
| Re: question about partitioning 📎 | Petru Ghita | 20:17 |
| differences between function returning 'setof table' and 'table' | Gerardo Herzig | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Average of Array? | Lee Hachadoorian | 16:21 |
| Re: Average of Array? | Tom Lane | 16:29 |
| Re: Average of Array? | Pavel Stehule | 16:29 |
| Re: Average of Array? | Lee Hachadoorian | 16:34 |
| enforcing constraints across multiple tables | Andrew Geery | 17:52 |
| Re: COPY command and required file permissions | Adrian Klaver | 18:37 |
| Re: enforcing constraints across multiple tables | Tim Landscheidt | 19:01 |
| Re: Average of Array? | Ireneusz Pluta | 19:33 |