pgsql-sql before 2012-08-30 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, 2012

Thread	Author	Time
Need help in grouping records	Andreas	19:04

May 20, 2012

Thread	Author	Time
Re: Need help in grouping records	Jasen Betts	03:04
Re: Need help in grouping records	Andreas	09:08
master/detail	Jan Bakuwel	23:17

May 21, 2012

Thread	Author	Time
Re: master/detail	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	03:10
Re: master/detail	Andreas Kretschmer	04:34
Re: master/detail	Mario Dankoor	11:57
Select every first/last record of a partition?	Andreas	16:04
Re: Select every first/last record of a partition?	Seth Gordon	21:17

May 22, 2012

Thread	Author	Time
Re: master/detail	Jan Bakuwel	07:28
Understanding Binary Data Type	Carlos Mennens	17:13

May 23, 2012

Thread	Author	Time
sub query and AS	Ferruccio Zamuner	09:24
left outer join only select newest record	Gary Stainburn	09:27
Re: left outer join only select newest record	Oliveiros d'Azevedo Cristina	09:37
Re: left outer join only select newest record	Pavel Stehule	09:46
Re: left outer join only select newest record	Gary Stainburn	09:47
Re: left outer join only select newest record	Thomas Kellerer	10:22
Re: left outer join only select newest record	Oliveiros d'Azevedo Cristina	10:29
Re: left outer join only select newest record	Gary Stainburn	10:33
Re: left outer join only select newest record	Oliveiros d'Azevedo Cristina	10:41
Re: sub query and AS	Lee Hachadoorian	19:07

May 24, 2012

Thread	Author	Time
Re: Understanding Binary Data Type	Jasen Betts	06:09
Re: sub query and AS	Samuel Gendler	07:07
Re: left outer join only select newest record	Pavel Stehule	08:17
Re: left outer join only select newest record	Gary Stainburn	08:21
Re: left outer join only select newest record	Oliveiros d'Azevedo Cristina	08:27
Flatten table using timestamp and source	Elrich Marx	09:01
Re: Flatten table using timestamp and source	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	11:59
Re: Flatten table using timestamp and source	Elrich Marx	12:10
Re: Understanding Binary Data Type	F. BROUARD / SQLpro	16:36
Inherited table identification possible	George Woodring	18:01
Re: Inherited table identification possible	Jonathan S. Katz	18:09
Re: Inherited table identification possible	Stephen Belcher	18:11

May 25, 2012

Thread	Author	Time
Re: Flatten table using timestamp and source	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	05:50
Job control in sql	Svenne Krap	08:28
Select row cells as new columns	danycxxx	09:03
Re: Select row cells as new columns	Jan Lentfer	12:41
Re: Job control in sql	Jan Lentfer	12:52
Re: Select row cells as new columns	danycxxx	12:57
Re: Inherited table identification possible	George Woodring	13:40

May 26, 2012

Thread	Author	Time
Re: Flatten table using timestamp and source	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	02:56
Re: Flatten table using timestamp and source	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	05:43

May 27, 2012

Thread	Author	Time
Re: order by different on mac vs linux	Wes James	03:37
Re: order by different on mac vs linux	Wes James	03:47
Re: order by different on mac vs linux	Jasen Betts	05:41

May 29, 2012

Thread	Author	Time
possible bug in psql	chester c young	03:11
Re: possible bug in psql	Tom Lane	03:34
Re: Job control in sql	Ireneusz Pluta	10:01
Re: Job control in sql	Ireneusz Pluta	10:32
Re: possible bug in psql	Jasen Betts	11:48
Re: Job control in sql	Svenne Krap	15:19

May 30, 2012

Thread	Author	Time
Re: possible bug in psql	Craig Ringer	01:13
Re: possible bug in psql	chester c young	03:33

May 31, 2012

