pgsql-sql since 2011-06-15 00:00

Discussion for users on SQL related matters.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

June 15, 2011

Thread Author Time
Re: Select For Update and Left Outer Join greg.fenton 01:01
Merge overlapping time-periods Jira, Marcel 15:23
Calling inner functions vs. Begin-End blocs Charles N. Charotti 15:40
Re: Merge overlapping time-periods F. BROUARD / SQLpro 15:43
Re: Merge overlapping time-periods Oliveiros d'Azevedo Cristina 16:37
Re: Merge overlapping time-periods Oliveiros d'Azevedo Cristina 16:49
finding gaps in temporal data Samuel Gendler 17:23
Re: Storage of Indian Language text in postgresql through PHP Jasen Betts 20:02
Re: finding gaps in temporal data Samuel Gendler 20:52
"<query expression body> ::= <joined table>" grammar rule not accepted by Postgres Clem Dickey 21:50

June 16, 2011

Thread Author Time
Re: "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres Tom Lane 05:59
Re: "<query expression body> ::= <joined table>" grammar rule not accepted by Postgres Clem Dickey 19:07
Re: Sqlite to postgres database conversion.swedish chararacter issue Viktor Bojović 22:08

June 17, 2011

Thread Author Time
pagination problem in postgresql need help hatem gamal elzanaty 22:43

June 18, 2011

Thread Author Time
Append n Rows into a Single Row Tripura 00:20
Re: Append n Rows into a Single Row Samuel Gendler 22:05

June 19, 2011

Thread Author Time
Re: Append n Rows into a Single Row Rob Sargent 03:33
Re: Append n Rows into a Single Row Samuel Gendler 03:51
Re: pagination problem in postgresql need help Jasen Betts 08:37

June 20, 2011

Thread Author Time
Re: pagination problem in postgresql need help Emi Lu 13:29
Query to select nested comments sorted by nesting and date Cstdenis 15:04
Re: Append n Rows into a Single Row Ross J. Reedstrom 17:05

June 21, 2011

Thread Author Time
problem with selecting from a function Andreas 01:55
Re: problem with selecting from a function Pavel Stehule 03:56
a strange order by behavior Eyal Wilde 10:37

June 22, 2011

Thread Author Time
Re: a strange order by behavior Samuel Gendler 08:43
Re: a strange order by behavior Pavel Stehule 08:45
Re: a strange order by behavior Samuel Gendler 09:39
Re: a strange order by behavior Pavel Stehule 10:01
Re: a strange order by behavior Samuel Gendler 10:15
Re: a strange order by behavior Samuel Gendler 10:39
Re: a strange order by behavior Samuel Gendler 11:20
Re: a strange order by behavior Pavel Stehule 13:44
Re: a strange order by behavior Tom Lane 14:49
Re: a strange order by behavior Peter Eisentraut 20:10
Re: a strange order by behavior Peter Eisentraut 20:12

June 23, 2011

Thread Author Time
Re: a strange order by behavior Pavel Stehule 03:57
Re: a strange order by behavior Samuel Gendler 04:34
Re: a strange order by behavior Peter Eisentraut 05:05
Re: a strange order by behavior Pavel Stehule 07:18
Union out performs the single statement John Fabiani 15:44
Re: Union out performs the single statement John Fabiani 16:45

June 27, 2011

Thread Author Time
best performance for simple dml chester c young 06:09
Re: best performance for simple dml Pavel Stehule 06:35
Re: best performance for simple dml chester c young 06:48
Re: best performance for simple dml Pavel Stehule 07:05
Re: best performance for simple dml chester c young 07:49
Re: best performance for simple dml Craig Ringer 08:02
Re: best performance for simple dml chester c young 13:02
Re: best performance for simple dml Pavel Stehule 13:40

June 30, 2011

Thread Author Time
How to remove a set of characters in text-columns ? Andreas 19:28
Re: How to remove a set of characters in text-columns ? Steve Crawford 19:49
Re: [SQL] How to remove a set of characters in text-columns ? Charlie 19:57

July 1, 2011

Thread Author Time
Re: How to remove a set of characters in text-columns ? Tim Landscheidt 02:17
Re: How to remove a set of characters in text-columns ? Andreas 02:43

July 4, 2011

Thread Author Time
Usage of function retruning record in query gmb 06:47
Re: Usage of function retruning record in query Harald Fuchs 13:41
Re: Usage of function retruning record in query gmb 13:59
Re: Usage of function retruning record in query lists-pgsql 18:31
Re: Usage of function retruning record in query lists-pgsql 19:28

July 5, 2011

