pgsql-sql since 2009-04-09 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

April 9, 2009

Thread	Author	Time
Re: join help 📎	Justin	01:38
Re: join help	Kashmir	03:28
Re: Nested selects	Steve Midgley	15:13

April 10, 2009

Thread	Author	Time
Re: changing multiple pk's in one update	Jasen Betts	14:32
Re: How would I get rid of trailing blank line?	Jasen Betts	15:09
Re: changing multiple pk's in one update	Scott Marlowe	18:20
Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps	Jasen Betts	22:41

April 12, 2009

Thread	Author	Time
ERROR: operator does not exist: date ~~ unknown	Rohit Suman	05:58
Re: ERROR: operator does not exist: date ~~ unknown	Pavel Stehule	07:36
Fw: ERROR: operator does not exist: date ~~ unknown	Rohit Suman	09:50
Re: Fw: ERROR: operator does not exist: date ~~ unknown	Tom Lane	15:16
Re: ENUM vs DOMAIN vs FKyed loookup table	Dirk Jagdmann	18:08

April 13, 2009

Thread	Author	Time
Re: changing multiple pk's in one update	Stuart McGraw	16:53
Re: changing multiple pk's in one update	Richard Broersma	17:02
Re: changing multiple pk's in one update	Stuart McGraw	17:20
Re: changing multiple pk's in one update	Glenn Maynard	21:09
Re: changing multiple pk's in one update	Richard Broersma	21:18
Re: changing multiple pk's in one update	Glenn Maynard	21:32
Re: changing multiple pk's in one update	Richard Broersma	21:43
Re: changing multiple pk's in one update	Glenn Maynard	22:01

April 14, 2009

Thread	Author	Time
Re: changing multiple pk's in one update	Stuart McGraw	02:27
Postgres entering zombie state once a week in production evnvironment	Bryce Nesbitt	06:25
Re: Postgres entering zombie state once a week in production evnvironment	Achilleas Mantzios	07:26
Re: Postgres entering zombie state once a week in production evnvironment	Scott Marlowe	07:29
Re: ENUM vs DOMAIN vs FKyed loookup table	Mario Splivalo	13:43
Re: Postgres entering zombie state once a week in production evnvironment	Bryce Nesbitt	20:07
Re: changing multiple pk's in one update	Steve Midgley	20:20
Re: Postgres entering zombie state once a week in production evnvironment	Bryce Nesbitt	20:59
Re: Postgres entering zombie state once a week in production evnvironment	Scott Marlowe	21:05

April 15, 2009

Thread	Author	Time
Postgres process resident size does not drop after killing statement	Bryce Nesbitt	03:46
Re: changing multiple pk's in one update	Jasen Betts	12:43
Re: ENUM vs DOMAIN vs FKyed loookup table	Jasen Betts	12:57
Re: Postgres process resident size does not drop after killing statement	Tom Lane	13:58
Re: ENUM vs DOMAIN vs FKyed loookup table	Chris Browne	16:43
How to count from a second table in an aggregate query?	Steve Midgley	20:15
Re: changing multiple pk's in one update	Glenn Maynard	20:25

April 16, 2009

Thread	Author	Time
Re: How to count from a second table in an aggregate query?	Erik Jones	00:02
Re: How to count from a second table in an aggregate query?	Steve Midgley	04:23
Re: Re: SQL to Check whether "AN HOUR PERIOD" is between start and end timestamps	Andreas Joseph Krogh	10:21
Ordering a name list and ignoring whitespace	Mikel Lindsaar	10:51
Re: Ordering a name list and ignoring whitespace	Mario Splivalo	11:02
Need a script that bakes INSERT script from SELECT results	ShuA	11:29
Re: Need a script that bakes INSERT script from SELECT results	John DeSoi	12:25
Re[2]: Need a script that bakes INSERT script from SELECT results	ShuA	13:24
Re: Ordering a name list and ignoring whitespace	Tom Lane	14:13
how to set the value to the column	DM	19:00
Re: how to set the value to the column	DM	19:11
Re: how to set the value to the column	Andreas Kretschmer	19:11
Re: finding UNIQUES in information_schema	Tom Lane	19:12
finding UNIQUES in information_schema	Gerardo Herzig	19:33
Re: finding UNIQUES in information_schema	Tom Lane	20:09
Re: finding UNIQUES in information_schema	Gerardo Herzig	20:44