Thread	Author	Time
Re: Select row cells as new columns	lewbloch	16:55
Re: Job control in sql	lewbloch	16:56
Re: Job control in sql	lewbloch	16:58
Re: order by different on mac vs linux	Wes James	17:46
Re: order by different on mac vs linux	Peter Eisentraut	19:52

June 1, 2012

Thread	Author	Time
Lowest 2 items per	Relyea, Mike	14:34
Re: Lowest 2 items per	Oliveiros d'Azevedo Cristina	14:56
Re: Lowest 2 items per	David Johnston	15:13
Re: Lowest 2 items per	Oliveiros d'Azevedo Cristina	15:20
Re: Lowest 2 items per	Relyea, Mike	15:44
Re: Lowest 2 items per	Relyea, Mike	16:17
Re: Lowest 2 items per	Oliveiros d'Azevedo Cristina	16:28
Re: Lowest 2 items per	Relyea, Mike	16:35
Re: Lowest 2 items per	Oliveiros d'Azevedo Cristina	16:58
Re: Lowest 2 items per	Mario Dankoor	18:31
Re: Lowest 2 items per	Relyea, Mike	19:55
Re: Lowest 2 items per	Relyea, Mike	20:04

June 2, 2012

Thread	Author	Time
Re: Lowest 2 items per	msi77	13:56
Re: Lowest 2 items per	Oliveiros	15:00
Re: Lowest 2 items per	msi77	16:32

June 4, 2012

Thread	Author	Time
How to use hstore	Jan Eskilsson	12:08

June 5, 2012

Thread	Author	Time
Re: How to use hstore	Sergey Konoplev	06:05
Re: How to use hstore	Jan Eskilsson	06:14
creating a new trigger for a table on a slave host	rverghese	18:00

June 6, 2012

Thread	Author	Time
defaults in a function	John Fabiani	15:08
Re: defaults in a function	David Johnston	15:27

June 7, 2012

Thread	Author	Time
using ordinal_position	John Fabiani	23:17
Re: using ordinal_position	David Johnston	23:32

June 11, 2012

Thread	Author	Time
Re: using ordinal_position	Igor Neyman	13:53
Re: using ordinal_position	John Fabiani	15:10
Re: using ordinal_position	Igor Neyman	15:14

June 13, 2012

Thread	Author	Time
Partitioned Tables	Wayne Cuddy	00:05
how to use schema with data type	John Fabiani	00:46
Re: Partitioned Tables	Craig Ringer	02:37
Re: how to use schema with data type	Craig Ringer	02:39

June 14, 2012

Thread	Author	Time
Insane behaviour in 8.3.3	Achilleas Mantzios	08:39

June 15, 2012

Thread	Author	Time
Re: Insane behaviour in 8.3.3	Adrian Klaver	02:18
Re: Insane behaviour in 8.3.3	Richard Huxton	06:34
Re: Insane behaviour in 8.3.3	Robert Edwards	07:23
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	07:25
Re: Insane behaviour in 8.3.3	Scott Marlowe	07:28
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	08:24
Re: Insane behaviour in 8.3.3	Samuel Gendler	09:28
Re: Insane behaviour in 8.3.3	Samuel Gendler	09:29
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	10:01
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	10:06
Re: Insane behaviour in 8.3.3	Scott Marlowe	15:03
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	15:32
Re: Insane behaviour in 8.3.3	Richard Huxton	15:41
Re: Insane behaviour in 8.3.3	Scott Marlowe	16:59
Re: Insane behaviour in 8.3.3	Raj Mathur ( राज =?utf-8?b?IOCkruCkvuCkpeClgeCksA==?=)	17:28

June 17, 2012

Thread	Author	Time
Re: Insane behaviour in 8.3.3	Jasen Betts	12:43
Re: Insane behaviour in 8.3.3	Jasen Betts	12:55

June 18, 2012

Thread	Author	Time
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	08:36
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	08:39
Re: Insane behaviour in 8.3.3	Karsten Hilbert	09:17