Thread Author Time
Re: Usage of function retruning record in query gmb 08:21
Re: Usage of function retruning record in query Pavel Stehule 09:00
Re: Usage of function retruning record in query gmb 09:07
interesting sequence John Fabiani 13:52
group by with sum and sum till max date M. D. 17:42
Re: interesting sequence Samuel Gendler 19:38
Re: interesting sequence Kevin Crain 20:11
Re: interesting sequence Kevin Crain 20:13
overload Viktor Bojović 20:29
Re: interesting sequence John Fabiani 21:42

July 6, 2011

Thread Author Time
Re: interesting sequence Samuel Gendler 00:41
Re: interesting sequence Kevin Crain 01:00
Re: group by with sum and sum till max date Samuel Gendler 07:04
Re: interesting sequence Gavin Flower 09:47
Re: interesting sequence Jasen Betts 12:28
ERROR: malformed record literal: "", DETAIL: Missing left parenthesis? Emi Lu 15:53
Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Emi Lu 19:03
Re: interesting sequence (Correctin) Gavin Flower 19:38
Re: ERROR: malformed record literal: "",DETAIL: Missing left parenthesis? Adrian Klaver 22:06

July 8, 2011

Thread Author Time
Re: overload lists-pgsql 18:50
Re: overload Viktor Bojović 18:55
Re: overload Pavel Stehule 19:18
Re: overload lists-pgsql 19:49

July 10, 2011

Thread Author Time
using explain output within pgsql Uwe Bartels 18:54
Re: [SQL] using explain output within pgsql Pavel Stehule 19:20
Re: [SQL] using explain output within pgsql Adrian Klaver 19:20
Re: [SQL] using explain output within pgsql Uwe Bartels 19:34
what is similar to like operator in mysql for postgresql hatem gamal elzanaty 19:35
Re: [SQL] using explain output within pgsql Uwe Bartels 19:37
Re: [SQL] using explain output within pgsql Uwe Bartels 20:04
Re: [SQL] using explain output within pgsql Pavel Stehule 20:18
Re: what is similar to like operator in mysql for postgresql Scott Marlowe 21:11
Re: [SQL] using explain output within pgsql Gavin Flower 22:48

July 11, 2011

Thread Author Time
Re: overload Viktor Bojović 14:42
Re: overload Viktor Bojović 22:56

July 12, 2011

Thread Author Time
Looking for a "show create table <name>" equivalent B.Rathmann 08:33
newbie question * compare integer in a "where IN" statement Jose Ig Mendez 12:50
Max column number. Miguel Angel Conte 17:48
Re: Max column number. Reinoud van Leeuwen 17:52
Re: Max column number. Miguel Angel Conte 18:08
Re: Max column number. [email protected] 18:11
Re: Max column number. Miguel Angel Conte 18:25
Re: Max column number. Viktor Bojović 20:16
Re: Max column number. Scott Marlowe 20:45
Re: Max column number. Reinoud van Leeuwen 21:12
Re: Max column number. Miguel Angel Conte 23:29

July 13, 2011

Thread Author Time
combining strings to make a query Wes James 02:51
Re: interesting sequence Kevin Crain 04:57
Re: Max column number. Kevin Crain 05:56
Re: combining strings to make a query Kevin Crain 06:11
Re: Max column number. Kevin Crain 06:28
newbie question * compare integer in a "where IN" statement Jose Ig Mendez 07:36
Re: newbie question * compare integer in a "where IN" statement Thomas Kellerer 07:47
Re: newbie question * compare integer in a "where IN" statement Pavel Stehule 07:50
Re: newbie question * compare integer in a "where IN" statement Jose Ig Mendez 12:33
Select random lines of a table using a probability distribution Jira, Marcel 13:27
Re: Select random lines of a table using a probability distribution [email protected] 13:58
Re: combining strings to make a query Wes James 15:36
Re: Max column number. Miguel Angel Conte 15:45
Re: Max column number. Reinoud van Leeuwen 15:53
Re: Max column number. Scott Marlowe 16:51
Re: Max column number. Miguel Angel Conte 17:57
Re: Max column number. Kevin Crain 18:00
Re: Max column number. Miguel Angel Conte 18:03
Re: Max column number. Kevin Crain 18:07
Re: Max column number. Kevin Crain 18:20
Re: Looking for a "show create table <name>" equivalent Guillaume Lelarge 22:16
Re: Looking for a "show create table <name>" equivalent Wes James 22:38
Re: Looking for a "show create table <name>" equivalent Wes James 22:45

July 14, 2011

Thread Author Time
Re: Looking for a "show create table <name>" equivalent Jasen Betts 10:22
Re: [NOVICE] Compare rows Oliveiros d'Azevedo Cristina 11:30
Re: Looking for a "show create table <name>" equivalent Craig Ringer 23:40

July 18, 2011

Thread Author Time
to_char() accepting invalid dates? Thomas Kellerer 08:22
Re: to_char() accepting invalid dates? Jasen Betts 09:23
Re: to_char() accepting invalid dates? Thomas Kellerer 17:07
Re: to_char() accepting invalid dates? Bruce Momjian 22:02

