pgsql-sql since 2010-09-29 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

Sept. 29, 2010

Thread Author Time
Shema with template Thomas Andres 06:42
Re: identifying duplicates in table with redundancies Andreas Schmitz 08:40
Re: identifying duplicates in table with redundancies Tarlika Elisabeth Schmitz 11:41
Re: identifying duplicates in table with redundancies Oliveiros d'Azevedo Cristina 13:00
Re: Regexp matching Osvaldo Kussama 13:30

Sept. 30, 2010

Thread Author Time
Re: Question about PQexecParams Kenneth Marshall 17:12
Re: Question about PQexecParams Dmitriy Igrishin 18:30
Re: Question about PQexecParams Kenneth Marshall 19:14

Oct. 1, 2010

Thread Author Time
Re: Question about PQexecParams Dmitriy Igrishin 14:37
Random sort with distinct Ozer, Pam 20:51

Oct. 2, 2010

Thread Author Time
Re: Random sort with distinct Dmitriy Igrishin 13:40
Re: Random sort with distinct 📎 Lee Hachadoorian 13:42
Re: Random sort with distinct Tom Lane 13:52

Oct. 3, 2010

Thread Author Time
join returns too many results... Frank Bax 18:54
Need magic for inserting in 2 tables Andreas 22:14
Re: Need magic for inserting in 2 tables Scott Marlowe 23:46

Oct. 4, 2010

Thread Author Time
Re: Need magic for inserting in 2 tables Andreas 00:47
Re: Need magic for inserting in 2 tables Scott Marlowe 00:58
Re: Need magic for inserting in 2 tables Andreas 02:31
Re: Need magic for inserting in 2 tables Scott Marlowe 02:46
Re: join returns too many results... Joshua Tolley 13:24
Re: Random sort with distinct Ozer, Pam 15:40

Oct. 6, 2010

Thread Author Time
Create Datefield from 3 fields Andreas Forø Tollefsen 11:11
Re: Create Datefield from 3 fields Thomas Kellerer 11:36
Re: Create Datefield from 3 fields Andreas Forø Tollefsen 11:43

Oct. 8, 2010

Thread Author Time
Duplicates Processing Gary Chambers 15:12
Re: Duplicates Processing Tim Landscheidt 18:42
Re: Duplicates Processing Gary Chambers 19:42
Re: Duplicates Processing Rob Sargent 20:07
Re: Duplicates Processing Gary Chambers 20:42
Re: Duplicates Processing Rob Sargent 21:34
counting related rows James Cloos 22:02
Re: Duplicates Processing Gary Chambers 22:12
Re: counting related rows Frank Bax 23:09
Re: Duplicates Processing Rob Sargent 23:47

Oct. 9, 2010

Thread Author Time
Re: counting related rows James Cloos 07:49

Oct. 11, 2010

Thread Author Time
get attribute from XML Viktor Bojović 23:03

Oct. 12, 2010

Thread Author Time
Re: get attribute from XML Markus Schatten 00:22
Is there a conditional string-concatenation ? Andreas 04:09
Re: Is there a conditional string-concatenation ? Joshua Tolley 04:18
Re: Is there a conditional string-concatenation ? Osvaldo Kussama 05:03
Re: get attribute from XML Viktor Bojović 07:10
Re: Is there a conditional string-concatenation ? Pavel Stehule 09:01
Re: Duplicates Processing Gary Chambers 14:19
Re: Duplicates Processing Rob Sargent 15:14

Oct. 15, 2010

Thread Author Time
Re: counting related rows James Cloos 09:57

Oct. 16, 2010

Thread Author Time
How to collect text-fields from multiple rows ? Andreas 03:23
Re: How to collect text-fields from multiple rows ? Thomas Kellerer 07:23
SIMILAR TO Rommel the iCeMAn 14:26
Re: SIMILAR TO Tom Lane 14:30
Re: SIMILAR TO Rommel the iCeMAn 16:23

