Discussion for users on SQL related matters.
| Thread | Author | Time |
|---|---|---|
| "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | Bryce Nesbitt | 22:29 |
| Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | Michael Glaesemann | 22:32 |
| Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | Bryce Nesbitt | 22:47 |
| Re: "<IDLE> in transaction" can't be killed with pg_cancel_backend(). Is it a bug? | bricklen | 23:03 |
| Thread | Author | Time |
|---|---|---|
| foreign key question | Gary Stainburn | 09:53 |
| Re: foreign key question | Gary Stainburn | 10:40 |
| return records with more than one occurrences | Tarsis Lima | 14:18 |
| pattern matching with dates? | Good, Thomas | 19:39 |
| Re: foreign key question | Jasen Betts | 19:54 |
| Thread | Author | Time |
|---|---|---|
| explicit casts | Iuri Sampaio | 00:24 |
| Re: explicit casts | Iuri Sampaio | 01:22 |
| Re: explicit casts | Adrian Klaver | 02:20 |
| Re: explicit casts | Adrian Klaver | 02:33 |
| Thread | Author | Time |
|---|---|---|
| Re: return records with more than one occurrences | Jasmin Dizdarevic | 10:07 |
| Re: pattern matching with dates? | Samuel Gendler | 10:44 |
| Re: return records with more than one occurrences | Oliveiros d'Azevedo Cristina | 11:04 |
| Re: pattern matching with dates? | Susanne Ebrecht | 12:39 |
| Re: pattern matching with dates? | pasman pasmański | 14:15 |
| Re: pattern matching with dates? | Richard Huxton | 16:09 |
| Thread | Author | Time |
|---|---|---|
| Re: return records with more than one occurrences | Russell Galyon | 04:48 |
| Re: pattern matching with dates? | Jasen Betts | 10:22 |
| Thread | Author | Time |
|---|---|---|
| Find NOT NULLs in a group of 20 columns | gvim | 02:14 |
| Re: Find NOT NULLs in a group of 20 columns | Tom Lane | 02:45 |
| help needs in converting db2 function in postgresql. | Amar Dhole | 12:17 |
| Getting top 2 by Category | Ozer, Pam | 19:00 |
| Re: Getting top 2 by Category | Peter Steinheuser | 19:51 |
| Re: Getting top 2 by Category | Ozer, Pam | 19:53 |
| Re: Getting top 2 by Category | msi77 | 20:00 |
| Re: help needs in converting db2 function in postgresql. | Filip Rembiałkowski | 20:11 |
| Thread | Author | Time |
|---|---|---|
| Re: help needs in converting db2 function in postgresql. | Amar Dhole | 08:18 |
| Implement PostgreSQL full text search | - | 09:14 |
| INSERT/UPDATE .. RETURNING | Protasov Vladimir | 12:41 |
| joining one record according to max value | George Francis | 22:30 |
| Re: joining one record according to max value | George Francis | 22:39 |
| Re: joining one record according to max value | Jasmin Dizdarevic | 22:49 |
| Re: joining one record according to max value | George Francis | 22:53 |
| Re: joining one record according to max value | Jasmin Dizdarevic | 23:05 |
| Re: joining one record according to max value | George Francis | 23:38 |
| Thread | Author | Time |
|---|---|---|
| why does seq scan instead of index scan | 中川 誠貴 | 08:58 |
| Re: why does seq scan instead of index scan | Tom Lane | 17:56 |
| Thread | Author | Time |
|---|---|---|
| Re: why does seq scan instead of index scan | 中川 誠貴 | 05:19 |
| Re: why does seq scan instead of index scan | Dmitriy Igrishin | 16:36 |
| Thread | Author | Time |
|---|---|---|
| Re: why does seq scan instead of index scan | 中川 誠貴 | 01:25 |
| failing to connect to postgresql with php | victor katemana | 08:42 |
| Re: failing to connect to postgresql with php | Viktor Bojović | 08:51 |
| Re: failing to connect to postgresql with php | Marcin Mirosław | 09:23 |
| Help needed in skipping column for copy command | Amar Dhole | 13:59 |
| Re: Help needed in skipping column for copy command | Adrian Klaver | 20:46 |
| Re: Help needed in skipping column for copy command | Russell Galyon | 21:14 |
| Thread | Author | Time |
|---|---|---|
| question about reg. expression | andrew1 | 23:41 |
| Thread | Author | Time |
|---|---|---|
| Re: question about reg. expression | Samuel Gendler | 10:21 |
| Re: question about reg. expression | Stephen Belcher | 13:17 |
| Re: question about reg. expression | Kenneth Marshall | 14:18 |
| Re: Getting top 2 by Category | Carla | 20:11 |
| Re: Getting top 2 by Category | Peter Steinheuser | 20:59 |
| Thread | Author | Time |
|---|---|---|
| Issue with postgres connectivity | Arindam Hore | 10:45 |
| Re: Issue with postgres connectivity | Reinoud van Leeuwen | 10:57 |
| Re: Issue with postgres connectivity | Arindam Hore | 11:17 |
| Re: Issue with postgres connectivity | Arindam Hore | 11:43 |
| Re: Issue with postgres connectivity | Edward W. Rouse | 14:47 |
| Thread | Author | Time |
|---|---|---|
| Control reached end of trigger procedure without RETURN | MoNiLlO | 06:32 |
| Re: Issue with postgres connectivity | Jasen Betts | 08:53 |
| Re: question about reg. expression | Jasen Betts | 08:59 |
| Control reached end of trigger procedure without RETURN | Adelo Herrero Pérez | 09:37 |
| Re: Issue with postgres connectivity | Arindam Hore | 15:40 |
| Re: Issue with postgres connectivity | Arindam Hore | 15:43 |
| Thread | Author | Time |
|---|---|---|
| loosing data in postgres database | victor katemana | 09:37 |
| Postgres function for full text search | - | 09:38 |
| Re: loosing data in postgres database | Filip Rembiałkowski | 09:49 |
| Re: loosing data in postgres database | Piotr Czekalski | 09:51 |
| Re: Postgres function for full text search | Ivan Sergio Borgonovo | 10:08 |
| Thread | Author | Time |
|---|---|---|
| pgbench tools | manuel antonio ochoa | 00:34 |
| Re: Queyring for columns which are exist in table. | msi77 | 07:17 |
| how to get row number in select query | Emi Lu | 16:11 |
| Re: how to get row number in select query | Oliveiros d'Azevedo Cristina | 16:40 |
| Re: how to get row number in select query | Oliveiros d'Azevedo Cristina | 17:02 |
| Compare the resulta of a count sql into bash | manuel antonio ochoa | 17:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Automating PostgreSql table partition using triggers | Amitabh Kant | 02:41 |
| Re: Automating PostgreSql table partition using triggers | Amitabh Kant | 02:47 |
| aggregation of setof | Andreas Gaab | 11:42 |
| Thread | Author | Time |
|---|---|---|
| something simple but I can't | John Fabiani | 01:16 |
| Re: something simple but I can't | Jasen Betts | 03:46 |
| Re: something simple but I can't | John Fabiani | 15:14 |
| Thread | Author | Time |
|---|---|---|
| Re: aggregation of setof | Andreas Gaab | 08:52 |
| Re: aggregation of setof | Pavel Stehule | 09:23 |
| Re: aggregation of setof | Andreas Gaab | 10:22 |
| fix uuid contrib module for Windows 64 | Michael Gould | 13:40 |
| Re: aggregation of setof | Tom Lane | 15:32 |
| Re: aggregation of setof | Viktor Bojović | 15:37 |
| Get days between two dates? | Emi Lu | 15:50 |
| Re: Get days between two dates? | Tovo J. RABEMANANTSOA | 16:29 |
| Re: Get days between two dates? | Oliveiros d'Azevedo Cristina | 16:33 |
| Re: Get days between two dates? | Emi Lu | 16:36 |
| Re: Get days between two dates? | Kenneth Marshall | 16:39 |
| Re: how to get row number in select query | Emi Lu | 16:39 |
| Re: Get days between two dates? | Oliveiros d'Azevedo Cristina | 16:51 |