Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: How to declare cursor if tablename is a variable? | Michael Fuhr | 11:47 |
| Thread | Author | Time |
|---|---|---|
| Selecting different views from a Boolean expression | Wilkinson, Jim | 13:36 |
| Shared Buffers | ezequias | 21:01 |
| Thread | Author | Time |
|---|---|---|
| Re: timestamp subtraction (was Re: [SQL] formatting intervals with to_char) | Bruce Momjian | 01:50 |
| array_to_string | Sabin Coanda | 06:47 |
| select vs. select count | Claus Guttesen | 12:37 |
| Re: select vs. select count | Claus Guttesen | 12:39 |
| Foreign Unique Constraint | Jon Horsman | 13:21 |
| Re: Foreign Unique Constraint | A. Kretschmer | 13:36 |
| Re: select vs. select count | Peter Eisentraut | 14:20 |
| Re: Foreign Unique Constraint | Jon Horsman | 14:27 |
| Re: array_to_string | Tom Lane | 14:49 |
| Re: array_to_string | Richard Huxton | 14:59 |
| Re: array_to_string | Tom Lane | 15:35 |
| Re: array_to_string | Richard Huxton | 15:45 |
| Re: Foreign Unique Constraint | Peter Eisentraut | 15:58 |
| Re: select vs. select count | Tom Lane | 16:10 |
| Re: Foreign Unique Constraint | chester c young | 17:35 |
| Re: Regular Expressions | ezequias | 20:01 |
| Re: Regular Expressions | Richard Broersma Jr | 22:16 |
| Re: Foreign Unique Constraint | Phillip Smith | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Foreign Unique Constraint | Jon Horsman | 03:51 |
| Re: Foreign Unique Constraint | Peter Eisentraut | 09:08 |
| Re: Regular Expressions [progress] | ezequias | 12:25 |
| Re: Foreign Unique Constraint | Jon Horsman | 13:28 |
| union with count? | Gerardo Herzig | 14:04 |
| Re: Regular Expressions [progress] | Richard Broersma Jr | 14:10 |
| Re: union with count? | A. Kretschmer | 14:24 |
| Re: union with count? | Richard Broersma Jr | 14:27 |
| Re: union with count? | Gerardo Herzig | 15:23 |
| Re: Rules with sequence columns | Tom Lane | 16:17 |
| Re: union with count? | Andreas Kretschmer | 16:19 |
| Rules with sequence columns | Ray Madigan | 16:25 |
| How too select different views using a IF/THEN/ELSE procedure ? | Wilkinson, Jim | 19:04 |
| Track query status | Sumeet | 20:59 |
| Re: Track query status | Andrew Sullivan | 21:49 |
| Re: Foreign Unique Constraint | Phillip Smith | 22:21 |
| Thread | Author | Time |
|---|---|---|
| SELECT INSTEAD | Phillip Smith | 05:35 |
| Re: SELECT INSTEAD | Michael Fuhr | 06:48 |
| Re: SELECT INSTEAD | Richard Huxton | 06:49 |
| Re: SELECT INSTEAD | Phillip Smith | 06:58 |
| Temp tbl Vs. View | Radhika Sambamurti | 15:26 |
| Re: Temp tbl Vs. View | Richard Broersma Jr | 15:46 |
| Re: Temp tbl Vs. View | Rodrigo De León | 15:56 |
| Re: Empty Table | Rajesh Kumar Mallah | 18:16 |
| Empty Table | ezequias | 18:25 |
| Re: Empty Table | ezequias | 18:50 |
| Re: Empty Table | Rajesh Kumar Mallah | 19:34 |
| Re: Empty Table | Rajesh Kumar Mallah | 19:41 |
| Re: Track query status | Rajesh Kumar Mallah | 19:48 |
| Re: Foreign Unique Constraint | Jon Horsman | 21:23 |
| Re: olympics ranking query | Kyle Bateman | 21:33 |
| Thread | Author | Time |
|---|---|---|
| Re: select vs. select count | Claus Guttesen | 11:19 |
| using sql on v7.4 server to feed stored procedure | Brian Jarrett | 19:19 |
| Re: using sql on v7.4 server to feed stored procedure | Tom Lane | 20:14 |
| function return array | Karthikeyan Sundaram | 21:16 |
| Thread | Author | Time |
|---|---|---|
| plpgsql function return array | Karthikeyan Sundaram | 07:43 |
| Re: plpgsql function return array | Michael Fuhr | 12:55 |
| Thread | Author | Time |
|---|---|---|
| Sequence vs Serial | Daniel CAUNE | 04:01 |
| Re: Sequence vs Serial | Scott Marlowe | 07:58 |
| Re: Sequence vs Serial | Tom Lane | 18:51 |
| Thread | Author | Time |
|---|---|---|
| Calling void functions | Peter Eisentraut | 08:02 |
| Re: Calling void functions | Daniel Caune | 12:52 |
| Re: Calling void functions | A. Kretschmer | 13:31 |
| Update problem. | Shavonne Marietta Wijesinghe | 14:06 |
| Update problem. | Shavonne Marietta Wijesinghe | 14:52 |
| Re: Update problem. | Andrew Sullivan | 15:17 |
| Re: Calling void functions | Tom Lane | 16:44 |
| SQL4. I ask you to help in development (or critic). | sql4-en.narod.ru | 16:56 |
| Maxusers MaxConnections | ezequias | 18:13 |
| Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char) | Bruce Momjian | 22:46 |
| Re: Calling void functions | Daniel CAUNE | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] exception handling in postgres plpgsql | Tom Lane | 00:24 |
| Re: plpgsql function question | A. Kretschmer | 05:01 |
| Moving a simple function to pl/pgsql (Novice question) | Paul Lambert | 06:19 |
| Generating dates prior to generate_series | Roger Tannous | 12:00 |
| Re: plpgsql function question | John DeSoi | 12:19 |
| CPU statistics | ezequias | 12:36 |
| Setting high performance on huge server | ezequias | 12:49 |
| Re: Setting high performance on huge server | Claus Guttesen | 12:55 |
| Re: Moving a simple function to pl/pgsql (Novice question) | Richard Broersma Jr | 13:06 |
| Re: exception handling in postgres plpgsql | Igor Neyman | 13:17 |
| Solved - best way: diary functions. | Gary Stainburn | 13:27 |
| Re: CPU statistics | Peter Eisentraut | 13:54 |
| Re: CPU statistics | Jonah H. Harris | 14:02 |
| Re: Moving a simple function to pl/pgsql (Novice question) | Paul Lambert | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Insert only if not found | Shavonne Marietta Wijesinghe | 07:10 |
| Update Field with function/data from other tables? | paallen | 16:57 |
| dropping a schema and cross-schema dependencies | George Pavlov | 22:09 |
| Re: dropping a schema and cross-schema dependencies | Tom Lane | 23:39 |
| Thread | Author | Time |
|---|---|---|
| Re: dropping a schema and cross-schema dependencies | George Pavlov | 00:05 |
| rowcount function in postgres??? | Karthikeyan Sundaram | 17:33 |
| Re: rowcount function in postgres??? | Michael Fuhr | 17:51 |
| Re: [SQL] rowcount function in postgres??? | Rodrigo De León | 17:54 |
| Re: rowcount function in postgres??? | Uwe C. Schroeder | 18:58 |
| Thread | Author | Time |
|---|---|---|
| MD5 sums of large objects | Dirk Jagdmann | 17:03 |
| Re: MD5 sums of large objects | Michael Fuhr | 17:37 |
| Question on pgpsql function | Karthikeyan Sundaram | 19:47 |
| Re: [SQL] Question on pgpsql function | Adrian Klaver | 20:22 |
| Re: Question on pgpsql function | Tom Lane | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: MD5 sums of large objects | Dirk Jagdmann | 00:07 |
| Re: MD5 sums of large objects | Michael Fuhr | 01:07 |
| Another question in functions | Karthikeyan Sundaram | 01:59 |
| new idea | sql4-en.narod.ru | 06:42 |
| Re: new idea | Andrew Sullivan | 12:21 |
| Re: new idea | Erik Jones | 14:11 |
| Re: new idea | Andrew Sullivan | 14:14 |
| Re: Another question in functions | Stephan Szabo | 14:24 |
| Re: MD5 sums of large objects | Dirk Jagdmann | 15:11 |
| Re: new idea | Erik Jones | 15:52 |
| Thread | Author | Time |
|---|---|---|
| Question about undefinably query... | A. Kretschmer | 14:05 |
| EXECUTE in a funtion to return a VIEW object ID | Wilkinson, Jim | 14:34 |
| Re: Question about undefinably query... | Tom Lane | 14:46 |
| Re: A long-running transaction | John Summerfield | 16:41 |
| Re: A long-running transaction | Andrew Sullivan | 16:55 |
| Replace string | PostgreSQL Admin | 20:40 |
| Re: A long-running transaction | John Summerfield | 21:54 |
| Thread | Author | Time |
|---|---|---|
| update from and left join | Tomasz Myrta | 07:06 |
| Re: A long-running transaction | Andrew Sullivan | 13:34 |
| Re: A long-running transaction | John Summerfield | 14:23 |
| Re: A long-running transaction | Andrew Sullivan | 15:49 |
| Urgent help in bit_string data type | Karthikeyan Sundaram | 20:30 |
| Re: [SQL] Urgent help in bit_string data type | Joe | 21:44 |
| Re: [SQL] Urgent help in bit_string data type | Karthikeyan Sundaram | 22:01 |
| Re: [SQL] Urgent help in bit_string data type | Joe | 23:00 |
| Re: [SQL] Urgent help in bit_string data type | Karthikeyan Sundaram | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Urgent help in bit_string data type | Joe | 04:07 |
| Re: Replace string | A. Kretschmer | 05:12 |
| Re: Replace string | Rodrigo De León | 05:29 |
| un-triviality is saved | Dmitry Turin | 11:23 |
| Re: ERROR: column "crc" does not exist | Bart Degryse | 12:15 |
| Re: ERROR: column "crc" does not exist | A. Kretschmer | 12:19 |
| Re: ERROR: column "crc" does not exist | George Weaver | 12:21 |
| Re: ERROR: column "crc" does not exist | Andrew Sullivan | 12:21 |
| ERROR: column "crc" does not exist | ezequias | 12:23 |
| replace EXCEPT by JOIN | T E Schmitz | 18:32 |
| Re: Replace string | PostgreSQL Admin | 19:51 |
| question on plpgsql block | Karthikeyan Sundaram | 22:44 |
| Re: question on plpgsql block | Peter Eisentraut | 23:38 |
| Thread | Author | Time |
|---|---|---|
| setting up a mirroring or replication database | Karthikeyan Sundaram | 00:39 |
| Re: [SQL] setting up a mirroring or replication database | Phillip Smith | 00:50 |
| Re: A long-running transaction | John Summerfield | 01:02 |
| Re: question on plpgsql block | A. Kretschmer | 06:28 |
| We all are looped on Internet: request + transport = invariant | Dmitry Turin | 07:58 |