Oct. 18, 2010

Thread Author Time
insert into table from list or array ? Andreas 18:00
Re: insert into table from list or array ? Viktor Bojović 18:12
Re: insert into table from list or array ? Pavel Stehule 18:14
Re: insert into table from list or array ? Andreas 23:05

Oct. 21, 2010

Thread Author Time
Need help on update. Nicholas I 07:43
Re: Need help on update. Richard Huxton 08:10
Re: Need help on update. Nicholas I 08:19

Oct. 22, 2010

Thread Author Time
insert record in remote database Maruti Nandan 11:41

Oct. 23, 2010

Thread Author Time
Re: insert record in remote database Osvaldo Kussama 22:07

Oct. 24, 2010

Thread Author Time
Re: insert record in remote database Osvaldo Kussama 12:52

Oct. 25, 2010

Thread Author Time
How to search for a part of a number Andreas 00:48
Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause Axel Rau 10:14
Re: How to search for a part of a number Harald Fuchs 13:13
Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] Axel Rau 16:07
Re: Using PL/pgSQL text argument in 'IN (INT, INT, ...)' clause [re-post] Richard Broersma 16:17
Re: Using PL/pgSQL text argument in 'IN (INT, INT, ...)' clause [re-post] Sergey Konoplev 16:17
Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause [re-post] Axel Rau 19:01

Oct. 26, 2010

Thread Author Time
How to update multiple rows venkat 07:07
Re: How to update multiple rows Alban Hertroys 08:02
Re: How to update multiple rows venkat 09:14
Re: How to update multiple rows Dann Corbit 09:27

Oct. 27, 2010

Thread Author Time
Different plan for one query problem Tatarnikov Alexander 01:50

Oct. 29, 2010

Thread Author Time
How to Convert Integer to Serial venkat 04:48
Re: How to Convert Integer to Serial venkat 04:58
Re: [SQL] How to Convert Integer to Serial Shoaib Mir 05:00
Re: [SQL] How to Convert Integer to Serial Shoaib Mir 05:01
Re: [SQL] How to Convert Integer to Serial venkat 05:02
Re: How to Convert Integer to Serial John R Pierce 05:09
Re: [SQL] How to Convert Integer to Serial Shoaib Mir 05:10
Re: [SQL] How to Convert Integer to Serial venkat 05:29
Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause Dmitriy Igrishin 17:07
Re: Using PL/pgSQL text argument in 'IN (INT,INT,...)' clause Dmitriy Igrishin 17:11
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable Will Furnass 19:31

Oct. 30, 2010

Thread Author Time
large xml database Viktor Bojović 21:49
Re: large xml database Andreas Joseph Krogh 22:06
Re: large xml database Rob Sargent 22:42

Oct. 31, 2010

Thread Author Time
Re: large xml database James Cloos 00:26
Re: large xml database Lutz Steinborn 06:08
A more efficient way? James Cloos 06:59
Re: A more efficient way? Tom Lane 14:10
Re: large xml database Viktor Bojović 19:36
Re: large xml database Viktor Bojović 19:53
Re: large xml database Rob Sargent 20:42
Re: large xml database 📎 Viktor Bojović 21:16
Re: large xml database Rob Sargent 21:26
Re: large xml database 📎 Viktor Bojović 22:52
Re: large xml database Rob Sargent 23:07

Nov. 1, 2010

Thread Author Time
Sorting router interfaces Brian Sherwood 12:15
Re: Sorting router interfaces Filip Rembiałkowski 21:37

Nov. 2, 2010

Thread Author Time
Re: Sorting router interfaces Andreas 00:23
problem with rules Uwe Bartels 07:54

Nov. 4, 2010

