Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Sometimes referential integrity seems not to work | Stephan Szabo | 05:48 |
| Re: An order by question | Michael Fuhr | 13:34 |
| Re: An order by question | Tomasz Myrta | 17:22 |
| Re: An order by question | Michael Fuhr | 19:11 |
| Re: Executing dynamic queries (EXECUTE) | Tomasz Myrta | 19:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Help! Error with postgresql! | Paul Hart | 02:33 |
| Re: update more than 1 table (mysql to postgres) | postgres | 02:46 |
| Re: update more than 1 table (mysql to postgres) | Christopher Browne | 03:21 |
| Re: update more than 1 table (mysql to postgres) | Tom Lane | 04:26 |
| Re: Executing dynamic queries (EXECUTE) | Carla Mello | 10:37 |
| SQL query | Paul Czubilinski | 15:10 |
| Re: | Richard Huxton | 15:32 |
| Re: Sometimes referential integrity seems not to work | Jan Wieck | 16:54 |
| Re: Sometimes referential integrity seems not to work | scott.marlowe | 18:40 |
| Re: Sometimes referential integrity seems not to work | Rod Taylor | 18:44 |
| Novice SQL Question | Terry Lee Tucker | 22:38 |
| Re: Novice SQL Question | Terry Lee Tucker | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Novice SQL Question | Tom Lane | 03:14 |
| Outer join | Russell Shaw | 06:28 |
| Re: Outer join | Tomasz Myrta | 06:35 |
| Re: Outer join | Russell Shaw | 06:44 |
| request to plsql tutorial | arun raj | 13:06 |
| Re: Sometimes referential integrity seems not to work | Jan Wieck | 13:32 |
| Re: locking problem | Christoph Haller | 15:08 |
| date function problem | mohan | 15:51 |
| Re: date function problem | Larry Rosenman | 16:01 |
| Re: date function problem | Tomasz Myrta | 16:03 |
| Re: Sometimes referential integrity seems not to work | scott.marlowe | 16:27 |
| Re: Sometimes referential integrity seems not to work | scott.marlowe | 16:31 |
| [No subject] | Prashanthi Muthyala | 17:46 |
| Re: | scott.marlowe | 20:36 |
| Re: | Richard Huxton | 20:51 |
| Re: request to plsql tutorial | Richard Huxton | 20:54 |
| Re: | Jan Wieck | 22:52 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL query | daq | 07:43 |
| Update from same table | Jürgen Cappel | 16:46 |
| Re: Update from same table | Josh Berkus | 17:28 |
| TIME ZONE SQL | Raman | 17:57 |
| Re: TIME ZONE SQL | Richard Huxton | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Slow sub-selects, max and count(*) | Richard Sydney-Smith | 01:48 |
| Re: Slow sub-selects, max and count(*) | Josh Berkus | 05:13 |
| Re: Slow sub-selects, max and count(*) | Iain | 06:42 |
| Re: Slow sub-selects, max and count(*) | Richard Sydney-Smith | 07:53 |
| Re: TIME ZONE SQL | Raman | 08:28 |
| Re: TIME ZONE SQL | Richard Huxton | 11:00 |
| Re: TIME ZONE SQL | Raman Garg | 14:59 |
| Re: TIME ZONE SQL | Richard Huxton | 16:31 |
| Re: TIME ZONE SQL | Tom Lane | 16:54 |
| Could not convert UTF-8 to ISO8859-1 | Chris Anderson | 23:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow sub-selects, max and count(*) | Bruno Wolff III | 03:39 |
| Re: Slow sub-selects, max and count(*) | Josh Berkus | 03:59 |
| Seq scan on zero-parameters function | Octavio Alvarez | 07:19 |
| [Fwd: Re: [PERFORM] Seq scan on zero-parameters function] | Tomasz Myrta | 07:28 |
| Re: Seq scan on zero-parameters function | Octavio Alvarez | 08:43 |
| Re: Seq scan on zero-parameters function | Richard Huxton | 08:50 |
| Re: [PERFORM] Seq scan on zero-parameters function | Tomasz Myrta | 08:55 |
| unsubscribe | jan bok | 11:33 |
| alias problem on join | Gary Stainburn | 11:38 |
| Re: alias problem on join | Tomasz Myrta | 11:46 |
| Re: Storing a range of numbers | CoL | 13:56 |
| Re: Seq scan on zero-parameters function | Tom Lane | 14:55 |
| Re: Cool ORDER BY feature | Jeff Boes | 16:17 |
| unsubscribe | Mona H. Kapadia | 17:15 |
| Re: [PERFORM] Seq scan on zero-parameters function | Octavio Alvarez | 17:24 |
| Re: Storing a range of numbers | Chris Fisher | 20:17 |
| Thread | Author | Time |
|---|---|---|
| techniques for manual ordering of data ? | Peter Galbavy | 10:47 |
| Re: Storing a range of numbers | Tom Lane | 20:53 |
| Thread | Author | Time |
|---|---|---|
| determining how many products are in how many categories | David Garamond | 17:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Implementation of a bag pattern using rules | Robert Creager | 03:25 |
| Error in declaring %rowtype for recurrence | Kumar | 06:41 |
| Re: Bug or Feature? | Tom Lane | 08:29 |
| Re: Error in declaring %rowtype for recurrence | Tom Lane | 08:32 |
| Re: Error in declaring %rowtype for recurrence | Kumar | 09:44 |
| writing a dynamic sql | Senthil Kumar S | 09:48 |
| Trace for postgreSQL | beyaNet Consultancy | 12:04 |
| Unique Constraint with foreign Key | mohan | 17:03 |
| max timestamp | Michael Sterling | 18:14 |
| Bug or Feature? | Herbert R. Ambos | 19:48 |
| Re: max timestamp | boyd (remove_) tb_moore_@bealenet_.com | 19:50 |
| Re: Unique Constraint with foreign Key | Bruno Wolff III | 20:15 |
| Unable to convert date to tm | Ramiro Arenas R | 20:45 |
| Thread | Author | Time |
|---|---|---|
| Elegant way to monitor for changes in a trigger and migrate record to history table | David B | 01:18 |
| Re: Elegant way to monitor for changes in a trigger and migrate | Mark Gibson | 08:39 |
| bytea or blobs? | beyaNet Consultancy | 13:05 |
| unsubscribe | Mona | 19:45 |
| Re: Multiple outer join on same table | Markus Bertheau | 21:23 |
| Re: Unique Constraint with foreign Key | Greg Patnude | 23:33 |
| Re: determining how many products are in how many categories | Greg Patnude | 23:43 |
| Thread | Author | Time |
|---|---|---|
| 7.4 - FK constraint performance | ow | 00:06 |
| Re: 7.4 - FK constraint performance | Stephan Szabo | 01:06 |
| Re: 7.4 - FK constraint performance | Tom Lane | 03:12 |
| cascade delete | sad | 07:33 |
| Re: cascade delete | sad | 08:45 |
| ORDER BY TIMESTAMP_column ASC, NULL first | Fredrik Wendt | 10:06 |
| Function | Sumita Biswas (sbiswas) | 11:40 |
| How to avoid nulls while writing string for dynamic query | Kumar | 12:31 |
| Re: How to avoid nulls while writing string for dynamic query | Tomasz Myrta | 12:43 |
| Re: 7.4 - FK constraint performance | ow | 14:05 |
| Re: array_lower /array_prepend doubt | Bruce Momjian | 15:10 |
| Re: 7.4 - FK constraint performance | Stephan Szabo | 15:37 |
| Re: 7.4 - FK constraint performance | ow | 15:53 |
| Re: 7.4 - FK constraint performance | Tom Lane | 15:54 |
| Re: 7.4 - FK constraint performance | Stephan Szabo | 16:04 |
| test | beyaRecords - The home Urban music | 17:05 |
| Re: 7.4 - FK constraint performance | ow | 21:49 |
| Re: array_lower /array_prepend doubt | Joe Conway | 23:25 |
| Re: array_lower /array_prepend doubt | Bruce Momjian | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] 7.4 - FK constraint performance | Stephan Szabo | 16:41 |
| Re: Passing composite values to functions | Tom Lane | 18:38 |
| Re: bytea or blobs? | Dana Hudes | 18:44 |
| Re: ORDER BY TIMESTAMP_column ASC, NULL first | Rod Taylor | 19:02 |
| Re: Function | Stephan Szabo | 19:36 |
| Re: max timestamp | Bruno Wolff III | 19:51 |
| Re: writing a dynamic sql | Tomasz Myrta | 19:53 |
| Re: max timestamp | Robert Creager | 20:00 |
| Re: max timestamp | Tomasz Myrta | 20:01 |
| Re: ORDER BY TIMESTAMP_column ASC, NULL first | Stephan Szabo | 20:01 |
| Re: max timestamp | Stephan Szabo | 20:03 |
| Re: ORDER BY TIMESTAMP_column ASC, NULL first | Tomasz Myrta | 20:11 |
| Re: returning multiple resultset? | Tom Lane | 21:21 |
| Re: Unable to convert date to tm | Tom Lane | 22:02 |
| Thread | Author | Time |
|---|---|---|
| Re: umlimited arguments on function | Robert Treat | 02:45 |
| CHAR(n) always trims trailing spaces in 7.4 | news.postgresql.org | 03:29 |
| Re: ORDER BY TIMESTAMP_column ASC, NULL first | Denis | 07:57 |
| Re: Function | Sumita Biswas (sbiswas) | 08:12 |
| Re: max timestamp | Denis | 08:57 |
| Getting the week of a date | Kumar | 12:10 |
| Re: Getting the week of a date | Robert Creager | 12:43 |
| Re: Getting the week of a date | Richard Huxton | 13:03 |
| Date format problems | Mark Roberts | 13:06 |
| Re: Getting the week of a date | sad | 13:08 |
| Re: Getting the week of a date | sad | 13:23 |
| Re: Date format problems | Tom Lane | 15:34 |
| Re: Date format problems | Mark Roberts | 15:56 |
| Tip: a function for creating a remote view using dblink | Mark Gibson | 16:05 |
| SQL query seach + rearranging results | lowdog | 16:07 |
| Re: Date format problems | Tom Lane | 16:30 |
| Re: Function | Stephan Szabo | 17:39 |
| Re: nextval problem | Greg Patnude | 17:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Getting the week of a date | Kumar | 05:10 |
| Re: Getting the week of a date | Kumar | 05:46 |
| Re: Tip: a function for creating a remote view using dblink | Karsten Hilbert | 09:08 |