Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: working around setQuerySnapshot limitations in functions | Jakub Ouhrabka | 00:12 |
| Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) | Christoph Haller | 09:34 |
| join and dynamic view | Gary Stainburn | 10:58 |
| Re: join and dynamic view | Christoph Haller | 12:06 |
| Re: join and dynamic view | Gary Stainburn | 12:23 |
| Re: join and dynamic view | Christoph Haller | 13:06 |
| Re: join and dynamic view | Gary Stainburn | 13:09 |
| Re: join and dynamic view | Tomasz Myrta | 13:36 |
| Re: join and dynamic view | Christoph Haller | 13:45 |
| Re: join and dynamic view | Gary Stainburn | 14:11 |
| Re: join and dynamic view | Tomasz Myrta | 14:12 |
| Re: join and dynamic view | Christoph Haller | 14:15 |
| Re: join and dynamic view | Tomasz Myrta | 14:31 |
| Upgrade question - was Re: join and dynamic view | Gary Stainburn | 14:57 |
| Re: Upgrade question - was Re: join and dynamic view | Christoph Haller | 15:09 |
| Re: Upgrade question - was Re: join and dynamic view | Andreas Joseph Krogh | 15:23 |
| handling error in a function | Peter Gabriel | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Re: references table(multiple columns go here) | Gary Stainburn | 09:28 |
| Re: references table(multiple columns go here) | Tomasz Myrta | 09:58 |
| Re: references table(multiple columns go here) | Gary Stainburn | 10:30 |
| Re: references table(multiple columns go here) | Tomasz Myrta | 11:30 |
| Re: references table(multiple columns go here) | Gary Stainburn | 11:37 |
| unsubscribe | david williams | 12:32 |
| Re: unsubscribe | Christoph Haller | 12:39 |
| Re: unsubscribe | Robert Treat | 14:47 |
| Re: references table(multiple columns go here) | Tom Lane | 15:17 |
| Re: references table(multiple columns go here) | Gary Stainburn | 15:22 |
| Perform a Select on an Oracle Database from PG | val | 15:37 |
| Re: Perform a Select on an Oracle Database from PG | Roberto Mello | 16:05 |
| Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) | javier garcia | 16:16 |
| Thread | Author | Time |
|---|---|---|
| Help on (sub)-select | Gary Stainburn | 10:21 |
| Re: UPDATE with a SELECT and subSELECT(About comparing dates and non dates data) | Christoph Haller | 10:22 |
| Re: Help on (sub)-select | Philip Warner | 10:51 |
| Re: Help on (sub)-select | Gary Stainburn | 11:48 |
| Re: Help on (sub)-select | Philip Warner | 15:53 |
| SQL select count(*) from "myTable" failed : Relation "mytable" does not exist | Jeff Kowalczyk | 19:36 |
| Need help paging through record sets | cmccormick | 20:53 |
| Re: Need help paging through record sets | Steve Crawford | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Need help paging through record sets | Peter Galbavy | 11:57 |
| Re: Need help paging through record sets | knut.suebert | 18:32 |
| Parameterized Views on 7.3 | Terry Yapt | 19:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Password user postgres | Tomasz Myrta | 07:48 |
| Re: create index on function - why? | Philip Warner | 10:18 |
| Re: Password user postgres | Mathieu Arnold | 15:09 |
| Re: Password user postgres | Oliver Elphick | 23:27 |
| Thread | Author | Time |
|---|---|---|
| save data from views | 10:57 | |
| Re: save data from views | 11:48 | |
| Password user postgres | Arnaudo Massimo | 14:22 |
| Re: save data from views | Achilleus Mantzios | 15:09 |
| DB2 to Postgresql conversion help. | John Pauley | 16:32 |
| Re: DB2 to Postgresql conversion help. | Joe Conway | 17:13 |
| Thread | Author | Time |
|---|---|---|
| corresponding primary key for max(column)? | Jason Pyeron | 00:12 |
| COPY command problems | Nikola Ivacic | 10:23 |
| Re: COPY command problems | Tom Lane | 15:24 |
| Re: COPY command problems | Nikola Ivacic | 15:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Password user postgres | Bhuvan A | 09:03 |
| Re: Password user postgres | Arnaudo Massimo | 19:05 |
| Thread | Author | Time |
|---|---|---|
| CREATE INDEX question | Hans-Jürgen Schönig | 12:24 |
| Execution Plans and Casts | Hans-Jürgen Schönig | 12:49 |
| Thread | Author | Time |
|---|---|---|
| How can I use cursor in a trigger or function? | dailiming | 08:29 |
| Re: COPY command problems | Rajesh Kumar Mallah. | 11:17 |
| Reference integrity question | Evgen Potemkin | 13:32 |
| Re: Stuck on SQL Query where a calculated value is used for a join. | ScottRArndt | 13:57 |
| Thread | Author | Time |
|---|---|---|
| COPY fails but INSERT works | Gary Stainburn | 15:13 |
| Re: COPY fails but INSERT works | Stephan Szabo | 15:48 |
| Re: COPY fails but INSERT works | Gary Stainburn | 17:23 |
| Thread | Author | Time |
|---|---|---|
| Multiple counts | Colin Fox | 04:55 |
| Thread | Author | Time |
|---|---|---|
| Doubts porting from Oracle to postgresql | Senthil | 08:22 |
| batch example | Campano, Troy | 16:22 |
| unsubscribe | jrJAMES | 17:09 |
| unsubscribe | Rajesh Krishnamoorthy | 17:21 |
| Re: batch example | Thorsten Meinl | 17:28 |
| empty arrays | floyds | 17:40 |
| Thread | Author | Time |
|---|---|---|
| Slow self-join on a 100 million record table | Mark Davies | 15:46 |
| plpgsql select into question | J D | 15:49 |
| Re: Slow self-join on a 100 million record table | Andrew J. Kelly | 16:04 |
| Re: plpgsql select into question | Jie Liang | 19:09 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump problem | Tomasz Myrta | 11:34 |
| Re: Implementing automatic updating of primary keys... | Tomasz Myrta | 12:41 |
| Internal functions documented | Daniel Bruce Lynes | 21:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow self-join on a 100 million record table | Paul Thornett | 03:30 |
| bug? | Minghann Ho | 04:36 |
| Re: empty arrays | Tom Lane | 06:04 |
| Re: Slow self-join on a 100 million record table | Tom Lane | 06:06 |
| Re: bug? | Tom Lane | 06:16 |
| Re: Reference integrity question | Stephan Szabo | 09:42 |
| PostgreSQL X Resin EE | Pedro Igor | 13:16 |
| Re: empty arrays | Steve Crawford | 19:06 |
| Adding a Primary Key to an exisiting table | Maly Kaing | 21:15 |
| NULLL comparison in multiple column unique index | Brian Walker | 23:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding a Primary Key to an exisiting table | Bhuvan A | 05:20 |
| Re: NULLL comparison in multiple column unique index | Manfred Koizar | 13:10 |
| Query | Pedro Igor | 13:46 |
| Re: Query | Stephan Szabo | 15:57 |
| Compiling pl/pgsql functions? | Daniel Bruce Lynes | 17:27 |
| Thread | Author | Time |
|---|---|---|
| SQL to determine Tablenames, Primarykeys & Foreignkeys] | Kevin Gordon | 03:57 |
| Re: Reference integrity question | Stephan Szabo | 15:16 |
| Thread | Author | Time |
|---|---|---|
| Deleting in order from a table | pginfo | 09:26 |
| weighting (the results of) a query ? | Peter Galbavy | 10:41 |
| Re: Deleting in order from a table | Ludwig Lim | 12:18 |
| Thread | Author | Time |
|---|---|---|
| Grant execute on functions; related objects permissions ? | Cédric Dufour (public) | 10:12 |
| Re: Grant execute on functions; related objects permissions ? | Tambet Matiisen | 10:45 |
| order by and aggregate | Tomasz Myrta | 12:44 |
| Re: order by and aggregate | Richard Huxton | 13:41 |
| Re: Grant execute on functions; related objects permissions ? | Bruno Wolff III | 13:50 |
| Re: order by and aggregate | Tomasz Myrta | 14:09 |
| Sorry, to many clients already | cristi | 14:12 |
| Re: order by and aggregate | dev | 15:59 |
| Re: order by and aggregate | Tom Lane | 16:34 |
| Re: order by and aggregate | Tomasz Myrta | 16:35 |
| Re: order by and aggregate | Tom Lane | 16:36 |
| Re: order by and aggregate | Tomasz Myrta | 16:59 |
| Re: order by and aggregate | Tomasz Myrta | 17:07 |
| sub-select, view and sum() | Gary Stainburn | 17:29 |
| Re: Sorry, to many clients already | Robert Treat | 18:20 |
| Re: sub-select, view and sum() | Stephan Szabo | 18:31 |
| Re: sub-select, view and sum() | Gary Stainburn | 22:29 |