pgsql-sql since 2008-12-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

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

Feb. 1, 2009

Thread Author Time
Re: dynamic OUT parameters? gherzig 01:13
Re: dynamic OUT parameters? Craig Ringer 03:42
Re: dynamic OUT parameters? Ivan Sergio Borgonovo 09:54
Re: dynamic OUT parameters? Pavel Stehule 11:31

Feb. 2, 2009

Thread Author Time
Re: regexp_replace and UTF8 Bart Degryse 08:38

Feb. 3, 2009

Thread Author Time
Function Returning a Set of Composite Value Nikhil teltia 00:06

Feb. 4, 2009

Thread Author Time
Re: regexp_replace and UTF8 Jasen Betts 09:59
postgre2postgre F. 21:57
Re: postgre2postgre Devrim GÜNDÜZ 22:41
Re: postgre2postgre Chris 22:42

Feb. 5, 2009

Thread Author Time
current_date vs 'now' Jamie Tufnell 06:05
Re: current_date vs 'now' Tom Lane 15:34
Must I use DISTINCT? Michael B Allen 21:57
Re: current_date vs 'now' Jamie Tufnell 23:21

Feb. 6, 2009

Thread Author Time
Re: Array iterator Raj Mathur 03:34
Re: Must I use DISTINCT? Rajesh Kumar Mallah 03:59
Re: Must I use DISTINCT? Michael B Allen 04:54
test Boycott TechForums 05:01
Re: Must I use DISTINCT? Stephan Szabo 06:11
Re: Must I use DISTINCT? Raj Mathur 06:21
Data length and data precision Bart van Houdt 09:41
Re: Data length and data precision A. Kretschmer 10:04
Re: Data length and data precision Bart van Houdt 10:13
test Boycott TechForums 10:41
count(distinct) Zdravko Balorda 14:03
Re: count(distinct) Richard Huxton 14:35

Feb. 7, 2009

Thread Author Time
Re: Implementing "access lists" (was: Must I use DISTINCT?) Michael B Allen 01:32

Feb. 8, 2009

Thread Author Time
Grass Root Protectionism Boycott Tech Forums 06:40
Re: Grass Root Protectionism Scott Marlowe 06:50
Re: Grass Root Protectionism Scott Marlowe 06:50
Re: Grass Root Protectionism Bruce Momjian 13:49
Re: Grass Root Protectionism D'Arcy J.M. Cain 14:06
Re: Grass Root Protectionism Tom Lane 15:39
Re: Grass Root Protectionism D'Arcy J.M. Cain 15:50
Re: Grass Root Protectionism Michael B Allen 16:11
Re: Grass Root Protectionism John Hasler 17:20
Re: Grass Root Protectionism John Hasler 18:24

Feb. 9, 2009

Thread Author Time
Re: Grass Root Protectionism Oliveiros Cristina 11:24
RE: [SQL] Grass Root Protectionism Bart van Houdt 12:02

Feb. 11, 2009

Thread Author Time
Partitoning not working with RETURNING and INSERT/UPDATE Frank Jördens 03:55

Feb. 12, 2009

Thread Author Time
Funtion to clean up strings? Andreas 23:20

Feb. 13, 2009

Thread Author Time
Re: Funtion to clean up strings? Dickson S. Guedes 00:00
Re: Funtion to clean up strings? Andreas 00:15
Re: Funtion to clean up strings? Raj Mathur 04:27
Re: Grass Root Protectionism Tovo Rabemanantsoa 13:18

Feb. 15, 2009

Thread Author Time
= or LIKE ? Jesper Krogh 17:57
Re: = or LIKE ? Tom Lane 18:42
Re: = or LIKE ? Jesper Krogh 19:20
Re: = or LIKE ? Jesper Krogh 19:27
Re: = or LIKE ? Tom Lane 19:34

Feb. 16, 2009

Thread Author Time
Re: = or LIKE ? Craig Ringer 04:40

Browse Archives

Prev | Next