June 19, 2012

Thread	Author	Time
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	09:17

June 20, 2012

Thread	Author	Time
Re: Insane behaviour in 8.3.3	Craig Ringer	04:08
Re: Insane behaviour in 8.3.3	Achilleas Mantzios	05:54
Simple method to format a string	Emi Lu	14:42
Is there a similarity-function that minds national charsets?	Andreas	16:30
Re: Simple method to format a string	Wes James	18:08
Re: Simple method to format a string	[email protected]	18:21
Re: Simple method to format a string	Emi Lu	19:45

June 21, 2012

Thread	Author	Time
Re: Is there a similarity-function that minds national charsets?	Craig Ringer	02:53
Need help building this query	Rihad	17:48
Re: Need help building this query	David Johnston	18:40
Re: Need help building this query	Oliver d'Azevedo Christina	18:50
Re: Need help building this query	Oliver d'Azevedo Christina	19:18

June 22, 2012

Thread	Author	Time
Re: Need help building this query	rihad	04:40
Re: Need help building this query	rihad	05:56
Re: Need help building this query	rihad	05:57
How to limit access only to certain records?	Andreas	11:36
Re: How to limit access only to certain records?	Andreas Kretschmer	12:32
Re: How to limit access only to certain records?	Jov	12:35
Re: How to limit access only to certain records?	Jayadevan M	13:03
Re: How to limit access only to certain records?	hari.fuchs	14:52

June 24, 2012

Thread	Author	Time
Re: How to limit access only to certain records?	Craig Ringer	06:58
Re: How to limit access only to certain records?	Dickson S. Guedes	20:00

June 28, 2012

Thread	Author	Time
How to solve the old bool attributes vs pivoting issue?	Andreas	01:07
Re: How to solve the old bool attributes vs pivoting issue?	David Johnston	02:26
Re: How to solve the old bool attributes vs pivoting issue?	Samuel Gendler	04:16

June 29, 2012

Thread	Author	Time
must appear in GROUP by clause issue	George Woodring	20:02
Re: must appear in GROUP by clause issue	Adrian Klaver	20:19

June 30, 2012

Thread	Author	Time
Re: must appear in GROUP by clause issue	Lee Hachadoorian	04:34

July 2, 2012

Thread	Author	Time
Re: must appear in GROUP by clause issue	George Woodring	13:01

July 10, 2012

Thread	Author	Time
Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)	Chris Preston	15:28
Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)	Steve Crawford	15:38

July 11, 2012

Thread	Author	Time
Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)	Craig Ringer	03:41
Prevent double entries ... no simple unique index	Andreas	07:50
Re: Prevent double entries ... no simple unique index	Andreas Kretschmer	08:16
Re: Prevent double entries ... no simple unique index	Andreas Kretschmer	08:24
Re: Prevent double entries ... no simple unique index	Rosser Schwarz	09:11
Re: Prevent double entries ... no simple unique index	Marc Mamin	10:53

July 12, 2012

Thread	Author	Time
Re: Prevent double entries ... no simple unique index	Andreas Kretschmer	05:14
Re: Prevent double entries ... no simple unique index	Andreas	08:44
Re: Prevent double entries ... no simple unique index	David Johnston	13:40
How does Numeric division determine precision?	Will Pugh	16:02
Re: How does Numeric division determine precision?	Tom Lane	17:30

July 14, 2012

Thread	Author	Time
Re: Simple Upgrade from PostgreSQL version 8.1.11 (With schemas)	Jasen Betts	03:22

July 16, 2012

Thread	Author	Time
Selecting data from XML	Victor Sterpu	19:56

July 17, 2012

Thread	Author	Time
Re: Selecting data from XML	Craig Ringer	03:23

July 18, 2012

Thread	Author	Time
Order preservation of search phrases in postgresql FTS/OpenFTS	Puneet Mishra	06:48

