pgsql-sql since 2011-06-20 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 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
Re: Calculate the ratio	David Johnston	13:10
Re: pgadmin debugger	Adrian Klaver	13:49
Re: Calculate the ratio	Andreas Forø Tollefsen	13:49
Re: bigint and unix time	Adrian Klaver	14:14
Re: pgadmin debugger	David Harel	18:53

Aug. 16, 2011

Thread	Author	Time
F_TABLE_NUMBER_RANGE equivalent in Postgresql	Yuan HOng	04:53
Re: F_TABLE_NUMBER_RANGE equivalent in Postgresql	msi77	05:19
Re: F_TABLE_NUMBER_RANGE equivalent in Postgresql	Pavel Stehule	05:21
Re: bigint and unix time	Janiv Ratson	09:12
Re: bigint and unix time	Janiv Ratson	09:15
Re: bigint and unix time	Janiv Ratson	09:19
which is better: using OR clauses or UNION?	Adam Witney	11:14
which is better: using OR clauses or UNION?	adam_pgsql	11:39
Re: which is better: using OR clauses or UNION?	Viktor Bojović	11:56
Re: bigint and unix time	Adrian Klaver	13:43
Re: which is better: using OR clauses or UNION?	David Johnston	14:06
Re: which is better: using OR clauses or UNION?	Tom Lane	14:09
Re: which is better: using OR clauses or UNION?	Jasen Betts	14:27
Re: which is better: using OR clauses or UNION?	adam_pgsql	14:52

Browse Archives

Prev | Next