Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Question about insert/update RULEs. | Dmitri Bichko | 11:45 |
| Easier way to 'strip' on multiple matches? | Marc G. Fournier | 18:32 |
| Thread | Author | Time |
|---|---|---|
| SQL Query Performance tips | Michael Ossareh | 10:00 |
| return value of the trigger function | Jarek Pudełko | 14:15 |
| TEXT type blob extraction in ecpg | none none | 17:43 |
| TEXT blob extraction in ecpg | none none | 18:02 |
| Re: TEXT blob extraction in ecpg | Michael Fuhr | 21:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Question about insert/update RULEs. | Ron Peterson | 02:14 |
| Parsing a Calculation from a field | Kieran Ashley | 11:20 |
| Re: Parsing a Calculation from a field | Richard Huxton | 11:35 |
| Re: simulating row ownership | Ron Peterson | 13:38 |
| Re: simulating row ownership | Ron Peterson | 13:40 |
| Single row tables | KÖPFERL Robert | 14:45 |
| Re: Single row tables | Dmitri Bichko | 14:50 |
| Re: Parsing a Calculation from a field | Kieran Ashley | 14:50 |
| Re: Parsing a Calculation from a field | Jeff Eckermann | 14:50 |
| Re: Single row tables | KÖPFERL Robert | 15:17 |
| Simple Question | Terry Lee Tucker | 21:42 |
| Re: Simple Question | Guy Fraser | 22:06 |
| Re: Simple Question | Terry Lee Tucker | 22:07 |
| Re: Simple Question | Michael Fuhr | 22:15 |
| Re: Simple Question | Terry Lee Tucker | 22:18 |
| Re: Simple Question | Stephan Szabo | 22:21 |
| Re: Simple Question | Terry Lee Tucker | 22:21 |
| Re: Simple Question | Tom Lane | 22:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Column with recycled sequence value | PFC | 01:27 |
| pgmirror | Theo Galanakis | 02:19 |
| Re: Column with recycled sequence value | Greg Stark | 05:06 |
| Re: Column with recycled sequence value | KÖPFERL Robert | 09:09 |
| Trick to 'run' a view on two databases and combine the result ? | Din Adrian | 09:52 |
| Re: Trick to 'run' a view on two databases and combine the result ? | Michael Fuhr | 10:43 |
| Re: Column with recycled sequence value (solved (somehow)) | KÖPFERL Robert | 18:44 |
| assign the row count of a query to a variable | Kevin B. | 20:43 |
| Re: assign the row count of a query to a variable | PFC | 21:13 |
| I am writing a MS SQL server conversion utility and am having an issue with timestamp | Joel Fradkin | 21:15 |
| Re: assign the row count of a query to a variable | Michael Fuhr | 21:15 |
| Thread | Author | Time |
|---|---|---|
| Re: SQL Query Performance tips | PFC | 08:26 |
| Re: return value of the trigger function | Bruno Wolff III | 09:00 |
| Split pg_dump script 📎 | Markus Schaber | 12:54 |
| SQL design question: null vs. boolean values | j.random.programmer | 14:40 |
| Re: SQL design question: null vs. boolean values | Andrew Sullivan | 15:05 |
| Re: SQL design question: null vs. boolean values | Richard Huxton | 15:09 |
| Thread | Author | Time |
|---|---|---|
| Re: I am writing a MS SQL server conversion utility and am having an issue with timestamp | Michael Fuhr | 01:50 |
| plpgsql and for with integer loopvar error | Ari Kahn | 03:43 |
| Re: SQL design question: null vs. boolean values | j.random.programmer | 13:59 |
| Re: SQL design question: null vs. boolean values | PFC | 18:47 |
| Re: pgmirror | Theo Galanakis | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: TEXT type blob extraction in ecpg | KÖPFERL Robert | 07:33 |
| Record type in sql | Din Adrian | 12:31 |
| Re: Record type in sql | KÖPFERL Robert | 12:48 |
| Inserting or Deleting conditionally | KÖPFERL Robert | 15:25 |
| Re: Inserting or Deleting conditionally | Richard Huxton | 16:02 |
| query configuration for validate empty quote to zero | Yudie | 18:44 |
| Re: query configuration for validate empty quote to zero | Tom Lane | 19:23 |
| Re: query configuration for validate empty quote to zero | Yudie | 19:30 |
| Re: plpgsql and for with integer loopvar error | Stephan Szabo | 19:38 |
| "How do I ..." SQL question | zeus | 23:31 |
| Thread | Author | Time |
|---|---|---|
| Re: "How do I ..." SQL question | PFC | 00:13 |
| mail + rfc822, rfc2822 + schema | Achilleus Mantzios | 15:05 |
| Returning a bool on DELETE in a proc. | KÖPFERL Robert | 16:04 |
| Re: query configuration for validate empty quote to zero | KÖPFERL Robert | 16:17 |
| Re: Returning a bool on DELETE in a proc. | Keith Worthington | 18:46 |
| Re: Returning a bool on DELETE in a proc. | Michael Fuhr | 18:52 |
| postgres stored procedures | Joel Fradkin | 20:18 |
| URGENT: Using function inside query | Bradley Miller | 20:51 |
| Thread | Author | Time |
|---|---|---|
| still having pg_user error | Joel Fradkin | 00:59 |
| Re: still having pg_user error | Tom Lane | 05:47 |
| Re: OID's | Mihail Nasedkin | 06:17 |
| Re: [SQL] OFFSET impact on Performance??? | Andrei Bintintan | 09:20 |
| returning a record from PL/pgSQL | KÖPFERL Robert | 11:41 |
| Re: still having pg_user error | Joel Fradkin | 13:56 |
| Re: still having pg_user error | Tom Lane | 14:16 |
| Re: still having pg_user error | Joel Fradkin | 15:51 |
| Re: OID's | Richard Huxton | 17:04 |
| Re: OID's | Michael Fuhr | 17:04 |
| Thread | Author | Time |
|---|---|---|
| testing/predicting optimization using indexes | TJ O'Donnell | 00:51 |
| update from multiple rows | adam etienne | 12:51 |
| Question about a select | Kretschmer Andreas | 15:56 |
| Re: update from multiple rows | Michael Fuhr | 19:35 |
| editors with colum positioning for debugging? | Joel Fradkin | 22:12 |
| Re: editors with colum positioning for debugging? | Tom Lane | 22:21 |
| Re: editors with colum positioning for debugging? | Joel Fradkin | 22:36 |
| Thread | Author | Time |
|---|---|---|
| Re: editors with colum positioning for debugging? | John DeSoi | 01:58 |
| Re: update from multiple rows | adam etienne | 11:36 |
| Re: Question about a select | Harald Fuchs | 15:37 |
| How to update dependent tables AND design considerations | Klaus W. | 17:23 |
| Re: returning a record from PL/pgSQL | Michael Fuhr | 19:00 |
| Invalid Input syntax for type bigint | Ryan Miranda | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Moving from Transact SQL to PL/pgsql | Duffy House | 03:22 |
| Re: OID's | Mihail Nasedkin | 03:57 |
| Re: Invalid Input syntax for type bigint | Michael Fuhr | 04:10 |
| Re: OID's | Michael Fuhr | 04:58 |
| Re: OID's | Mihail Nasedkin | 05:21 |
| Re: update from multiple rows | Michael Fuhr | 06:45 |
| Looking up table names by REFERENCES | Steve Castellotti | 15:09 |
| How to find out programmatically whether a query on a view will use an index? | Martin Schäfer | 16:34 |
| Re: How to find out programmatically whether a query on a view will use an index? | Tom Lane | 17:12 |
| Moving from Transact SQL to PL/pgSQL | Kevin Duffy | 17:14 |
| Re: How to find out programmatically whether a query on a view will use an index? | Martin Schäfer | 17:22 |
| Re: update from multiple rows | franco | 17:44 |
| Value specific sequences? | Dmitri Bichko | 19:10 |
| Re: update from multiple rows | mrblonde | 23:32 |
| Thread | Author | Time |
|---|---|---|
| datediff is there something like it? | Joel Fradkin | 15:11 |
| Re: datediff is there something like it? | Achilleus Mantzios | 16:33 |