July 19, 2012

Thread	Author	Time
DELETE using an outer join	Thomas Kellerer	12:43
Re: DELETE using an outer join	Sergey Konoplev	14:33
Re: DELETE using an outer join	Tom Lane	14:52

July 20, 2012

Thread	Author	Time
Re: DELETE using an outer join	Thomas Kellerer	08:17
Re: DELETE using an outer join	Sergey Konoplev	08:21
Re: DELETE using an outer join	Thomas Kellerer	10:27
Re: DELETE using an outer join	Sergey Konoplev	10:47
Re: DELETE using an outer join	Tom Lane	13:51
Re: DELETE using an outer join	Sergey Konoplev	14:13

July 23, 2012

Thread	Author	Time
query two tables using same lookup table	ssylla	03:04
Re: query two tables using same lookup table	David Johnston	04:45

July 26, 2012

Thread	Author	Time
FW: view derived from view doesn't use indexes	Russell Keane	14:59
Re: FW: view derived from view doesn't use indexes	Tom Lane	15:51

July 27, 2012

Thread	Author	Time
Re: FW: view derived from view doesn't use indexes	Russell Keane	10:33

July 28, 2012

Thread	Author	Time
join against a function-result fails	Andreas	01:57
Re: join against a function-result fails	David Johnston	02:31

Aug. 1, 2012

Thread	Author	Time
query structure for selecting row by tags	Samuel Gendler	19:40

Aug. 2, 2012

Thread	Author	Time
can this be done with a check expression?	Wayne Cuddy	23:10
Re: can this be done with a check expression?	Tom Lane	23:23

Aug. 3, 2012

Thread	Author	Time
Re: can this be done with a check expression?	Andreas Kretschmer	05:40
Re: can this be done with a check expression?	Jonathan S. Katz	15:50
Re: can this be done with a check expression?	Wayne Cuddy	19:50

Aug. 8, 2012

Thread	Author	Time
Re: can this be done with a check expression?	Wayne Cuddy	15:41
Re: can this be done with a check expression?	Wayne Cuddy	15:43
fsync debug messages in pgsql logs	Wayne Cuddy	15:44
Re: fsync debug messages in pgsql logs	Tom Lane	16:23
Re: fsync debug messages in pgsql logs	Wayne Cuddy	16:53
Re: fsync debug messages in pgsql logs	Tom Lane	16:57
Re: fsync debug messages in pgsql logs	Wayne Cuddy	17:11

Aug. 14, 2012

Thread	Author	Time
Indexing question	amit sehas	16:54
Re: Indexing question	David Johnston	17:19
Re: Indexing question	Andreas Kretschmer	17:33

Aug. 17, 2012

Thread	Author	Time
Error: Template Id should be teh identifier of a template - help	Alex	15:58
Re: Error: Template Id should be teh identifier of a template - help	David Johnston	16:18
Re: Error: Template Id should be teh identifier of a template - help	Tom Lane	17:28

Aug. 20, 2012

Thread	Author	Time
generated dates from record dates - suggestions	Gary Stainburn	12:17
Re: generated dates from record dates - suggestions	Oliveiros d'Azevedo Cristina	14:19

Aug. 21, 2012

Thread	Author	Time
Re: generated dates from record dates - suggestions	Gary Stainburn	10:31
Re: generated dates from record dates - suggestions	Jasen Betts	11:14
Re: generated dates from record dates - suggestions	Gary Stainburn	12:15

Aug. 22, 2012

Thread	Author	Time
Re: generated dates from record dates - suggestions	Gary Stainburn	10:49

Aug. 29, 2012

Thread	Author	Time
Tablesample Function on Postgres 9.1	Mubarik, Aiysha	19:48
Tablesample Function on Postgres 9.1	Mubarik, Aiysha	19:52
Re: Tablesample Function on Postgres 9.1	Tom Lane	20:07

Browse Archives

Prev | Next