April 17, 2009

Thread	Author	Time
Problemas com Procedure no PostgreSQL	Paulo (O2 Tecnologia)	11:38
Re: Problemas com Procedure no PostgreSQL	Hélder M. Vieira	12:27
Re: Problemas com Procedure no PostgreSQL	Hélder M. Vieira	13:53
Re: Problemas com Procedure no PostgreSQL	Paulo (O2 Tecnologia)	15:08
Re: Problemas com Procedure no PostgreSQL	Paulo (O2 Tecnologia)	15:13
Re: How to count from a second table in an aggregate query?	Steve Midgley	18:36

April 20, 2009

Thread	Author	Time
Frequently unable connecting to db "server doesn't listen"	Net Tree Inc.	02:10
Re: Frequently unable connecting to db "server doesn't listen"	Scott Marlowe	03:20
Re: Re: [GENERAL] Frequently unable connecting to db "server doesn't listen"	Rohit Suman	06:31
Re: Frequently unable connecting to db "server doesn't listen"	Alban Hertroys	08:53

April 21, 2009

Thread	Author	Time
trigger before delete question	Sigrid Thijs	12:03
Re: trigger before delete question	Tom Lane	14:13

April 23, 2009

Thread	Author	Time
Re[3]: Need a script that bakes INSERT script from SELECT results	ShuA	08:34
[No subject]	Adam Ruth	22:51

April 24, 2009

Thread	Author	Time
varchar value comparisons not working?	Shawn Tayler	13:59
Re: varchar value comparisons not working?	Tom Lane	14:32

April 25, 2009

Thread	Author	Time
Variable number or arguments to a function possible?	Chris Ruprecht	02:04
Re: Variable number or arguments to a function possible?	Milen A. Radev	03:08
Re: Variable number or arguments to a function possible?	Tom Lane	03:09
Multiple return values and assignment	Leif B. Kristensen	11:06

April 27, 2009

Thread	Author	Time
Query with Parameters and Wildcards	landsharkdaddy	00:21
Re: Query with Parameters and Wildcards	Ries van Twisk	02:12
Re: Query with Parameters and Wildcards	Scott Marlowe	04:54
Re: Query with Parameters and Wildcards	landsharkdaddy	05:01
Re: Multiple return values and assignment	Jasen Betts	08:48
Re: varchar value comparisons not working?	Jasen Betts	08:53
Re: Query with Parameters and Wildcards	Mario Splivalo	11:40
Re: Query with Parameters and Wildcards	landsharkdaddy	14:19
Re: Query with Parameters and Wildcards	dayat	14:47
Re: Query with Parameters and Wildcards	Jure Kobal	16:29
Re: Query with Parameters and Wildcards	landsharkdaddy	17:11
Storing null bytes in bytea	Andy Shellam	17:49
Re: Query with Parameters and Wildcards	Jure Kobal	19:11
Re: Multiple return values and assignment	Leif B. Kristensen	19:37
Re: Storing null bytes in bytea	Tom Lane	20:29

April 28, 2009

Thread	Author	Time
pg_stat_activity return all connections	Emi Lu	15:43
Re: Storing null bytes in bytea	Andy Shellam	16:48
Re: pg_stat_activity return all connections	Erik Jones	20:35

April 29, 2009

