pgsql-sql - December 2008

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

Dec. 1, 2008

Thread	Author	Time
Re: JOIN results of refcursor functions	Alvaro Herrera	02:08
how to update 400 000 register not at the same time?	John Dizaro	16:25
Re: wired behaviour	Steve Crawford	17:18
Reg: Nested query	Vignesh Raaj	18:39
Re: [HACKERS] Reg: Nested query	Alvaro Herrera	19:38
Re: [pgsql-www] Reg: Nested query	Raymond O'Donnell	22:33
Re: JOIN results of refcursor functions	Milan Oparnica	23:52

Dec. 2, 2008

Thread	Author	Time
DIVISION with Group By	hdhgdh mjhff	02:57
Re: JOIN results of refcursor functions	Pavel Stehule	05:58
Re: how to update 400 000 register not at the same time?	Shane Ambler	16:30
Re: JOIN results of refcursor functions	Milan Oparnica	23:10

Dec. 4, 2008

Thread	Author	Time
constraint question (I think)	Gary Stainburn	10:01
array index access outside range	Achilleas Mantzios	15:02
Re: Trigger/Function - one solution - was constraint question (I think)	Gary Stainburn	17:59
Aggregates with NaN values	Sean Davis	18:01
Re: Trigger/Function - one solution - was constraint question (I think)	Rafael Domiciano	19:59

Dec. 5, 2008

Thread	Author	Time
Re: Aggregates with NaN values	Mark Roberts	18:51
Best way to "and" from a one-to-many joined table? 📎	Bryce Nesbitt	18:55
Re: Aggregates with NaN values	Sean Davis	19:08
Re: Best way to "and" from a one-to-many joined table?	Oliveiros Cristina	19:23
Re: Best way to "and" from a one-to-many joined table?	Milan Oparnica	20:16
Re: Best way to "and" from a one-to-many joined table? 📎	Bryce Nesbitt	20:52
Re: Best way to "and" from a one-to-many joined table?	Oliveiros Cristina	22:38

Dec. 6, 2008

Thread	Author	Time
adding "order by" to a "group by" query	Louis-David Mitterrand	17:10
Re: adding "order by" to a "group by" query	Andreas Kretschmer	17:26
Re: adding "order by" to a "group by" query	Louis-David Mitterrand	17:31
Re: adding "order by" to a "group by" query	Scott Marlowe	17:40
Re: adding "order by" to a "group by" query	Andreas Kretschmer	18:23
Re: adding "order by" to a "group by" query	John Lister	18:24
Re: adding "order by" to a "group by" query	Louis-David Mitterrand	18:36
Public synonyms	Azzeddine Daddah	22:22
Re: Public synonyms	Bruce Momjian	22:31

Dec. 8, 2008

Thread	Author	Time
Re: Best way to "and" from a one-to-many joined table?	Steve Midgley	02:27
Re: Best way to "and" from a one-to-many joined table?	John Lister	08:51
Best way to restrict detail rows?	Christopher Maier	20:56
Re: Best way to restrict detail rows?	Scott Marlowe	21:28
Re: Best way to restrict detail rows?	Scott Marlowe	21:29
Re: Best way to restrict detail rows?	Richard Broersma	21:31
Re: Best way to restrict detail rows?	Scott Marlowe	21:34

Dec. 9, 2008

Thread	Author	Time
A DISTINCT problem removing duplicates 📎	Richard Huxton	09:46
store pdf files	ivan marchesini	10:11
Re: DIVISION with Group By	Richard Huxton	11:08
Re: A DISTINCT problem removing duplicates	Tom Lane	13:50
Re: A DISTINCT problem removing duplicates	Richard Huxton	15:04
Re: A DISTINCT problem removing duplicates	Tom Lane	15:39
Re: A DISTINCT problem removing duplicates	Richard Huxton	16:12
inconsistent automatic casting between psql and function	Stefano Buliani	17:28
Re: store pdf files	Frank Bax	17:57
Re: inconsistent automatic casting between psql and function	Richard Huxton	18:02
Re: store pdf files	Thomas Kellerer	18:05
Re: store pdf files	Andreas Joseph Krogh	18:18
Re: inconsistent automatic casting between psql and function	Richard Huxton	18:33
Re: inconsistent automatic casting between psql and function	Tom Lane	18:37

Dec. 10, 2008

Thread	Author	Time
unique constraint on views	Jyoti Seth	12:05
Re: unique constraint on views	A. Kretschmer	12:33
Collapsing (select) row values into single text field.	Allan Kamau	12:46
Re: inconsistent automatic casting between psql and function	Bruce Momjian	13:33
Is there a bug in PostgreSQL ?	Pascal Tufenkji	14:33
Re: Collapsing (select) row values into single text field.	Filip Rembiałkowski	14:45
Re: Is there a bug in PostgreSQL ?	Tom Lane	17:43
Re: Is there a bug in PostgreSQL ?	Richard Huxton	17:45
Re: Best way to "and" from a one-to-many joined table?	Bryce Nesbitt	18:54
Re: Best way to "and" from a one-to-many joined table?	Oliveiros Cristina	19:21
Is it possible to only allow deletes from a table via referential integrity cascades?	Christopher Maier	19:55

Dec. 11, 2008