Thread Author Time
I'm stuck - I just can't get this small FUNCT to run! Ralph Smith 00:00
Re: I'm stuck - I just can't get this small FUNCT to run! bricklen 00:09
Re: I'm stuck - I just can't get this small FUNCT to run! Tom Lane 03:50
Trailing spaces - is there an easier way? Dean Gibson (DB Administrator) 19:03
Re: Trailing spaces - is there an easier way? Pavel Stehule 19:42
Re: Trailing spaces - is there an easier way? Kenneth Marshall 19:47
Re: I'm stuck - I just can't get this small FUNCT to run! Ralph Smith 20:07

Nov. 7, 2010

Thread Author Time
Re: resolved: WITH RECURSIVE: ARRAY[id] All column datatypes must be hashable Will Furnass 10:18

Nov. 9, 2010

Thread Author Time
unexpected ORDER BY Andreas 16:00
Re: unexpected ORDER BY Tom Lane 16:10

Nov. 10, 2010

Thread Author Time
"slow lock" log in addition to log_min_duration_statement ? Bryce Nesbitt 20:28

Nov. 11, 2010

Thread Author Time
Overlapping Ranges- Query Alternative Ozer, Pam 19:07

Nov. 12, 2010

Thread Author Time
Re: Overlapping Ranges- Query Alternative Andreas Gaab 08:23
Re: Overlapping Ranges- Query Alternative Marc Mamin 08:57
Re: "slow lock" log in addition to log_min_duration_statement ? Joshua Tolley 15:50
Re: Overlapping Ranges- Query Alternative Ozer, Pam 16:36
psql -f COPY from STDIN Tarlika Elisabeth Schmitz 22:03
Re: psql -f COPY from STDIN Adrian Klaver 23:17

Nov. 13, 2010

Thread Author Time
Re: psql -f COPY from STDIN Tom Lane 03:22
Re: psql -f COPY from STDIN Tarlika Elisabeth Schmitz 12:01
Re: psql -f COPY from STDIN Tom Lane 14:54
Re: psql -f COPY from STDIN Tarlika Elisabeth Schmitz 15:04
Need help with plpgsql function. berelith 23:48

Nov. 14, 2010

Thread Author Time
Re: Need help with plpgsql function. Pavel Stehule 07:15
Re: Need help with plpgsql function. Adrian Klaver 18:37
Re: Need help with plpgsql function. Pavel Stehule 18:41

Nov. 16, 2010

Thread Author Time
multi table import from 1 denormalized source table Andreas 05:57
Re: multi table import from 1 denormalized source table Jasen Betts 08:21
Sum up network events by type, interval and network Axel Rau 16:29

Nov. 17, 2010

Thread Author Time
PostgreSQL array, recursion and more 📎 Ferruccio Zamuner 13:22
Re: PostgreSQL array, recursion and more Achilleas Mantzios 14:53
obtaining difference between minimum value and next in size John Lister 15:11
Re: obtaining difference between minimum value and next in size Tom Lane 15:42
Re: obtaining difference between minimum value and next in size Andreas Kretschmer 16:02
Re: obtaining difference between minimum value and next in size Oliveiros d'Azevedo Cristina 16:09
Re: obtaining difference between minimum value and next in size John Lister 22:46

Nov. 18, 2010

Thread Author Time
Re: obtaining difference between minimum value and next in size Oliveiros d'Azevedo Cristina 10:09

Nov. 19, 2010

Thread Author Time
force view column varchar(32) to varchar(128) Emi Lu 15:02
Re: force view column varchar(32) to varchar(128) Andreas Kretschmer 16:54
Re: force view column varchar(32) to varchar(128) Richard Broersma 17:34

Nov. 21, 2010

Thread Author Time
Re: PostgreSQL array, recursion and more Dmitriy Igrishin 11:50

Nov. 23, 2010

Thread Author Time
Howto "insert or update" ? Andreas 03:44
Re: Howto "insert or update" ? tv 04:11
"compressing" consecutive values into one Louis-David Mitterrand 15:19
Re: "compressing" consecutive values into one Oliveiros d'Azevedo Cristina 15:31
Re: "compressing" consecutive values into one Louis-David Mitterrand 18:13
Re: "compressing" consecutive values into one bricklen 18:19

