pgsql-sql before 2009-02-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

Nov. 27, 2008

Thread Author Time
Re: JOIN results of refcursor functions Milan Oparnica 20:27
Re: JOIN results of refcursor functions Alvaro Herrera 20:45

Nov. 28, 2008

Thread Author Time
Re: UPDATE and DELEte with a lot of register is to slow... John Dizaro 10:37
wired behaviour Lutz Steinborn 13:51
Re: wired behaviour Paul Dam 14:10
Re: wired behaviour ries van Twisk 14:11
Re: wired behaviour Lutz Steinborn 14:22
Re: wired behaviour Ragnar Hafstað 14:54
Re: wired behaviour Shane Ambler 15:09
Re: wired behaviour Lennin Caro 15:22
Re: Converting between UUID and VARCHAR Helio Campos Mello de Andrade 22:27

Nov. 30, 2008

Thread Author Time
Re: JOIN results of refcursor functions Milan Oparnica 23:13

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

Jan. 3, 2009

Thread Author Time
Re: Question on Escape-string Steve Midgley 17:48

Jan. 4, 2009

Thread Author Time
How to excute dynamically a generated SQL command? John Zhang 01:57
EXECUTE with a prepared plan and NULL sergey kapustin 20:53
Re: How to excute dynamically a generated SQL command? Adrian Klaver 21:04
Re: EXECUTE with a prepared plan and NULL Tom Lane 23:04

Jan. 5, 2009

Thread Author Time
Re: Any utility to convert MySQL to PGSQL? Chris Browne 17:06
Re: How to excute dynamically a generated SQL command? Steve Midgley 17:57

Jan. 6, 2009

Thread Author Time
Convite pessoal de Flavio Brito Flavio Brito 12:08

Jan. 11, 2009

Thread Author Time
some howto/theory book/tutorial on practical problem solving in SQL Ivan Sergio Borgonovo 16:32
Re: some howto/theory book/tutorial on practical problem solving in SQL Scott Marlowe 18:19
Seeking for the fore-part of the key Havasvölgyi Ottó 20:50
Re: Seeking for the fore-part of the key Andreas Kretschmer 21:17

Jan. 12, 2009

Thread Author Time
Re: some howto/theory book/tutorial on practical problem solving in SQL Ivan Sergio Borgonovo 00:48

Jan. 13, 2009

Thread Author Time
Create index on xml field Brad Balmer 16:56
Re: Create index on xml field Peter Eisentraut 19:42

Jan. 14, 2009

Thread Author Time
Re: some howto/theory book/tutorial on practical problem solving in SQL Erik Jones 06:18
Re: some howto/theory book/tutorial on practical problem solving in SQL Ivan Sergio Borgonovo 11:05
Re: some howto/theory book/tutorial on practical problem solving in SQL Steve Midgley 18:51

Jan. 16, 2009

Thread Author Time
Derived columns / denormalization Jamie Tufnell 03:52
Re: Derived columns / denormalization Tom Lane 04:06
Re: Derived columns / denormalization Erik Jones 16:42

Jan. 19, 2009

Thread Author Time
Re: Derived columns / denormalization Jamie Tufnell 00:33

Jan. 20, 2009

Thread Author Time
Re: Way to eliminate pg_dump activity from pg_stat_all ? Bryce Nesbitt 19:27
Re: Way to eliminate pg_dump activity from pg_stat_all ? Erik Jones 22:06
Re: Way to eliminate pg_dump activity from pg_stat_all ? Bryce Nesbitt 22:25

Jan. 21, 2009

Thread Author Time
Re: [SQL] array_to_string(anyarray, text) that was working in 8.1 is not working in 8.3 Bruce Momjian 17:52

Jan. 23, 2009

Thread Author Time
problem using twice custom comparision operator Marek Florianczyk 20:42
Re: problem using twice custom comparision operator Tom Lane 22:40

Jan. 25, 2009

Thread Author Time
Re: problem using twice custom comparision operator Steve Midgley 18:41

Jan. 26, 2009

Thread Author Time
Invitation to connect on LinkedIn Suha Onay 07:57
aggregation problem: first/last/count(*) Marc Mamin 14:48
Re: aggregation problem: first/last/count(*) Volkan YAZICI 15:27
Re: aggregation problem: first/last/count(*) Marc Mamin 16:04

Jan. 27, 2009

Thread Author Time
Array iterator Raj Mathur 12:40
Re: Array iterator Achilleas Mantzios 13:34

Jan. 28, 2009

Thread Author Time
plpgsql setof help Matthew T. O'Connor 23:37

Jan. 29, 2009

Thread Author Time
Re: plpgsql setof help Tom Lane 00:29
Re: plpgsql setof help Frank Bax 00:49
I need some magical advice Andreas 11:56
Re: I need some magical advice Oliveiros Cristina 13:58
Re: I need some magical advice Andreas 14:17
Re: I need some magical advice M.P.Dankoor 14:52
Re: I need some magical advice Oliveiros Cristina 15:04
Re: I need some magical advice Terry Fielder 15:16

Jan. 30, 2009

Thread Author Time
regexp_replace and UTF8 Bart Degryse 10:26
dynamic OUT parameters? Gerardo Herzig 11:01
Re: regexp_replace and UTF8 Gregory Stark 11:14
Re: regexp_replace and UTF8 Harald Fuchs 15:47
Re: dynamic OUT parameters? Craig Ringer 17:00
Re: dynamic OUT parameters? Tom Lane 17:08

Jan. 31, 2009

Thread Author Time
Re: dynamic OUT parameters? gherzig 00:52
Re: dynamic OUT parameters? Craig Ringer 06:18
Re: regexp_replace and UTF8 Jasen Betts 11:47

Browse Archives

Prev | Next