pgsql-sql since 2010-09-05 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. 5, 2010

Thread Author Time
naming arguments in aggregate function Viktor Bojović 23:38

Sept. 6, 2010

Thread Author Time
Re: naming arguments in aggregate function Tom Lane 00:35

Sept. 7, 2010

Thread Author Time
is there a distinct function for comma lists ? Andreas 11:52
Re: is there a distinct function for comma lists ? Andreas Gaab 12:19
Sequential scan evaluating function for each row, seemingly needlessly Bryce Nesbitt 19:15
Re: Sequential scan evaluating function for each row, seemingly needlessly Tom Lane 20:31

Sept. 8, 2010

Thread Author Time
Re: is there a distinct function for comma lists ? Lew 02:14
Table returning functions Jann Röder 13:35
Re: Generating Rows from a date and a duration Tim Schumacher 15:24
Re: Generating Rows from a date and a duration Joe Conway 16:02

Sept. 9, 2010

Thread Author Time
Controlling join order with parenthesis Marc Mamin 12:51
Re: Controlling join order with parenthesis Tom Lane 13:49

Sept. 10, 2010

Thread Author Time
sql disaster - subquery error but delete continues Greg Caulton 09:46
Re: sql disaster - subquery error but delete continues Thomas Kellerer 10:07

Sept. 11, 2010

Thread Author Time
Question regarding indices Steve 12:29
Question about PQexecParams Steve 12:44
Re: Question regarding indices Tom Lane 15:04
Re: Question regarding indices Lew 15:08
Re: Question regarding indices Steve 17:08
Re: Question regarding indices Steve 17:23
Re: Question regarding indices Tom Lane 18:22
Re: Question about PQexecParams Dmitriy Igrishin 21:52

Sept. 12, 2010

Thread Author Time
9.0rc1 - query of view produces unexpected results Nathan Grange 01:31

Sept. 13, 2010

Thread Author Time
Re: Question regarding indices Steve 00:03

Sept. 14, 2010

Thread Author Time
Re: 9.0rc1 - query of view produces unexpected results Alvaro Herrera 03:58
Re: Question regarding indices Frank Bax 11:31
Re: 9.0rc1 - query of view produces unexpected results 📎 Nathan Grange 16:56
Re: 9.0rc1 - query of view produces unexpected results Tom Lane 17:51

Sept. 15, 2010

Thread Author Time
Use "CREATE USER" in plpgsql function Tatarnikov Alexander 04:05
Re: Use "CREATE USER" in plpgsql function Sergey Konoplev 06:40
Re: Use "CREATE USER" in plpgsql function Sergey Konoplev 07:55
Re: Use "CREATE USER" in plpgsql function Igor Neyman 14:26
Re: Use "CREATE USER" in plpgsql function Asko Oja 18:28
Re: Use "CREATE USER" in plpgsql function - Found word(s) list error in the Text body Igor Neyman 19:06
Re: Use "CREATE USER" in plpgsql function - Found word(s) list error in the Text body Igor Neyman 19:08

Sept. 16, 2010

Thread Author Time
Re: Use "CREATE USER" in plpgsql function - Found word(s) list error in the Text body Tatarnikov Alexander 02:03
with queries Greg Quinn 05:05
with queries Greg Quinn 05:45

Sept. 17, 2010

Thread Author Time
all the table values equal Michele Petrazzo - Unipex 14:50
Re: all the table values equal Oliveiros d'Azevedo Cristina 15:03
Re: all the table values equal Michele Petrazzo - Unipex 15:45

Sept. 19, 2010

Thread Author Time
Re: Table returning functions Jann Röder 23:04
Re: Table returning functions Tom Lane 23:58

Sept. 20, 2010

Thread Author Time
Re: Table returning functions Jann Röder 07:43
Jagged/ragged arrays Florian Weimer 08:54
Re: all the table values equal Oliveiros d'Azevedo Cristina 09:29
Re: Jagged/ragged arrays Dmitriy Igrishin 19:42

