pgsql-sql since 2009-04-25 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 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
Re: help with pg_hba.conf Tom Lane 16:31
Re: help with pg_hba.conf Isaac Dover 17:39
Re: help with pg_hba.conf Tom Lane 18:34
left join where not null vs. inner join Emi Lu 20:51
Re: left join where not null vs. inner join Erik Jones 21:05

May 25, 2009

Thread Author Time
Obtaining a limited number of records from a long query Oliveiros Cristina 13:32
Re: Obtaining a limited number of records from a long query Luiz Eduardo Cantanhede Neri 13:42
Re: Obtaining a limited number of records from a long query Andy Shellam 13:45
Re: Obtaining a limited number of records from a long query Oliveiros Cristina 13:55
Re: Obtaining a limited number of records from a long query Ivan Sergio Borgonovo 14:13
Re: Obtaining a limited number of records from a long query Daniel Staal 14:15
Re: Obtaining a limited number of records from a long query Oliveiros Cristina 14:20
Re: Obtaining a limited number of records from a long query Ivan Sergio Borgonovo 14:56
Pgadmin hotkeys? John Dizaro 16:21

May 26, 2009

Thread Author Time
Re: Allow column type to change without worrying about view dependencies Emi Lu 15:48

May 28, 2009

Thread Author Time
exists and is not null equivalence in query Raphael Bauduin 12:36
Re: exists and is not null equivalence in query Tom Lane 15:19

June 1, 2009

Thread Author Time
Assigning data-entry tasks to multiple concurrent clients Jamie Tufnell 03:54
Re: Assigning data-entry tasks to multiple concurrent clients Jamie Tufnell 04:49
Re: Assigning data-entry tasks to multiple concurrent clients Jamie Tufnell 05:02
Re: Assigning data-entry tasks to multiple concurrent clients Jasen Betts 08:55
Re: Assigning data-entry tasks to multiple concurrent clients Scott Marlowe 09:55
Avoiding "will create implicit index" NOTICE Bryce Nesbitt 19:32
Re: Avoiding "will create implicit index" NOTICE Scott Marlowe 20:07

June 2, 2009

Thread Author Time
Re: [SQL] proposal for a CookBook in postgresql.org Bruce Momjian 20:28
Re: [SQL] proposal for a CookBook in postgresql.org Alvaro Herrera 20:48
Re: [SQL] proposal for a CookBook in postgresql.org Bruce Momjian 20:52
Re: [SQL] proposal for a CookBook in postgresql.org Alvaro Herrera 21:10
complex column definition in query Seb 22:16

June 3, 2009

Thread Author Time
Re: [SQL] proposal for a CookBook in postgresql.org Bruce Momjian 00:56
Re: complex column definition in query A. Kretschmer 05:04
Creation of file from postgresql function Jyoti Seth 12:00
Re: Creation of file from postgresql function A. Kretschmer 12:13
Re: complex column definition in query Seb 12:53
Re: complex column definition in query A. Kretschmer 13:23

June 4, 2009

Thread Author Time
page-base stats per query? Rob Sargent 20:14

June 5, 2009

Thread Author Time
Type inheritance Gianvito Pio 10:30
Re: Type inheritance Tom Lane 13:48
do unneeded outer joins cost? chester c young 15:01
Re: Type inheritance Gianvito Pio 15:13
Re: do unneeded outer joins cost? Tom Lane 15:25
Re: Type inheritance Rob Sargent 16:38

June 6, 2009

Thread Author Time
Re: Type inheritance Gianvito Pio 07:10
Re: Type inheritance Jasen Betts 12:04
Re: Type inheritance Gianvito Pio 14:18
Re: Type inheritance Richard Broersma 14:30
Re: Type inheritance Rob Sargent 15:11
Xml Schemas Isaac Dover 19:53

June 8, 2009

Thread Author Time
'cost' and 'rows' for volitile function Rob Sargent 16:26
Re: [SQL] 'cost' and 'rows' for volitile function Richard Huxton 17:16
Re: 'cost' and 'rows' for volitile function Richard Huxton 17:34
Re: 'cost' and 'rows' for volitile function Richard Huxton 17:57
Re: Xml Schemas Peter Eisentraut 20:53

June 9, 2009

Thread Author Time
pg_restore Jyoti Seth 09:32
backup Jyoti Seth 09:53
Re: backup Ashish Karalkar 10:02
Re: backup Jasen Betts 12:33
Taking the cache out of the equation? Rob Sargent 17:51

June 10, 2009

Thread Author Time
Re: backup Jyoti Seth 05:08
Re: backup Jyoti Seth 05:46
Re: backup Gurjeet Singh 05:50
Re: backup Abbas 06:02
setting the where clause johnf 12:19
Re: setting the where clause Tom Lane 14:19
Re: setting the where clause Rob Sargent 15:13

June 11, 2009

Thread Author Time
Re: Avoiding "will create implicit index" NOTICE Bryce Nesbitt 06:20
Re: Avoiding "will create implicit index" NOTICE Bryce Nesbitt 07:03
Re: Avoiding "will create implicit index" NOTICE A. Kretschmer 07:31

Browse Archives

Prev | Next