pgsql-sql since 2011-06-03 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 3, 2011

Thread Author Time
selecting records X minutes apart lists-pgsql 19:52

June 4, 2011

Thread Author Time
Re: selecting records X minutes apart Kevin Crain 01:01
Re: selecting records X minutes apart Jasen Betts 11:45
Re: selecting records X minutes apart Kevin Crain 15:49
Re: selecting records X minutes apart lists-pgsql 18:58
Re: selecting records X minutes apart lists-pgsql 19:15
Re: selecting records X minutes apart Richard Broersma 20:09
Re: [SQL] selecting records X minutes apart Charlie 20:42
Re: selecting records X minutes apart lists-pgsql 20:49

June 5, 2011

Thread Author Time
Re: selecting records X minutes apart Kevin Crain 00:51
Re: selecting records X minutes apart Kevin Crain 00:56
Re: selecting records X minutes apart lists-pgsql 01:36
Re: selecting records X minutes apart Richard Broersma 02:10
Re: [SQL] selecting records X minutes apart Charlie 04:02
Re: selecting records X minutes apart Masaru Sugawara 11:52
Re: selecting records X minutes apart Masaru Sugawara 12:06
Re: selecting records X minutes apart lists-pgsql 19:42

June 6, 2011

Thread Author Time
To find process that lock a table manuel antonio ochoa 23:16
Re: To find process that lock a table Scott Marlowe 23:21

June 9, 2011

Thread Author Time
need help with some aggregation magic Andreas 13:43
Re: need help with some aggregation magic Oliveiros d'Azevedo Cristina 14:16
Re: need help with some aggregation magic Andreas 16:13
Re: need help with some aggregation magic Richard Broersma 16:20
Re: need help with some aggregation magic Andreas 16:55
Re: need help with some aggregation magic Edgardo Portal 21:22
Re: need help with some aggregation magic Kevin Crain 21:39

June 10, 2011

Thread Author Time
ANY for Array value check Emi Lu 15:10

June 11, 2011

Thread Author Time
Returning a set of dates C. Bensend 04:28
Re: Returning a set of dates Samuel Gendler 05:11
Re: ANY for Array value check Jasen Betts 09:59
Subselects not allowed? Leif Biberg Kristensen 15:01
Re: Subselects not allowed? Guillaume Lelarge 15:08
Re: Subselects not allowed? Tom Lane 15:14
Re: Subselects not allowed? Andreas Kretschmer 15:23
Re: Subselects not allowed? Leif Biberg Kristensen 15:23
Re: Subselects not allowed? Leif Biberg Kristensen 15:39
Re: Subselects not allowed? Leif Biberg Kristensen 20:09
Re: Returning a set of dates C. Bensend 22:18

June 12, 2011

Thread Author Time
Re: Subselects not allowed? Leif Biberg Kristensen 08:22
Re: Subselects not allowed? Andreas Kretschmer 08:37
Re: selecting records X minutes apart Gavin Flower 21:50

June 13, 2011

Thread Author Time
extract some column/value pairs via hstore Tarlika Elisabeth Schmitz 19:04

June 14, 2011

Thread Author Time
Storage of Indian Language text in postgresql through PHP INDER 07:17
Re: Subselects not allowed? Florian Weimer 14:00
Sqlite to postgres database conversion.swedish chararacter issue sara vanan 17:37
Re: Storage of Indian Language text in postgresql through PHP Amitabh Kant 20:14

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

Browse Archives

Prev | Next