pgsql-sql since 2012-08-01 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

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
Re: [noob] How to optimize this double pivot query? Samuel Gendler 09:21
Re: [noob] How to optimize this double pivot query? Robert Buck 09:45
Re: Help in accessing array David Johnston 13:53
Re: [noob] How to optimize this double pivot query? Samuel Gendler 19:57
Re: [noob] How to optimize this double pivot query? Samuel Gendler 20:09

Oct. 3, 2012

Thread Author Time
Re: [noob] How to optimize this double pivot query? Robert Buck 16:23
Re: [noob] How to optimize this double pivot query? Robert Buck 16:31
Re: [noob] How to optimize this double pivot query? Samuel Gendler 20:05

Oct. 4, 2012

Thread Author Time
Calling the CTE for multiple inputs air 19:31
String Search Fabio Ebner - Dna Solution 19:40
Re: Calling the CTE for multiple inputs David Johnston 19:51
Re: String Search David Johnston 19:57

Oct. 5, 2012

Thread Author Time
Re: Calling the CTE for multiple inputs Craig Ringer 03:34
checking the gaps in intervals Anton Gavazuk 22:42

Oct. 6, 2012

Thread Author Time
Re: checking the gaps in intervals Andreas Kretschmer 07:44
Re: checking the gaps in intervals Andreas Kretschmer 07:55
Re: checking the gaps in intervals Gavin Flower 08:04
How to make this CTE also print rows with 0 as count? air 12:47
Re: Calling the CTE for multiple inputs air 12:56
Re: How to make this CTE also print rows with 0 as count? David Johnston 17:30
Re: checking the gaps in intervals Gavin Flower 21:58

Oct. 7, 2012

Thread Author Time
Re: Calling the CTE for multiple inputs Jasen Betts 01:02
Re: checking the gaps in intervals Jasen Betts 01:30

Oct. 8, 2012

Thread Author Time
Error 42704 Kim Bisgaard 15:38

Oct. 11, 2012

Thread Author Time
Database object names and libpq in UTF-8 locale on Windows Sebastien FLAESCH 08:56
Re: Database object names and libpq in UTF-8 locale on Windows Tom Lane 14:03
Re: Database object names and libpq in UTF-8 locale on Windows Sebastien FLAESCH 14:13
Re: checking the gaps in intervals Gavin Flower 20:25

Oct. 14, 2012

Thread Author Time
rolling statistic probaply a window function? Andreas 17:43

Oct. 19, 2012

Thread Author Time
Recursive temporal query Liam Caffrey 15:40
Re: Recursive temporal query Liam Caffrey 15:41
Re: Recursive temporal query Liam Caffrey 15:46
Trigger triggered from a foreign key Victor Sterpu 18:14
Re: Trigger triggered from a foreign key David Johnston 18:24
Insert strings that contain colons into a table lmagnell 20:24
Re: Insert strings that contain colons into a table David Johnston 20:34
Re: Insert strings that contain colons into a table lmagnell 20:49

Oct. 21, 2012

Thread Author Time
Partition database between users and implement disk quotas Brice André 19:18

Oct. 22, 2012

Thread Author Time
Re: Trigger triggered from a foreign key Jasen Betts 11:29

Oct. 26, 2012

Thread Author Time
pull in most recent record in a view Gary Stainburn 09:02
Re: pull in most recent record in a view Gary Stainburn 09:24

Oct. 28, 2012

Thread Author Time
complex query 📎 Mark Fenbers 00:01
Re: complex query Scott Marlowe 00:24
Re: complex query 📎 Mark Fenbers 01:56
Re: complex query Scott Marlowe 02:20
Re: complex query Oliveiros d'Azevedo Cristina 11:15
Re: pull in most recent record in a view David Johnston 14:54

Oct. 29, 2012

Thread Author Time
Fun with Dates 📎 Mark Fenbers 22:38
Re: Fun with Dates Thomas Kellerer 22:44
Re: Fun with Dates 📎 Mark Fenbers 22:51

Oct. 30, 2012

Thread Author Time
replace text occurrences loaded from table jan zimmek 11:45
Re: replace text occurrences loaded from table David Johnston 15:08
Fwd: replace text occurrences loaded from table jan zimmek 15:15

Nov. 5, 2012

Thread Author Time
Re: Date Index Adam Tauno Williams 10:54
Re: Date Index Tom Lane 15:13

Nov. 7, 2012

Thread Author Time
find sudstring on text (data type) field failure pantelis vlachos 08:36

Nov. 11, 2012

Thread Author Time
How to compare two tables in PostgreSQL saikiran mothe 03:13
Re: find sudstring on text (data type) field failure Craig Ringer 10:24

Nov. 12, 2012

Thread Author Time
Re: How to compare two tables in PostgreSQL Rob Sargentg 07:23
Re: find sudstring on text (data type) field failure Achilleas Mantzios 07:52
Re: How to compare two tables in PostgreSQL Allan Kamau 08:00
Re: How to compare two tables in PostgreSQL Willem Leenen 09:13
Re: How to compare two tables in PostgreSQL Willem Leenen 09:20
Re: How to compare two tables in PostgreSQL Devrim GÜNDÜZ 09:28
Re: How to compare two tables in PostgreSQL Allan Kamau 10:44

Nov. 13, 2012

Thread Author Time
Re: How to compare two tables in PostgreSQL Igor Neyman 15:19

Nov. 17, 2012

Thread Author Time
organizing cron jobs in one function Louis-David Mitterrand 16:19

Nov. 18, 2012

Thread Author Time
Re: organizing cron jobs in one function Jasen Betts 00:50
Re: organizing cron jobs in one function Craig Ringer 11:27
Re: organizing cron jobs in one function Louis-David Mitterrand 17:11

Nov. 19, 2012

Thread Author Time
Re: organizing cron jobs in one function Craig Ringer 00:31
Re: organizing cron jobs in one function Louis-David Mitterrand 10:09

Nov. 20, 2012

Thread Author Time
regexp_replace behavior Marcin Krawczyk 14:43
Re: regexp_replace behavior Alvaro Herrera 14:55
Re: regexp_replace behavior Marcin Krawczyk 15:02

Nov. 26, 2012

Thread Author Time
Using regexp_matches in the WHERE clause Thomas Kellerer 12:13

Nov. 27, 2012

Thread Author Time
locks problem Marcin Krawczyk 09:27
output query on many to many relationship into several columns ssylla 09:59
Re: locks problem Marcin Krawczyk 10:01
select on many-to-many relationship ssylla 10:13
Re: Using regexp_matches in the WHERE clause Willem Leenen 11:44
Re: Using regexp_matches in the WHERE clause Thomas Kellerer 12:08
Re: Using regexp_matches in the WHERE clause Pavel Stehule 12:26
Re: Using regexp_matches in the WHERE clause Thomas Kellerer 12:30
Re: Using regexp_matches in the WHERE clause Pavel Stehule 12:35
Re: Using regexp_matches in the WHERE clause David Johnston 14:22
Re: select on many-to-many relationship Виктор Егоров 17:48

Nov. 28, 2012

Thread Author Time
Re: select on many-to-many relationship Sergey Konoplev 00:27
Joining several rows into only one JORGE MALDONADO 18:33
Re: Joining several rows into only one Jonathan S. Katz 18:37
Re: Joining several rows into only one Oliver d'Azevedo Cristina 18:42

Browse Archives

Prev | Next