Sept. 21, 2010

Thread Author Time
Re: Jagged/ragged arrays Craig Ringer 04:58
Re: Jagged/ragged arrays Florian Weimer 07:19
Re: Jagged/ragged arrays Dmitriy Igrishin 07:19
Re: all the table values equal Michele Petrazzo - Unipex 08:11
Re: all the table values equal 📎 negora 08:17
Re: all the table values equal Oliveiros d'Azevedo Cristina 10:25
Help with queries. Adrian Johnson 11:57
Slow response in select Gary Stainburn 12:25
Re: Slow response in select Craig Ringer 14:11
Re: Slow response in select Gary Stainburn 14:20
Re: Slow response in select Gary Stainburn 14:35
Re: all the table values equal Michele Petrazzo - Unipex 14:43
Re: all the table values equal Oliveiros d'Azevedo Cristina 14:46
Re: Slow response in select Tom Lane 14:52
Re: all the table values equal Oliveiros d'Azevedo Cristina 15:02
Re: Help with queries. Oliveiros d'Azevedo Cristina 16:11
available RPM package for 8.4.4? Joshua Gooding 17:53
Re: available RPM package for 8.4.4? Devrim GÜNDÜZ 20:22
Re: Help with queries. Adrian Johnson 23:16

Sept. 22, 2010

Thread Author Time
insert into help Nicholas I 07:32
Re: insert into help Guillaume Lelarge 07:35
Re: insert into help venkat 07:35
Re: Question about PQexecParams Steve 10:07
pg_config -less Rob Sargent 19:51

Sept. 23, 2010

Thread Author Time
HowTo divide streetname from house-nr ? Andreas 01:25
Re: HowTo divide streetname from house-nr ? Craig Ringer 02:08
unique fields Adrian Johnson 03:30
Re: HowTo divide streetname from house-nr ? 📎 negora 07:12
Re: unique fields Sergey Konoplev 07:33
Re: unique fields Oliveiros d'Azevedo Cristina 10:01
Re: HowTo divide streetname from house-nr ? Andreas Schmitz 10:53
Re: Proper case function Jonathan Brinkman 14:13
Re: pg_config -less Tom Lane 14:49
Question Regarding Unique Index on Table Ozer, Pam 17:18
Re: Question Regarding Unique Index on Table Kenneth Marshall 18:33
Re: pg_config -less Rob Sargent 18:43
Re: pg_config -less Rob Sargent 18:46
identifying duplicates in table with redundancies Tarlika Elisabeth Schmitz 21:39

Sept. 24, 2010

Thread Author Time
find and replace the string within a column Nicholas I 09:15
Re: find and replace the string within a column Jayadevan M 09:33
Re: insert into help James Kitambara 09:37
Re: identifying duplicates in table with redundancies Oliveiros d'Azevedo Cristina 10:22
Re: find and replace the string within a column Craig Ringer 11:34
pgdump with insert command help Nicholas I 12:32
Re: pgdump with insert command help Guillaume Lelarge 12:49
Re: find and replace the string within a column Leif Biberg Kristensen 14:39
Re: identifying duplicates in table with redundancies Tarlika Elisabeth Schmitz 16:12
Re: identifying duplicates in table with redundancies Oliver d'Azevedo Christina 17:12
Re: identifying duplicates in table with redundancies Tarlika Elisabeth Schmitz 17:39

Sept. 27, 2010

Thread Author Time
Re: pgdump with insert command help Vibhor Kumar 11:31
Re: identifying duplicates in table with redundancies Tarlika Elisabeth Schmitz 16:54

Sept. 28, 2010

Thread Author Time
Regexp matching Eduardas Kazakas 08:34
eB7E2R gangadhar bandaru 09:02
Re: identifying duplicates in table with redundancies Oliveiros d'Azevedo Cristina 10:34
Re: is there a distinct function for comma lists ? msi77 14:00
Re: identifying duplicates in table with redundancies Tarlika Elisabeth Schmitz 20:36

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

Browse Archives

Prev | Next