Thread	Author	Time
Comparing two tables of different database	Nicholas I	06:39
Re: Comparing two tables of different database	Pavel Stehule	12:15
Re: Comparing two tables of different database	Pawel Socha	12:33
Re: Comparing two tables of different database	Osvaldo Kussama	12:48
Re: Comparing two tables of different database	Thomas Kellerer	13:12
freeing memory after fetch all	Chris Bovitz	22:18
Re: Comparing two tables of different database	Adam Ruth	22:20

April 30, 2009

Thread	Author	Time
Re: Comparing two tables of different database	Joshua Tolley	03:37
Re: Comparing two tables of different database	Nicholas I	10:12
Re: Comparing two tables of different database	Jasen Betts	12:05
Re: Comparing two tables of different database	Jasen Betts	12:08
Re: Comparing two tables of different database	Edward W. Rouse	22:07

May 1, 2009

Thread	Author	Time
Re: Comparing two tables of different database	John Zhang	15:55
Re: Comparing two tables of different database	Wei Weng	16:31

May 2, 2009

Thread	Author	Time
Re: Comparing two tables of different database	M.P.Dankoor	10:16
Re: Comparing two tables of different database	Lucas Brito	15:01
using a list to query	johnf	16:55
Fwd: Comparing two tables of different database	Isaac Dover	18:52
Re: Comparing two tables of different database	Lucas Brito	21:25

May 3, 2009

Thread	Author	Time
Re: using a list to query	Craig Ringer	01:34
Re: Comparing two tables of different database	Isaac Dover	03:47
Creating a RULE for UPDATing a VIEW	Dean Gibson (DB Administrator)	16:50
Re: Creating a RULE for UPDATing a VIEW	Tom Lane	17:36
Re: using a list to query	johnf	22:26

May 7, 2009

Thread	Author	Time
Distinct oddity	Maximilian Tyrtania	08:21
ask about epoch query with datetime	haries fajar nugroho	08:24
Re: ask about epoch query with datetime	Ian Barwick	08:47
select regexp_matches('a a a', '([a-z]) a','g');	Marc Mamin	14:51
Re: Distinct oddity	Scott Marlowe	18:54

May 8, 2009

Thread	Author	Time
select regexp_matches('a a a', '([a-z]) a','g');	Craig Ringer	05:26
RAISE NOTICE	Luigi N. Puleio	09:05
Re: Distinct oddity	Maximilian Tyrtania	09:28
backup and restore	Jyoti Seth	09:31
Re: backup and restore	Craig Ringer	10:28
Re: backup and restore	Craig Ringer	10:38
Re: RAISE NOTICE	Gerardo Herzig	11:34
Re: Distinct oddity	Scott Marlowe	11:35
Re: RAISE NOTICE	Luigi N. Puleio	11:38
Re: backup and restore	Gerardo Herzig	11:44
Re: RAISE NOTICE	Milen A. Radev	11:52
Re: RAISE NOTICE	Luigi N. Puleio	12:01
Re: RAISE NOTICE	Gerardo Herzig	13:40
Re: Distinct oddity	Rob Sargent	14:55
performance question	Oliveiros Cristina	15:36
ascii-betical sort order?	Peter Koczan	17:26
Re: performance question	Tom Lane	17:55
Re: ascii-betical sort order?	Tom Lane	17:57
Re: ascii-betical sort order?	Peter Koczan	19:08
Re: Distinct oddity	Tom Lane	19:52
view vs. tables used to define that view	Emi Lu	21:05

May 9, 2009

Thread	Author	Time
Re: Distinct oddity	Maximilian Tyrtania	07:22
Re: backup and restore	Jasen Betts	11:05
Re: Distinct oddity	Tom Lane	14:33
Re: Distinct oddity	Glenn Maynard	19:15

May 10, 2009

Thread	Author	Time
Re: Distinct oddity	Alvaro Herrera	02:58
Re: RAISE NOTICE	Jasen Betts	10:57

May 11, 2009