Nov. 24, 2010

Thread Author Time
atomic multi-threaded upsert Mikhail V. Puzanov 20:16
Re: "compressing" consecutive values into one Louis-David Mitterrand 20:53
Re: atomic multi-threaded upsert Tom Lane 21:21

Nov. 25, 2010

Thread Author Time
insert from a select John Fabiani 00:07
Re: insert from a select Adrian Klaver 00:25
Re: atomic multi-threaded upsert KM 02:12
How strings are sorted by LC_COLLATE specifically? Chang Chao 05:42
Re: atomic multi-threaded upsert MIkhail Puzanov 06:51
Re: atomic multi-threaded upsert MIkhail Puzanov 07:24
Re: insert from a select Carla 11:40
Re: insert from a select Carla 12:32
Re: insert from a select John Fabiani 13:33
Re: insert from a select Trinath Somanchi 15:22
error null value in column" concat_id" violates not-null constraint Ana Louro 15:58

Nov. 26, 2010

Thread Author Time
Re: error null value in column" concat_id" violates not-null constraint Pavel Stehule 07:45
group by hour + distinct Michele Petrazzo - Unipex 11:39
Re: group by hour + distinct Oliveiros d'Azevedo Cristina 12:19
Re: group by hour + distinct Michele Petrazzo - Unipex 12:42
Re: group by hour + distinct Oliveiros d'Azevedo Cristina 13:15
Re: group by hour + distinct Lew 16:07
Insert row in 1.10.1 and 1.10.3 ndias 16:22
Re: Insert row in 1.10.1 and 1.10.3 Oliveiros d'Azevedo Cristina 16:52
Re: Insert row in 1.10.1 and 1.10.3 ndias 17:09
Re: Insert row in 1.10.1 and 1.10.3 Thomas Kellerer 17:14
Re: Insert row in 1.10.1 and 1.10.3 Guillaume Lelarge 17:25
Re: Insert row in 1.10.1 and 1.10.3 ndias 17:28

Nov. 27, 2010

Thread Author Time
Re: atomic multi-threaded upsert Mikhail V. Puzanov 15:08

Nov. 28, 2010

Thread Author Time
Is there a solution for "SELECT OR INSERT" Stefan Becker 23:30

Nov. 29, 2010

Thread Author Time
subselect and left join not working? Jorge Arenas 05:38
Re: subselect and left join not working? Jasen Betts 09:44
Re: subselect and left join not working? Tom Lane 15:27

Nov. 30, 2010

Thread Author Time
Re: subselect and left join not working? Jorge Arenas 04:29
Deleting entries from multiple tables manidegr8 05:59
Re: Deleting entries from multiple tables Dusan Misic 08:15
Re: Deleting entries from multiple tables Dusan Misic 08:19
Re: Deleting entries from multiple tables Achilleas Mantzios 08:36
Re: Deleting entries from multiple tables manidegr8 10:00
Re: subselect and left join not working? Carla 13:22
Re: Is there a solution for "SELECT OR INSERT" Florian Weimer 14:16
indexing longish string Rob Sargent 17:42
Re: indexing longish string jose 17:50
Re: indexing longish string Rob Sargent 17:57
Re: indexing longish string Kenneth Marshall 18:36
Re: indexing longish string Isaac Dover 19:21
Re: How strings are sorted by LC_COLLATE specifically? Peter Eisentraut 19:31
Re: indexing longish string Isaac Dover 20:03
DELETE WHERE EXISTS unexpected results Jeff Bland 22:16

Dec. 1, 2010

Thread Author Time
aggregation question Samuel Gendler 03:47
OT - load a shp file John Fabiani 06:06
Re: aggregation question Samuel Gendler 09:06
Re: OT - load a shp file Lee Hachadoorian 09:13

Browse Archives

Prev | Next