Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field | Bruce Momjian | 20:48 |
| Thread | Author | Time |
|---|---|---|
| Check a column value not in Array. | Emi Lu | 19:07 |
| Re: Check a column value not in Array. | Pavel Stehule | 19:31 |
| Re: Check a column value not in Array. | Filip Rembiałkowski | 19:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Check a column value not in Array. | Andreas Wenk | 07:37 |
| Re: Check a column value not in Array. | Emi Lu | 13:32 |
| Join question | Edward W. Rouse | 16:48 |
| Re: Join question | Edward W. Rouse | 17:09 |
| Re: Join question | Richard Broersma | 17:10 |
| Re: Join question | Edward W. Rouse | 17:46 |
| Re: Join question | Steve Midgley | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Cursor | Xavier Bermeo | 17:53 |
| Re: Cursor | Joe | 18:54 |
| Cursor | Xavier Bermeo | 19:35 |
| Thread | Author | Time |
|---|---|---|
| INSERT or UPDATE | Andreas Kraftl | 07:44 |
| Re: INSERT or UPDATE | A. Kretschmer | 10:50 |
| Select function with set return type | Nacef LABIDI | 11:03 |
| Re: Select function with set return type | Andreas Kretschmer | 11:12 |
| COPY TO with FORCE QUOTE * | Jackson Pauls | 12:28 |
| Re: Join question | Daniel Hernandez | 16:30 |
| Re: Join question | Oliveiros Cristina | 18:00 |
| Cursors.. | David Calle | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Cursors.. | Yura Gal | 08:45 |
| Re: Join question | Edward W. Rouse | 13:35 |
| Re: Join question | Edward W. Rouse | 13:36 |
| Re: Join question | Oliveiros Cristina | 15:17 |
| Re: Join question | Lennin Caro | 15:59 |
| Re: Join question | Edward W. Rouse | 18:03 |
| Re: Cursor | Fernando Hevia | 18:38 |
| LIMIT question | EXT-Rothermel, Peter M | 20:58 |
| Re: LIMIT question | Richard Broersma | 21:08 |
| Re: Join question | Edward W. Rouse | 21:16 |
| Re: LIMIT question | Tom Lane | 21:21 |
| Thread | Author | Time |
|---|---|---|
| Regarding access to a user | Shashwat_Nigam | 06:41 |
| Re: Regarding access to a user | Kevin Grittner | 13:10 |
| looking for example of inserting into a view | EXT-Rothermel, Peter M | 17:16 |
| Re: order function in aggregate | Mike Toews | 19:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Regarding access to a user | Shashwat_Nigam | 08:53 |
| Re: Regarding access to a user | Vishal Arora | 08:59 |
| Re: Regarding access to a user | Shashwat_Nigam | 09:05 |
| Re: Regarding access to a user | Tomasz Ostrowski | 09:07 |
| Re: Regarding access to a user | Shashwat_Nigam | 09:12 |
| Re: Regarding access to a user | Vishal Arora | 09:16 |
| Re: Regarding access to a user | Tomasz Ostrowski | 09:20 |
| Re: Regarding access to a user | Shashwat_Nigam | 09:25 |
| Re: Regarding access to a user | Vishal Arora | 09:39 |
| Re: [GENERAL] Regarding access to a user | Albe Laurenz | 12:03 |
| Question on partitioning | Oliveiros Cristina | 14:25 |
| Re: Question on partitioning | Scott Marlowe | 16:50 |
| Re: Question on partitioning | Mark Roberts | 18:00 |
| Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field | Allan Kamau | 18:58 |
| Thread | Author | Time |
|---|---|---|
| What is wrong with this PostgreSQL UPDATE statement?? | Steve Johnson | 00:59 |
| Re: What is wrong with this PostgreSQL UPDATE statement?? | Stephan Szabo | 01:41 |
| Re: What is wrong with this PostgreSQL UPDATE statement?? | Tom Lane | 02:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Regarding access to a user | Scott Marlowe | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Regarding access to a user | Vishal Arora | 04:18 |
| Data into an array | sub3 | 18:40 |
| Re: Data into an array | Pavel Stehule | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Data into an array | sub3 | 00:40 |
| Re: Data into an array | Pavel Stehule | 03:06 |
| Thread | Author | Time |
|---|---|---|
| uuid-ossp contrib in pg 8.1 📎 | James Neethling | 05:57 |
| Re: uuid-ossp contrib in pg 8.1 | Peter Eisentraut | 14:38 |
| Thread | Author | Time |
|---|---|---|
| pg_dump and "could not identify an ordering operator for type name" | Gerardo Herzig | 13:29 |
| Implementing ACLs in Pure SQL? | Michael B Allen | 22:33 |
| Re: Implementing ACLs in Pure SQL? | ries van Twisk | 22:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Implementing ACLs in Pure SQL? | Michael B Allen | 01:47 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_dump and "could not identify an ordering operator for type name" | Martin Marques | 23:19 |
| Thread | Author | Time |
|---|---|---|
| MAY I HAVE YOUR ASSISTANCE | James Kitambara | 07:03 |
| Re: MAY I HAVE YOUR ASSISTANCE | Scott Marlowe | 07:28 |
| Re: MAY I HAVE YOUR ASSISTANCE | D'Arcy J.M. Cain | 14:08 |
| Re: MAY I HAVE YOUR ASSISTANCE | Gary Chambers | 14:31 |
| Re: MAY I HAVE YOUR ASSISTANCE | Fernando Hevia | 15:42 |
| Re: MAY I HAVE YOUR ASSISTANCE | Gary Chambers | 18:36 |
| Thread | Author | Time |
|---|---|---|
| order of rows in update | Achilleas Mantzios | 09:58 |
| Re: order of rows in update | Richard Broersma | 14:24 |
| How do I get min and max from an array of floating point values | pw | 21:14 |
| seemingly slow for-loop in plpgsql | Claus Guttesen | 22:27 |
| Re: seemingly slow for-loop in plpgsql | Tom Lane | 22:47 |
| Thread | Author | Time |
|---|---|---|
| Re: order of rows in update | Achilleas Mantzios | 06:56 |
| Re: seemingly slow for-loop in plpgsql | Claus Guttesen | 07:20 |
| Re: How do I get min and max from an array of floating point values | Pavel Stehule | 07:43 |
| Re: order of rows in update | Richard Broersma | 12:28 |
| Re: How do I get min and max from an array of floating point values | Yura Gal | 12:42 |
| Case-insensitive string prefix matching with parameterized query | Christopher Maier | 13:38 |
| Re: order of rows in update | Achilleas Mantzios | 15:21 |
| Thread | Author | Time |
|---|---|---|
| Syntax help please | Ruben Gouveia | 19:36 |
| Re: Syntax help please | Fernando Hevia | 19:49 |
| Re: Syntax help please | Ruben Gouveia | 19:55 |
| Dynamic SQL Syntax help please | Ruben Gouveia | 20:41 |
| Re: Dynamic SQL Syntax help please | Ivan Sergio Borgonovo | 21:00 |
| Re: Dynamic SQL Syntax help please | Ruben Gouveia | 21:07 |
| Correct Insert SQL syntax? | Ruben Gouveia | 22:16 |
| Re: Correct Insert SQL syntax? | Yura Gal | 22:49 |
| Re: Correct Insert SQL syntax? | Ruben Gouveia | 22:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Correct Insert SQL syntax? | Bart Degryse | 06:57 |
| Re: Correct Insert SQL syntax? | Lennin Caro | 16:11 |
| Re: Correct Insert SQL syntax? | Scott Marlowe | 16:16 |
| variables with SELECT statement | Kevin Duffy | 19:50 |
| Re: variables with SELECT statement | Frank Bax | 20:07 |
| Re: variables with SELECT statement | Kevin Duffy | 20:31 |
| Re: variables with SELECT statement | Frank Bax | 20:44 |
| Re: variables with SELECT statement | Kevin Duffy | 21:03 |
| Re: variables with SELECT statement | Frank Bax | 21:13 |
| Re: variables with SELECT statement | Tom Lane | 21:26 |
| Re: variables with SELECT statement | Kevin Duffy | 21:28 |
| Re: variables with SELECT statement | Kevin Duffy | 21:33 |
| Re: variables with SELECT statement | Scott Marlowe | 21:34 |
| Re: variables with SELECT statement | Kevin Duffy | 21:50 |
| Re: variables with SELECT statement | Frank Bax | 21:55 |
| Thread | Author | Time |
|---|---|---|
| psql: FATAL: Ident authentication failed for user "postgres" | VG | 10:09 |
| Re: psql: FATAL: Ident authentication failed for user "postgres" | Filip Rembiałkowski | 10:22 |
| Re: psql: FATAL: Ident authentication failed for user "postgres" | Milen A. Radev | 11:07 |
| problem with pg_stat_activity view | Sofer, Yuval | 11:29 |
| Re: problem with pg_stat_activity view | Tom Lane | 12:54 |
| Re: psql: FATAL: Ident authentication failed for user "postgres" | Devrim GÜNDÜZ | 12:59 |
| PL/pgSQL function syntax question? | Ruben Gouveia | 21:40 |
| Re: PL/pgSQL function syntax question? | Adrian Klaver | 21:47 |
| Re: PL/pgSQL function syntax question? | imad | 23:28 |
| Thread | Author | Time |
|---|---|---|
| Re: PL/pgSQL function syntax question? | Lennin Caro | 14:36 |
| Function syntax ? | Ruben Gouveia | 17:55 |
| Re: Function syntax ? | Pavel Stehule | 18:05 |
| Re: Function syntax ? | Scott Marlowe | 18:07 |
| Re: Function syntax ? | Ruben Gouveia | 18:11 |
| Re: Function syntax ? | Richard Huxton | 18:15 |
| Re: Function syntax ? | Scott Marlowe | 18:15 |
| Re: Function syntax ? | Ruben Gouveia | 18:16 |
| Re: Function syntax ? | Ruben Gouveia | 19:24 |
| How to provide password to pg_dump command ? | Emi Lu | 20:07 |
| Re: How to provide password to pg_dump command ? | Milen A. Radev | 20:16 |
| Function Syntax involving pipes and ' marks? | Ruben Gouveia | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Function Syntax involving pipes and ' marks? | Alvaro Herrera | 00:58 |
| FW: Help- post gress sql error | Kota, Prasoona | 13:57 |
| Re: FW: Help- post gress sql error | Tom Lane | 16:04 |
| Re: Function Syntax involving pipes and ' marks? | Bricklen Anderson | 18:24 |
| Re: Function Syntax involving pipes and ' marks? | Bricklen Anderson | 18:36 |
| Re: Function Syntax involving pipes and ' marks? | Ruben Gouveia | 18:38 |
| Re: Function Syntax involving pipes and ' marks? | Tom Lane | 18:45 |
| Re: Function Syntax involving pipes and ' marks? | Ruben Gouveia | 19:08 |
| pg_restore in java connection (auto_commit = false) | Emi Lu | 21:13 |
| Aggregates in WHERE clause? | Ruben Gouveia | 23:11 |
| Re: Aggregates in WHERE clause? | Stephan Szabo | 23:19 |
| Re: Aggregates in WHERE clause? | Richard Broersma | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_restore in java connection (auto_commit = false) | Craig Ringer | 02:14 |
| Re: Aggregates in WHERE clause? | Tom Lane | 12:03 |
| Re: Aggregates in WHERE clause? | Igor Neyman | 12:43 |
| Re: pg_restore in java connection (auto_commit = false) | Emi Lu | 13:48 |
| DIfference between max() and greatest() ? | Ruben Gouveia | 17:33 |
| Thread | Author | Time |
|---|---|---|
| Re: DIfference between max() and greatest() ? | Bart Degryse | 07:10 |
| Re: DIfference between max() and greatest() ? | Peter Eisentraut | 07:24 |
| Pls Hlp: SQL Problem 📎 | Hengky Lie | 09:22 |
| Re: Pls Hlp: SQL Problem | Richard Huxton | 10:23 |
| Re: DIfference between max() and greatest() ? | Ruben Gouveia | 16:47 |
| Doubts about FK | Rafael Domiciano | 18:14 |
| Re: Pls Hlp: SQL Problem 📎 | Hengky Lie | 18:50 |
| Re: Pls Hlp: SQL Problem | Scott Marlowe | 20:04 |
| Re: Doubts about FK | Scott Marlowe | 20:07 |
| Re: Pls Hlp: SQL Problem | Fernando Hevia | 22:01 |
| Re: Pls Hlp: SQL Problem | Scott Marlowe | 23:50 |
| Thread | Author | Time |
|---|---|---|
| selecting current UTC time | davidn | 10:10 |
| Re: selecting current UTC time | Frank Bax | 12:55 |
| a simple transform | Karl Grossner | 23:59 |
| Thread | Author | Time |
|---|---|---|
| select from two tables | Claus Guttesen | 10:04 |
| Re: select from two tables | Andreas Kretschmer | 12:01 |
| Re: Pls Hlp: SQL Problem | Fernando Hevia | 20:14 |
| Re: Pls Hlp: SQL Problem | Scott Marlowe | 20:18 |
| surrogate vs natural primary keys | Seb | 22:02 |
| Re: surrogate vs natural primary keys | Scott Marlowe | 22:45 |
| Re: surrogate vs natural primary keys | Seb | 22:56 |
| Thread | Author | Time |
|---|---|---|
| Simple Problem ? | Hengky Lie | 05:01 |
| Re: Simple Problem ? | Guillaume Lelarge | 06:32 |
| Re: Simple Problem ? | Guillaume Lelarge | 07:32 |
| Re: Simple Problem ? | Hengky Lie | 09:23 |
| Re: Simple Problem ? | Guillaume Lelarge | 09:39 |
| Re: a simple transform | Frank Bax | 13:37 |
| Re: surrogate vs natural primary keys | Richard Broersma | 14:59 |
| Re: surrogate vs natural primary keys | Andrew Sullivan | 15:17 |
| Re: a simple transform | Richard Broersma | 15:30 |
| Thread | Author | Time |
|---|---|---|
| Re: surrogate vs natural primary keys | Seb | 00:10 |
| Re: surrogate vs natural primary keys | Scott Marlowe | 02:34 |
| Insert a space between each character | Nicholas I | 06:19 |
| Re: Insert a space between each character | A. Kretschmer | 06:39 |
| Re: Insert a space between each character | Michael Toews | 06:50 |
| May I have an assistance on CREATE TABLE Command | James Kitambara | 06:50 |