Quick Links

pgsql-sql since 2012-06-11 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

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

Aug. 30, 2012

Thread	Author	Time
Re: Tablesample Function on Postgres 9.1	Craig Ringer	02:20

Aug. 31, 2012

Thread	Author	Time
Need to Iterate the record in plpgsql	Yelai, Ramkumar IN BLR STS	14:55
locks and "select for update"	Wayne Cuddy	17:05
Re: locks and "select for update"	Tom Lane	19:28

Sept. 1, 2012

Thread	Author	Time
prepared statement in crosstab query	Samuel Gendler	01:53
Re: prepared statement in crosstab query	David Johnston	02:24

Sept. 4, 2012

Thread	Author	Time
Re: Need to Iterate the record in plpgsql	Pavel Stehule	06:22
Re: Need to Iterate the record in plpgsql	Yelai, Ramkumar IN BLR STS	09:31
Re: Need to Iterate the record in plpgsql	Sergey Konoplev	09:56
Question regarding modelling for time series	Alex Grund	20:16

Sept. 5, 2012

Thread	Author	Time
Re: Question regarding modelling for time series	Sergey Konoplev	05:36
Re: Question regarding modelling for time series	Alex Grund	07:39
Re: Question regarding modelling for time series	Sergey Konoplev	09:13

Sept. 6, 2012

Thread	Author	Time
Re: Need to Iterate the record in plpgsql	Yelai, Ramkumar IN BLR STS	12:23
Re: Need to Iterate the record in plpgsql	David Johnston	13:58

Sept. 8, 2012

Thread	Author	Time
returning values from dynamic SQL to a variable	James Sharrett	19:39
returning values to variables from dynamic SQL	James Sharrett	22:23
Re: returning values to variables from dynamic SQL	David Johnston	23:42

Sept. 9, 2012

Thread	Author	Time
Query with LIMIT clause	JORGE MALDONADO	17:25
Re: Query with LIMIT clause	David Johnston	17:45

Sept. 10, 2012

Thread	Author	Time
Re: Query with LIMIT clause	JORGE MALDONADO	00:56
Re: Query with LIMIT clause	David Johnston	01:49
Re: returning values from dynamic SQL to a variable	Sergey Konoplev	11:15

Sept. 11, 2012

Thread	Author	Time
weird join producing too many rows	Gary Stainburn	14:42

Sept. 12, 2012

Thread	Author	Time
pg_restore problem	Kjell Øygard	07:23
Re: weird join producing too many rows	Samuel Gendler	07:24
Re: weird join producing too many rows	Gary Stainburn	08:17
ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D	Rodrigo Rosenfeld Rosas	21:44
Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D	Samuel Gendler	21:53
Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D	Gavin Flower	22:34
Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D	Rodrigo Rosenfeld Rosas	23:18
Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D	Rodrigo Rosenfeld Rosas	23:20
generate_series() with TSTZRANGE	Wolfe Whalen	23:53

Sept. 13, 2012

Thread	Author	Time
Problem with committing the update	BeeBee	06:49
underscore pattern in a query doens't work	Sergio Calero.	11:23
Re: pg_restore problem	Adrian Klaver	13:46
Re: generate_series() with TSTZRANGE	Sergey Konoplev	13:52
Re: underscore pattern in a query doens't work	Tom Lane	14:19
Re: underscore pattern in a query doens't work	Sergio C.	15:04
Re: underscore pattern in a query doens't work	Tom Lane	15:42
Re: generate_series() with TSTZRANGE	Wolfe Whalen	18:13

Sept. 14, 2012

Thread	Author	Time
ERROR: missing FROM-clause entry for table "new"	James Sharrett	00:40
Re: ERROR: missing FROM-clause entry for table "new"	David Johnston	01:06
Re: ERROR: missing FROM-clause entry for table "new"	James Sharrett	14:06
Re: pg_restore problem	Adrian Klaver	14:58

Sept. 15, 2012

Thread	Author	Time
Re: Problem with committing the update	Jasen Betts	01:54

Sept. 17, 2012

Thread	Author	Time
Re: ORDER BY COLUMN_A, (COLUMN_B or COLUMN_C), COLUMN_D	Craig Ringer	04:52
Disabling constraint check	Salomao Domingos	18:58
Re: Disabling constraint check	Oliveiros d'Azevedo Cristina	19:33
Re: Disabling constraint check	Richard Broersma	20:42

Sept. 20, 2012

Thread	Author	Time
matching a timestamp field	BACHELART PIERRE (CIS/SCC)	11:01
Re: matching a timestamp field	BACHELART PIERRE (CIS/SCC)	12:21

Sept. 22, 2012

Thread	Author	Time
Re: matching a timestamp field	Andreas Kretschmer	08:08
Re: matching a timestamp field	Pavel Stehule	08:16
transactions and ecpg	Wayne Cuddy	17:34

Sept. 23, 2012

Thread	Author	Time
[No subject]	JORGE MALDONADO	00:15
Re:	David Johnston	01:50
Re: transactions and ecpg	Dmitriy Igrishin	07:29
HOw to convert unicode to string	Abhijit Prusty -X (abprusty - UST Global at Cisco)	14:41

Sept. 26, 2012

Thread	Author	Time
Re: HOw to convert unicode to string	Jasen Betts	12:50

Sept. 27, 2012

Thread	Author	Time
Help in accessing array	mephysto	10:12

Sept. 29, 2012

Thread	Author	Time
Reuse temporary calculation results in an SQL update query	Matthias Nagel	10:49
Re: Reuse temporary calculation results in an SQL update query	Thomas Kellerer	10:55
Re: Reuse temporary calculation results in an SQL update query	Andreas Kretschmer	10:56
Re: Reuse temporary calculation results in an SQL update query	Matthias Nagel	11:04
Re: Reuse temporary calculation results in an SQL update query	Jasen Betts	11:20
Re: Reuse temporary calculation results in an SQL update query	David Johnston	13:43
Re: Reuse temporary calculation results in an SQL update query	Thomas Kellerer	14:13
Re: Reuse temporary calculation results in an SQL update query	Andreas Kretschmer	15:13
Re: Reuse temporary calculation results in an SQL update query [SOLVDED]	Matthias Nagel	15:46
Need help with a special JOIN	Andreas	16:02
Re: Need help with a special JOIN	Samuel Gendler	17:32
Re: Need help with a special JOIN	David Johnston	17:33
Re: Need help with a special JOIN	Victor Sterpu	18:28
Re: Need help with a special JOIN	Johnny Winn	19:11

Sept. 30, 2012

Thread	Author	Time
Re: Reuse temporary calculation results in an SQL update query [SOLVDED]	David Johnston	16:26

Oct. 2, 2012

Thread	Author	Time
[noob] How to optimize this double pivot query?	Robert Buck	00:47
Re: [noob] How to optimize this double pivot query?	David Johnston	01:07
Re: [noob] How to optimize this double pivot query?	Robert Buck	01:13
Re: [noob] How to optimize this double pivot query?	David Johnston	01:28
Re: [noob] How to optimize this double pivot query?	Thomas Kellerer	06:46

Browse Archives

Prev | Next