July 19, 2011

Thread Author Time
Re: to_char() accepting invalid dates? Thomas Kellerer 11:30
Re: to_char() accepting invalid dates? Igor Neyman 14:09

July 20, 2011

Thread Author Time
Re: to_char() accepting invalid dates? Bruce Momjian 01:03
Re: to_char() accepting invalid dates? Thomas Kellerer 07:15
compile postgres with visual studio 2010 Sofer, Yuval 10:55
Re: compile postgres with visual studio 2010 Kevin Crain 14:39
LTREE extension and "order by" Ivan Polak 21:37

July 21, 2011

Thread Author Time
Re: LTREE extension and "order by" pasman pasmański 01:44
Re: LTREE extension and "order by" Ivan Polak 08:00
Re: LTREE extension and "order by" Carla 15:25
Re: LTREE extension and "order by" Ivan Polak 15:53
Re: LTREE extension and "order by" Carla 16:28
Re: LTREE extension and "order by" Pavel Stehule 16:48
Re: LTREE extension and "order by" Ivan Polak 17:31
Need to return one field for multiple Rows Ozer, Pam 23:09
Re: Need to return one field for multiple Rows Ozer, Pam 23:28

July 22, 2011

Thread Author Time
[No subject] James Kitambara 08:04

July 28, 2011

Thread Author Time
Help with regexp-query Johann Spies 11:20

July 29, 2011

Thread Author Time
Re: to_char() accepting invalid dates? THOMPSON, JARED (ATTBAPCO) 17:48

Aug. 1, 2011

Thread Author Time
why these results? Wes James 22:50
Re: why these results? Adrian Klaver 23:00
Re: why these results? Reinoud van Leeuwen 23:01
Re: why these results? Steve Crawford 23:01

Aug. 2, 2011

Thread Author Time
Re: why these results? Wes James 14:13
Re: [SQL] Help with regexp-query Charlie 17:06
Aggregating results across multiple partitions Mike O'Connel 20:20

Aug. 3, 2011

Thread Author Time
Re: Help with regexp-query Tim Landscheidt 04:05
Generic design: char vs varchar primary keys Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 15:10
Re: Generic design: char vs varchar primary keys Josh Kupershmidt 22:24

Aug. 4, 2011

Thread Author Time
Re: Generic design: char vs varchar primary keys Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=) 01:58
Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar 07:54
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Amitabh Kant 11:03
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar 11:42
Mysterious column "name" Nikolay 14:50
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Charlie 21:54
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Samuel Gendler 22:24

Aug. 5, 2011

Thread Author Time
Re: Calculating relative time/distance from CURRENT_TIMESTAMP Gnanakumar 09:07
Re: Generic design: char vs varchar primary keys Jasen Betts 12:40
Re: Generic design: char vs varchar primary keys Jasen Betts 12:43

Aug. 8, 2011

Thread Author Time
Problem with nested left-joins and coalesce ai 06:53
Re: Problem with nested left-joins and coalesce Carla 15:02
Re: Problem with nested left-joins and coalesce ai 15:34
Re: Problem with nested left-joins and coalesce Carla 19:14

Aug. 9, 2011

Thread Author Time
Re: Mysterious column "name" Oliveiros d'Azevedo Cristina 15:34
Re: Mysterious column "name" Steve Crawford 16:00
Re: Mysterious column "name" Tom Lane 16:04

Aug. 11, 2011

Thread Author Time
Stuck Up In My Own Category Tree Don Parris 15:39
Re: Stuck Up In My Own Category Tree Samuel Gendler 16:24
Re: Stuck Up In My Own Category Tree jasmin.dizdarevic 16:29
Re: Stuck Up In My Own Category Tree Edward W. Rouse 16:48
Re: Stuck Up In My Own Category Tree Don Parris 21:21

Aug. 12, 2011

Thread Author Time
Using variables in select tlund79 11:05
Re: Using variables in select Oliveiros d'Azevedo Cristina 16:03

Aug. 13, 2011

Thread Author Time
pgadmin debugger David Harel 19:39
Re: pgadmin debugger Adrian Klaver 19:56

Aug. 14, 2011

Thread Author Time
bigint and unix time Janiv Ratson 11:13
Re: pgadmin debugger David Harel 17:15
Re: bigint and unix time Adrian Klaver 17:57
Re: pgadmin debugger Adrian Klaver 18:07
Re: pgadmin debugger David Harel 18:33

Aug. 15, 2011

Thread Author Time
Re: bigint and unix time Janiv Ratson 06:23
Calculate the ratio Andreas Forø Tollefsen 12:21
Re: Calculate the ratio msi77 13:00
Re: Calculate the ratio David Johnston 13:08

Browse Archives

Prev | Next