Thread	Author	Time
Re: Collapsing (select) row values into single text field.	Allan Kamau	03:52
Re: unique constraint on views	Jyoti Seth	04:04
Re: Is there a bug in PostgreSQL ?	Pascal Tufenkji	09:33
Re: Is there a bug in PostgreSQL ?	Pascal Tufenkji	09:57
Re: Is there a bug in PostgreSQL ?	Tom Lane	14:40

Dec. 13, 2008

Thread	Author	Time
array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Corey Horton	05:03
Re: Is there a bug in PostgreSQL ?	Pascal Tufenkji	07:33

Dec. 14, 2008

Thread	Author	Time
Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Tom Lane	00:38
Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Greg Stark	00:52
Re: array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Tom Lane	01:10
Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Tom Lane	18:16
optimizing a query	Louis-David Mitterrand	19:22
Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Corey Horton	19:26
Re: Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Tom Lane	19:58

Dec. 15, 2008

Thread	Author	Time
Re: Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3	Corey Horton	00:39
Re: optimizing a query	Louis-David Mitterrand	06:51
"Subquery must return only one column" & query optimization	Philippe Lang	12:12
Re: "Subquery must return only one column" & query optimization	Tom Lane	13:17
Re: "Subquery must return only one column" & query optimization	Philippe Lang	14:21
create table with rownames as values in column of seciond table 📎	Marco Lechner	21:42

Dec. 16, 2008

Thread	Author	Time
Re: create table with rownames as values in column of seciond table	George Pavlov	00:06
How can this be legal syntax	Asko Oja	17:00
Re: How can this be legal syntax	Alvaro Herrera	17:05
Re: How can this be legal syntax	Tom Lane	17:16
pg_clog/0202 Error	Judith Altamirano	17:54
Way to eliminate pg_dump activity from pg_stat_all ? 📎	Bryce Nesbitt	20:55

Dec. 17, 2008

Thread	Author	Time
Re: Way to eliminate pg_dump activity from pg_stat_all ?	Erik Jones	00:33
Re: pg_clog/0202 Error	Tom Lane	00:38
archiving or versioning data?	Louis-David Mitterrand	06:51
Re: archiving or versioning data?	A. Kretschmer	07:12
Re: How can this be legal syntax	Jaime Casanova	20:06

Dec. 18, 2008

Thread	Author	Time
How to insert Images(bnp, png, etc) into Postgresql and how to retrive the inserted Imaged using C#.net	venkat	14:16
Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net	Milen A. Radev	14:32
Re: Re: How to insert Images(bnp, png, etc) into Postgresql and how to retrive the inserted Imaged using C#.net	venkat	14:44
Re: Re: How to insert Images(bnp,png,etc) into Postgresql and how to retrive the inserted Imaged using C#.net	Steve Crawford	16:15

Dec. 19, 2008

Thread	Author	Time
index compatible date_trunc in postgres?	Bryce Nesbitt	05:46
Re: index compatible date_trunc in postgres?	Scott Marlowe	05:52
Downgrade database and problem with sequences	Sebastian Rychter	13:03
Re: index compatible date_trunc in postgres?	Alvaro Herrera	13:06
Re: index compatible date_trunc in postgres?	Tom Lane	13:32
Re: Downgrade database and problem with sequences	Tom Lane	14:03
Re: index compatible date_trunc in postgres?	Bryce Nesbitt	18:15
Invitation to connect on LinkedIn	Mahmoud Ewiwi	20:42

Dec. 22, 2008

Thread	Author	Time
Problem inserting image 📎	Tk421	20:08
Re: Problem inserting image	Richard Broersma	20:33

Dec. 24, 2008

Thread	Author	Time
How to Import Excel Into PostgreSQL database	Venkat Rao Tammineni	07:06
Re: How to Import Excel Into PostgreSQL database	A. Kretschmer	09:23
Re: How to Import Excel Into PostgreSQL database	Venkat Rao Tammineni	09:31
Re: How to Import Excel Into PostgreSQL database 📎	Tk421	10:13
How much the max image size can be inserted into Postgresql	venkat	14:00
Re: How much the max image size can be inserted into Postgresql	Craig Ringer	15:38
Re: How much the max image size can be inserted into Postgresql	Scott Marlowe	16:54

Dec. 25, 2008

Thread	Author	Time
How to improve PgSql Performance using npgsql	Venkat Rao Tammineni	06:39
Re: How to improve PgSql Performance using npgsql	Hilco Wijbenga	07:54
SQL syntax I've been unable to figure out.... 📎	Karl Denninger	19:35
Re: SQL syntax I've been unable to figure out....	Rodrigo E. De León Plicet	21:04

Dec. 29, 2008

Thread	Author	Time
where-used function	Kevin Duffy	17:52
Object create date	Fernando Hevia	18:23
Re: Object create date	Scott Marlowe	18:37
Re: Object create date	Alvaro Herrera	18:38
Re: where-used function	Tom Lane	18:44
Re: Object create date	George Pavlov	20:30
Re: Object create date	Fernando Hevia	21:20
Re: Object create date	Fernando Hevia	21:20
Re: Object create date	Alvaro Herrera	21:39
Copy question	Judith Altamirano	22:28
Re: Copy question	Guillaume Lelarge	22:35

Dec. 30, 2008

Thread	Author	Time
Re: Object create date	Fernando Hevia	12:36
Re: Object create date	Erik Jones	17:33

Dec. 31, 2008

Thread	Author	Time
Re: Object create date	Asko Oja	12:34
Question on Escape-string	John Zhang	19:15

Browse Archives

Prev | Next