Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Arrays, types and prodedures | Chris Hoy | 08:32 |
| Re: Arrays, types and prodedures | Pavel Stehule | 08:38 |
| Re: postgres time zone settings(time difference in Server and client) | Anoop G | 09:12 |
| Re: postgres time zone settings(time difference in Server and client) | Richard Huxton | 09:23 |
| Re: postgres time zone settings(time difference in Server and client) | Pawel Socha | 09:24 |
| Re: postgres time zone settings(time difference in Server and client) | Anoop G | 10:02 |
| A table with two names or table alias | Tk421 | 12:12 |
| Re: A table with two names or table alias | A. Kretschmer | 12:23 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 12:58 |
| Re: Query prepared plan | Emi Lu | 14:27 |
| Re: A table with two names or table alias | Igor Neyman | 15:25 |
| Re: Query prepared plan | Tom Lane | 17:20 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 17:49 |
| Re: PERSISTANT PREPARE (another point of view) | Pavel Stehule | 19:07 |
| Thread | Author | Time |
|---|---|---|
| Re: PERSISTANT PREPARE (another point of view) | chester c young | 00:32 |
| Test if a table is present | Ole Ekerhovd | 05:24 |
| Re: Test if a table is present | Anoop G | 05:33 |
| Re: Test if a table is present | Volkan YAZICI | 05:48 |
| Efficiently determining the number of bits set in the contents of a VARBIT field | Allan Kamau | 13:17 |
| Re: Select default values | Giorgio Valoti | 20:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Efficiently determining the number of bits set in the contents of, a VARBIT field | TJ O'Donnell | 13:57 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 22:11 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 23:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Efficiently determining the number of bits set in the contents of, a VARBIT field | Jean-David Beyer | 00:24 |
| Re: PERSISTANT PREPARE (another point of view) | chester c young | 03:05 |
| Re: PERSISTANT PREPARE (another point of view) | Pavel Stehule | 06:48 |
| Encrytion in postgres field in table | Chris Preston | 13:25 |
| Accessing array datatype | maria s | 16:09 |
| Re: Accessing array datatype | Oliveiros Cristina | 16:56 |
| Re: Accessing array datatype | Oliveiros Cristina | 17:21 |
| Re: Accessing array datatype | maria s | 17:28 |
| Re: Encrytion in postgres field in table | Andrej Ricnik-Bay | 18:26 |
| Re: Query prepared plan | Emi Lu | 19:02 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 21:21 |
| Re: Query prepared plan | Alvaro Herrera | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Encrytion in postgres field in table | Lennin Caro | 03:26 |
| Re: Query prepared plan | Emi Lu | 13:39 |
| column names with - and ( | maria s | 16:06 |
| Re: column names with - and ( | Oliveiros Cristina | 16:27 |
| Re: column names with - and ( | maria s | 16:35 |
| Re: column names with - and ( | Oliveiros Cristina | 16:37 |
| Re: column names with - and ( | maria s | 16:39 |
| Identifying which column matches a full text search | Ryan Wallace | 18:31 |
| Re: column names with - and ( | Igor Neyman | 19:14 |
| Re: Identifying which column matches a full text search | Richard Huxton | 21:29 |
| Thread | Author | Time |
|---|---|---|
| Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date | Emi Lu | 15:08 |
| Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date | Milen A. Radev | 15:22 |
| Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date | Bricklen Anderson | 15:22 |
| Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date | Pavel Stehule | 15:23 |
| order function in aggregate | Michael Toews | 15:31 |
| Re: Get day name(Mon, Tue... Sun) and day number (1, 2...7) from a date | Emi Lu | 15:32 |
| Re: order function in aggregate | Richard Huxton | 17:28 |
| Re: order function in aggregate | Tom Lane | 17:45 |
| Re: Identifying which column matches a full text search | Ryan Wallace | 17:51 |
| Re: Identifying which column matches a full text search | Richard Huxton | 18:33 |
| Thread | Author | Time |
|---|---|---|
| Function returning setof taking parameters from another table | Marcin Stępnicki | 13:03 |
| Re: Problem with ORDER BY and DISTINCT ON | Tom Lane | 22:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Problem with ORDER BY and DISTINCT ON | Steve Midgley | 03:35 |
| Re: Function returning setof taking parameters from another table | Craig Ringer | 08:47 |
| How to change a view's owner in postgres | Anoop G | 09:41 |
| How to change a view's owner in postgres(is it possible?) | Anoop G | 10:16 |
| Re: How to change a view's owner in postgres | Marcin Stępnicki | 10:42 |
| regexp_replace | Marcin Krawczyk | 11:22 |
| Re: regexp_replace | Pawel Socha | 12:14 |
| Re: regexp_replace | Marcin Krawczyk | 12:25 |
| Savepoints and SELECT FOR UPDATE in 8.2 | EXT-Rothermel, Peter M | 17:02 |
| Re: column names with - and ( | maria s | 17:29 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Savepoints and SELECT FOR UPDATE in 8.2 | Scott Marlowe | 01:07 |
| Thread | Author | Time |
|---|---|---|
| return setof record - strange behavior | Marcin Krawczyk | 09:53 |
| return setof record - strange behavior | Marcin Krawczyk | 10:08 |
| Re: return setof record - strange behavior | Pawel Socha | 10:56 |
| Re: return setof record - strange behavior | Marcin Krawczyk | 11:33 |
| Case Insensitive searches | Mike Gould | 13:54 |
| Re: return setof record - strange behavior | Tom Lane | 13:59 |
| Re: Case Insensitive searches | Richard Broersma | 14:05 |
| Re: Case Insensitive searches | Terry Lee Tucker | 14:13 |
| Re: Case Insensitive searches | Frank Bax | 15:09 |
| Re: Case Insensitive searches | Terry Lee Tucker | 15:45 |
| fast insert-if-key-not-already-there | Patrick Scharrenberg | 15:51 |
| Re: fast insert-if-key-not-already-there | Thomas Kellerer | 15:55 |
| Re: fast insert-if-key-not-already-there | Richard Broersma | 15:59 |
| Thread | Author | Time |
|---|---|---|
| more than 1000 connections | Jorge Medina | 15:14 |
| Re: more than 1000 connections | Richard Broersma | 15:33 |
| Re: How to change a view's owner in postgres(is it possible?) | Richard Broersma | 17:02 |
| Single Quote in tsquery | Ryan Wallace | 17:19 |
| composite type cast and select statement | Yura Gal | 17:30 |
| Re: more than 1000 connections | Richard Broersma | 19:42 |
| Thread | Author | Time |
|---|---|---|
| Re: more than 1000 connections | Craig Ringer | 00:06 |
| Re: Case Insensitive searches | Rafael Domiciano | 11:59 |
| Re: Case Insensitive searches | Terry Lee Tucker | 12:44 |
| Re: more than 1000 connections | Mark Roberts | 15:54 |
| Re: more than 1000 connections | Jorge Medina | 16:42 |
| Re: more than 1000 connections | Scott Marlowe | 16:47 |
| How to creat tables using record ID in for loop | CHUNRIMACHUNRIMA | 18:52 |
| Re: more than 1000 connections | Jorge Medina | 19:34 |
| Re: more than 1000 connections | Scott Marlowe | 21:39 |
| Re: Single Quote in tsquery | Alvaro Herrera | 22:18 |
| Re: How to creat tables using record ID in for loop | Ragnar | 22:35 |
| Thread | Author | Time |
|---|---|---|
| Re: more than 1000 connections | Craig Ringer | 02:05 |
| Re: How to creat tables using record ID in for loop | Yura Gal | 06:50 |
| Re: How to creat tables using record ID in for loop | Yura Gal | 10:29 |
| DELETE with JOIN | felix | 16:14 |
| Re: DELETE with JOIN | Ragnar | 17:05 |
| enumerate groups given a certain value | Picavet Vincent | 17:31 |
| Re: DELETE with JOIN | Steve Midgley | 17:40 |
| Re: DELETE with JOIN | felix | 18:35 |
| Re: DELETE with JOIN | felix | 18:37 |
| Re: DELETE with JOIN | Frank Bax | 19:00 |
| Re: DELETE with JOIN | felix | 19:12 |
| Re: DELETE with JOIN | Tom Lane | 19:58 |
| Re: DELETE with JOIN | Frank Bax | 20:01 |
| Re: DELETE with JOIN | Mark Roberts | 20:27 |
| Re: DELETE with JOIN | felix | 21:35 |
| Re: enumerate groups given a certain value | Yura Gal | 21:37 |
| Re: DELETE with JOIN | felix | 21:39 |
| Re: DELETE with JOIN | Christophe | 21:42 |
| Re: DELETE with JOIN | Alvaro Herrera | 22:12 |
| Re: DELETE with JOIN | felix | 23:37 |
| Re: DELETE with JOIN | Christophe | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: DELETE with JOIN | Scott Marlowe | 00:45 |
| Re: DELETE with JOIN | felix | 03:54 |
| vacuum in single-user mode | Mark Fenbers | 19:02 |
| Re: vacuum in single-user mode | Christophe | 20:04 |
| 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 |