Thread	Author	Time
Re: RAISE NOTICE	Luigi N. Puleio	06:02
Re: Distinct oddity	Maximilian Tyrtania	06:28
Re: RAISE NOTICE	Jasen Betts	08:49
Re: Distinct oddity	Alvaro Herrera	14:38
Query planning question	John Lister	14:43
Re: Query planning question	Tom Lane	15:06
Re: Query planning question	John Lister	15:21

May 12, 2009

Thread	Author	Time
Array: comparing first N elements?	David Garamond	08:05
Re: Array: comparing first N elements?	Pavel Stehule	08:28
Re: Array: comparing first N elements?	Glenn Maynard	08:37
Re: Array: comparing first N elements?	Achilleas Mantzios	08:38
Re: Array: comparing first N elements?	David Garamond	08:40
Re: Array: comparing first N elements?	David Garamond	08:42
Re: Distinct oddity	Maximilian Tyrtania	16:39
Re: Distinct oddity	Alvaro Herrera	17:23
Re: Distinct oddity	Maximilian Tyrtania	18:29

May 13, 2009

Thread	Author	Time
Re: Distinct oddity	Maximilian Tyrtania	12:37
Re: Distinct oddity	Tom Lane	14:47
Re: Distinct oddity	Tom Lane	15:47
Re: Distinct oddity	Glenn Maynard	18:48
Re: Distinct oddity	Tom Lane	19:03

May 14, 2009

Thread	Author	Time
update from join	Gary Stainburn	13:27
How to dump views definition in one schema?	Emi Lu	14:37
Re: update from join	Rob Sargent	15:44
Re: alter column from varchar(32) to varchar(255) without view re-creation	Emi Lu	18:33

May 18, 2009

Thread	Author	Time
Extrapolating performance expectation	Rob Sargent	04:04
Extracting data from arrays	Dani Castaños	10:45
SUM Array values query	Dani Castaños	10:49
Re: Extracting data from arrays	Pavel Stehule	11:10
Re: proposal for a CookBook in postgresql.org	Dave Page	11:57
Re: Extracting data from arrays	Harald Fuchs	12:16
proposal for a CookBook in postgresql.org	Gerardo Herzig	12:29
Re: proposal for a CookBook in postgresql.org	Pavel Stehule	12:34
Re: proposal for a CookBook in postgresql.org	Gerardo Herzig	13:04
Re: Extracting data from arrays	Dani Castaños	13:25
Re: SUM Array values query	Pawel Socha	13:31
Extract week from date	Dani Castaños	14:41
Re: Extract week from date	Filip Rembiałkowski	14:54
Re: Extract week from date	Dani Castaños	15:19
Re: Extrapolating performance expectation	Rob Sargent	15:22
Re: proposal for a CookBook in postgresql.org	Alvaro Herrera	16:25
Re: proposal for a CookBook in postgresql.org	Pavel Stehule	16:29
Re: proposal for a CookBook in postgresql.org	Alvaro Herrera	18:53

May 22, 2009

Thread	Author	Time
Make the planner smarter about idiosyncratic (or broken) ORM behaviour	Frank Jördens	09:33
Re: Make the planner smarter about idiosyncratic (or broken) ORM behaviour	Richard Huxton	09:56
Re: Make the planner smarter about idiosyncratic (or broken) ORM behaviour	Richard Huxton	10:33
Re: Make the planner smarter about idiosyncratic (or broken) ORM behaviour	Simon Riggs	10:40
Re: help with pg_hba.conf	Isaac Dover	13:03
Need help combining 2 tables together	Richard Ekblom	13:48
Re: Need help combining 2 tables together	Adrian Klaver	14:17
Re: Need help combining 2 tables together	James Kitambara	14:47
Allow column type to change without worrying about view dependencies	Emi Lu	14:55
Re: Need help combining 2 tables together	Oliveiros Cristina	15:31
Re: Need help combining 2 tables together	Rob Sargent	15:39

Browse Archives

Prev | Next