Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| Re: How to GROUP results BY month | Mark Roberts | 01:15 |
| Re: How to GROUP results BY month | Scott Marlowe | 01:55 |
| Re: COPY equivalent for updates | Decibel! | 03:13 |
| Re: How to GROUP results BY month | A. Kretschmer | 05:37 |
| Re: How to GROUP results BY month | A. Kretschmer | 05:39 |
| Problem with ORDER BY and DISTINCT ON | Steve Midgley | 07:39 |
| integrity check and visibility was: COPY equivalent for updates | Ivan Sergio Borgonovo | 09:06 |
| Re: Problem with ORDER BY and DISTINCT ON | Tom Lane | 14:29 |
| Re: Rollback in Postgres | Kaare Rasmussen | 16:10 |
| Re: How to GROUP results BY month | Mark Roberts | 16:29 |
| Re: Problem with ORDER BY and DISTINCT ON | Steve Midgley | 17:03 |
| pg_advisory_lock(bigint) vs. LOCK TABLE | Volkan YAZICI | 20:20 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 20:51 |
| Thread | Author | Time |
|---|---|---|
| Re: PERSISTANT PREPARE (another point of view) | Pavel Stehule | 06:13 |
| Re: PERSISTANT PREPARE (another point of view) | Richard Huxton | 08:30 |
| Generating table rows from arrays | Florian Weimer | 10:23 |
| Re: Generating table rows from arrays | Richard Huxton | 10:37 |
| Re: Generating table rows from arrays | Pavel Stehule | 10:38 |
| Re: How to GROUP results BY month | Oliveiros Cristina | 11:18 |
| Re: Generating table rows from arrays | Florian Weimer | 11:44 |
| Re: pg_advisory_lock(bigint) vs. LOCK TABLE | Alvaro Herrera | 16:16 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_advisory_lock(bigint) vs. LOCK TABLE | Volkan YAZICI | 05:26 |
| Re: pg_advisory_lock(bigint) vs. LOCK TABLE | Tom Lane | 05:40 |
| Re: How to GROUP results BY month | Lennin Caro | 14:04 |
| Re: How to GROUP results BY month | Oliveiros Cristina | 14:09 |
| Re: pg_advisory_lock(bigint) vs. LOCK TABLE | Mark Roberts | 17:22 |
| Re: pg_advisory_lock(bigint) vs. LOCK TABLE | Alvaro Herrera | 18:30 |
| Thread | Author | Time |
|---|---|---|
| Whassup with this? (create table .... like ... fails) | Karl Denninger | 03:15 |
| Re: Whassup with this? (create table .... like ... fails) | Stephan Szabo | 03:55 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 13:23 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 14:15 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 14:16 |
| Thread | Author | Time |
|---|---|---|
| Size or efficiency differences "varchar(128) vs. varchar(32)" | Emi Lu | 14:06 |
| Re: Size or efficiency differences "varchar(128) vs. varchar(32)" | Alvaro Herrera | 15:40 |
| Re: Size or efficiency differences "varchar(128) vs. varchar(32)" | Scott Marlowe | 16:17 |
| Re: Size or efficiency differences "varchar(128) vs. varchar(32)" | Emi Lu | 16:59 |
| Re: PERSISTANT PREPARE (another point of view) | Milan Oparnica | 20:45 |
| Thread | Author | Time |
|---|---|---|
| Re: PERSISTANT PREPARE (another point of view) | Craig Ringer | 01:04 |
| Re: PERSISTANT PREPARE (another point of view) | Craig Ringer | 02:31 |
| Re: PERSISTANT PREPARE (another point of view) | Pavel Stehule | 06:43 |
| Re: PERSISTANT PREPARE (another point of view) | Scott Marlowe | 07:28 |
| How to Select a Tupl by Nearest Date | Christian Kindler | 08:42 |
| Re: How to Select a Tupl by Nearest Date | A. Kretschmer | 09:06 |
| index for group by | Patrick Scharrenberg | 11:18 |
| Re: index for group by | A. Kretschmer | 11:27 |
| Re: How to Select a Tupl by Nearest Date | Christian Kindler | 18:12 |
| Strange query duration | Fernando Hevia | 19:10 |
| Re: Strange query duration | Stephan Szabo | 20:18 |
| Re: Strange query duration | Richard Broersma | 20:19 |
| Re: Strange query duration | Fernando Hevia | 20:45 |
| Re: Strange query duration | Tom Lane | 20:46 |
| Re: index for group by | Steve Midgley | 21:17 |
| Re: PERSISTANT PREPARE (another point of view) | Jeff Williams | 23:16 |
| Thread | Author | Time |
|---|---|---|
| Select default values | Maximilian Tyrtania | 08:32 |
| Re: Select default values | A. Kretschmer | 09:26 |
| Re: Select default values | Pavel Stehule | 09:28 |
| Re: Select default values | Maximilian Tyrtania | 09:49 |
| Re: Select default values | Maximilian Tyrtania | 09:57 |
| Re: Select default values | Pavel Stehule | 10:19 |
| Re: Select default values | Maximilian Tyrtania | 10:35 |
| Re: Select default values | Karsten Hilbert | 10:44 |
| Re: Select default values | Pavel Stehule | 11:26 |
| Re: Select default values | Maximilian Tyrtania | 12:06 |
| Re: Select default values | Scott Marlowe | 14:29 |
| Query prepared plan | Emi Lu | 18:22 |
| Thread | Author | Time |
|---|---|---|
| Cloning hierarchical data | Maximilian Tyrtania | 07:43 |
| Re: Select default values | Giorgio Valoti | 10:30 |
| Re: Select default values | Richard Huxton | 10:42 |
| postgres time zone settings | Anoop G | 12:56 |
| truncate vs. delete | Emi Lu | 13:34 |
| Re: truncate vs. delete | Emi Lu | 13:47 |
| Re: truncate vs. delete | A. Kretschmer | 13:53 |
| Re: truncate vs. delete | Lennin Caro | 13:58 |
| Re: truncate vs. delete | Emi Lu | 14:01 |
| Re: truncate vs. delete | A. Kretschmer | 14:17 |
| Re: truncate vs. delete | Scott Marlowe | 14:33 |
| Re: truncate vs. delete | Emi Lu | 14:36 |
| Re: truncate vs. delete | Shane Ambler | 14:38 |
| Re: postgres time zone settings | Jaime Casanova | 16:47 |
| Re: Select default values | Giorgio Valoti | 19:35 |
| Re: Select default values | Richard Broersma | 21:15 |
| 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 |