pgsql-sql since 2011-05-19 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

May 19, 2011

Thread	Author	Time
Re: foreign keys and lots of tables	David W Noon	00:09
Re: client-side lo_import() provided by libpq ?	Craig Ringer	02:02
Re: column type for pdf file	Craig Ringer	02:15
Re: column type for pdf file	Piotr Czekalski	06:00
Re: SOLVED - foreign keys and lots of tables	Gary Stainburn	08:38
Re: column type for pdf file	Emi Lu	13:39
Re: column type for pdf file	Karsten Hilbert	13:53
Re: column type for pdf file	Craig Ringer	14:29
Re: column type for pdf file	Emi Lu	17:48

May 20, 2011

Thread	Author	Time
unnest in SELECT	Karl Koster	19:13
unnest in SELECT	Karl Koster	19:45

May 21, 2011

Thread	Author	Time
Re: unnest in SELECT	Andreas Kretschmer	06:58
Re: Which version of PostgreSQL should I use.	Gavin Baumanis	23:10
Re: Which version of PostgreSQL should I use.	Basil Bourque	23:45

May 22, 2011

Thread	Author	Time
Re: unnest in SELECT	Craig Ringer	03:23
extracting location info from string	Tarlika Elisabeth Schmitz	20:05
Re: extracting location info from string	Tarlika Elisabeth Schmitz	22:00

May 23, 2011

Thread	Author	Time
Re: extracting location info from string	Andrej	01:11
Re: extracting location info from string	Craig Ringer	01:42
Re: extracting location info from string	Lew	04:25
Re: extracting location info from string	Edward W. Rouse	15:17
Re: Which version of PostgreSQL should I use.	jasmin.dizdarevic	15:19
Re: extracting location info from string	Tarlika Elisabeth Schmitz	15:33
problem with update data sets from front ends 8.4, Ubuntu 10.04	Dean le Roux	16:53
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Samuel Gendler	18:01
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Dean le Roux	21:22
Re: extracting location info from string	Tarlika Elisabeth Schmitz	22:39
Re: Which version of PostgreSQL should I use.	Craig Ringer	23:18

May 24, 2011

Thread	Author	Time
Re: extracting location info from string	Craig Ringer	00:59
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Adrian Klaver	01:04
Re: Which version of PostgreSQL should I use.	Craig Ringer	06:48
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	10:49
Re: Which version of PostgreSQL should I use.	Jasmin Dizdarevic	10:58
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	11:45
Re: extracting location info from string	Lew	16:57
Re: Performance of NOT IN and <> with PG 9.0.4	Robert Haas	19:14
Problems Pgdump	manuel antonio ochoa	19:22
Re: Problems Pgdump	manuel antonio ochoa	19:26
Re: Performance of NOT IN and <> with PG 9.0.4	Robert Haas	19:49
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	21:10

May 25, 2011

Thread	Author	Time
Re: Which version of PostgreSQL should I use.	Craig Ringer	01:56
Re: Problems Pgdump	Craig Ringer	02:07
Re: Performance of NOT IN and <> with PG 9.0.4	Tom Lane	14:13
Re: Performance of NOT IN and <> with PG 9.0.4	Jasmin Dizdarevic	15:23
Re: extracting location info from string	Rob Sargent	15:25
Re: extracting location info from string	Tarlika Elisabeth Schmitz	18:14
Re: Performance of NOT IN and <> with PG 9.0.4	Robert Haas	19:49
Re: extracting location info from string	Tarlika Elisabeth Schmitz	21:13
Re: [SQL] extracting location info from string	Charlie	22:06
Re: extracting location info from string	Rob Sargent	22:07
Re: extracting location info from string	Andrej	22:15
Re: Sorting Issue	Ozer, Pam	22:18
Re: enum data type vs table	Peter Koczan	22:23
Re: enum data type vs table	Seb	23:08

May 26, 2011

Thread	Author	Time
Re: column type for pdf file	Ross J. Reedstrom	18:07
copy record?	Gauthier, Dave	20:23
Re: extracting location info from string	Tarlika Elisabeth Schmitz	20:40
Re: copy record?	Gauthier, Dave	21:04
Re: copy record?	Bosco Rama	21:18

May 27, 2011

Thread	Author	Time
Re: copy record?	Jasen Betts	04:45
Re: copy record?	Merlin Moncure	15:39
500KB PDF files for postgresql8.3, which is the most efficient way?	Emi Lu	16:12
Re: 500KB PDF files for postgresql8.3, which is the most efficient way?	Emi Lu	16:15
Re: [SQL] Re: 500KB PDF files for postgresql8.3, which is the most efficient way?	Samuel Gendler	19:28
Order of evaluation in triggers for checks on inherited table partitions	Kevin Crain	19:28
Re: Order of evaluation in triggers for checks on inherited table partitions	Tarlika Elisabeth Schmitz	19:52

May 28, 2011

Thread	Author	Time
Re: Re: 500KB PDF files for postgresql8.3, which is the most efficient way?	Piotr Czekalski	07:58
Function to total reset a schema	Surfing	14:16

May 29, 2011

Thread	Author	Time
Function to total reset a schema	Surfing	07:38
Re: Function to total reset a schema	Scott Marlowe	07:49
Re: Function to total reset a schema	Thomas Kellerer	07:54
Re: Function to total reset a schema	Surfing	08:03

May 30, 2011

Thread	Author	Time
Re: [SQL] 500KB PDF files for postgresql8.3, which is the most efficient way?	Enrico Weigelt	07:39
Re: Order of evaluation in triggers for checks on inherited table partitions	Jasen Betts	09:21
Re: Function to total reset a schema	Rob Sargent	14:45

May 31, 2011

Thread	Author	Time
Re: Re: Order of evaluation in triggers for checks on inherited table partitions	Kevin Crain	13:40
Re: Re: Order of evaluation in triggers for checks on inherited table partitions	Kevin Crain	14:46

June 1, 2011

Thread	Author	Time
Re: problem with update data sets from front ends 8.4, Ubuntu 10.04	Dean le Roux	15:00
9.0+ way of determining if a LISTEN channel has a backend listening?	James Robinson	15:51
Re: 9.0+ way of determining if a LISTEN channel has a backend listening?	Greg Sabino Mullane	22:22

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

Browse Archives

Prev | Next