pgsql-sql since 2008-11-18 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. 18, 2008

Thread Author Time
custom serial number mahmoud ewiwi 09:09
Re: custom serial number A. Kretschmer 09:26
Re: custom serial number Pavel Stehule 09:37
Re: custom serial number A. Kretschmer 09:42
Re: custom serial number Pavel Stehule 09:45
Re: custom serial number Gerardo Herzig 18:17
Left Join Question Ryan Wells 22:48
Re: Left Join Question ries van Twisk 23:18
Re: Left Join Question Mark Roberts 23:22

Nov. 19, 2008

Thread Author Time
Re: Left Join Question Richard Huxton 07:45
Re: custom serial number A. Kretschmer 07:45
Re: custom serial number mahmoud ewiwi 08:52
Query to retrieve all indexed columns Bart van Houdt 12:11
Re: custom serial number A. Kretschmer 13:37
VACUUM cannot be executed from multi-command string Sabin Coanda 15:26
Re: Left Join Question Ryan Wells 15:30
Re: VACUUM cannot be executed from multi-command string Richard Huxton 18:05
Re: Query to retrieve all indexed columns Tom Lane 18:24

Nov. 20, 2008

Thread Author Time
date range query help novice 02:10
Re: date range query help Adam Rich 02:42
Re: date range query help novice 03:03
Re: date range query help brian 03:28
Re: date range query help novice 03:43
Re: [SQL] date range query help Rodrigo E. De León Plicet 04:17
Re: [SQL] [GENERAL] date range query help Frank Bax 04:19
Re: [SQL] date range query help novice 04:32
Re: [SQL] date range query help brian 04:33
Re: [SQL] date range query help novice 04:41
Re: [SQL] date range query help Adam Rich 04:42
Re: [SQL] date range query help Joshua D. Drake 05:04
Re: date range query help Raymond C. Rodgers 05:42
UPDATE and DELEte with a lot of register is to slow... John Dizaro 10:20
Re: UPDATE and DELEte with a lot of register is to slow... Craig Ringer 11:29
Re: date range query help Sam Mason 11:49
Re: [SQL] date range query help Frank Bax 13:22
Re: date range query help Tom Lane 16:20
Res: UPDATE and DELEte with a lot of register is to slow... paulo matadr 19:04

Nov. 21, 2008

Thread Author Time
Re: UPDATE and DELEte with a lot of register is to slow... John Dizaro 12:34
BULK COLLECT Paul Dam 13:20
function - string ends with Kevin Duffy 16:30
Re: BULK COLLECT Scott Marlowe 16:46
Re: function - string ends with Kevin Duffy 16:47
Re: function - string ends with Oliveiros Cristina 16:53
simple text parsing function Kevin Duffy 20:35

Nov. 22, 2008

Thread Author Time
Interval Format Zagato 01:34
JOIN results of refcursor functions Milan Oparnica 01:37
Re: Interval Format Tom Lane 02:15
Re: JOIN results of refcursor functions Tom Lane 02:16
Re: Interval Format Zagato 02:31
Re: simple text parsing function John DeSoi 15:48

Nov. 24, 2008

Thread Author Time
Permission denied for create table Pascal Tufenkji 06:50
Re: Permission denied for create table Marcin Stępnicki 07:17
Re: BULK COLLECT Paul Dam 08:32
Re: Permission denied for create table Richard Huxton 09:24
Re: Permission denied for create table Tom Lane 13:17
Sequence and nextval problem Tk421 19:12
Re: Sequence and nextval problem Scott Marlowe 19:20
Re: Sequence and nextval problem ries van Twisk 21:21

Nov. 25, 2008

Thread Author Time
Re: Sequence and nextval problem 📎 Craig Ringer 04:35
Re: Sequence and nextval problem Craig Ringer 04:44
Full text search ordering question John Lister 15:28
Re: Sequence and nextval problem Steve Midgley 16:07
Re: Full text search ordering question Oleg Bartunov 16:43
Re: Full text search ordering question John Lister 16:54
EXECUTE query INTO problem Tk421 20:58
Re: EXECUTE query INTO problem Andreas Kretschmer 21:16
Re: EXECUTE query INTO problem Pawel Socha 22:07

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

Browse Archives

Prev | Next