pgsql-sql since 2010-08-07 00:00

Discussion for users on SQL related matters.

Search the Archives

Browse Archives

Prev | Next

Aug. 7, 2010

Thread	Author	Time
2010 International Conference on Progress in Informatics and Computing(PIC-2010 )	PIC2010	05:09
pl/python out params	Imre Horvath	14:49
Re: pl/python out params	Richard Albright	19:07
Re: pl/python out params	Tom Lane	20:22

Aug. 8, 2010

Thread	Author	Time
tsearch2 query question	Anders Østergaard Jensen	02:59
Re: Using SKYLINE command on PostgreSQL	Craig Ringer	03:35
Re: Using SKYLINE command on PostgreSQL	Yeb Havinga	13:40
Re: tsearch2 query question	Tom Lane	15:51

Aug. 10, 2010

Thread	Author	Time
libpq	Dmitriy Igrishin	13:35
type cast	Imre Horvath	16:38
Re: type cast	Peter Eisentraut	16:48
Re: type cast	Tom Lane	17:42
Duplicate rows	Edward W. Rouse	19:18
Re: Duplicate rows	Andreas Kretschmer	19:44
Re: Duplicate rows	msi77	19:59
Re: Duplicate rows	Edward W. Rouse	20:42
Re: Duplicate rows	Edward W. Rouse	21:19

Aug. 11, 2010

Thread	Author	Time
Using count on a join, group by required?	Jose Ildefonso Camargo Tolosa	02:51
Re: Duplicate rows	A. Kretschmer	04:50
Re: Using count on a join, group by required?	Peter Eisentraut	12:39
Re: Using count on a join, group by required?	Jose Ildefonso Camargo Tolosa	23:56

Aug. 12, 2010

Thread	Author	Time
libpq	Dmitriy Igrishin	14:47
Re: libpq	Tom Lane	15:04

Aug. 16, 2010

Thread	Author	Time
need to debug	John Fabiani	14:52

Aug. 17, 2010

Thread	Author	Time
plpgsql out parameter with select into	Horváth Imre	18:45
plpgsql out parameter with select into	Imre Horvath	18:46
Re: Domains, casts, and MS Access	Peter Koczan	21:06

Aug. 18, 2010

Thread	Author	Time
Question about POSIX Regular Expressions performance on large dataset.	Jose Ildefonso Camargo Tolosa	02:21
Re: Question about POSIX Regular Expressions performance on large dataset.	Scott Marlowe	02:28
Re: Question about POSIX Regular Expressions performance on large dataset.	Jose Ildefonso Camargo Tolosa	02:30
Re: Question about POSIX Regular Expressions performance on large dataset.	Scott Marlowe	02:33
Re: plpgsql out parameter with select into	Pavel Stehule	04:39
Re: plpgsql out parameter with select into	Sergey Konoplev	05:42
Re: Question about POSIX Regular Expressions performance on large dataset.	Sergey Konoplev	05:51
Re: plpgsql out parameter with select into	Horváth Imre	14:45
Re: plpgsql out parameter with select into	Imre Horvath	15:00
Windowed Postgres Query	Mindtonic	21:51
Re: plpgsql out parameter with select into	Sergey Konoplev	21:58
Re: plpgsql out parameter with select into	Tom Lane	22:09
Re: plpgsql out parameter with select into	Sergey Konoplev	22:18

Aug. 19, 2010

Thread	Author	Time
Extract created and last modified data	Gordon McVey	11:48
Re: Extract created and last modified data	Oliveiros d'Azevedo Cristina	13:24

Aug. 23, 2010

Thread	Author	Time
Inefficient query plan	Jann Röder	04:05
Re: Inefficient query plan	Jann Röder	10:58

Aug. 25, 2010

Thread	Author	Time
using min|max in where	Ben Carbery	00:41
Re: using min|max in where	Bruce Momjian	14:46

Aug. 26, 2010

Thread	Author	Time
Boolean output representation.	Dmitriy Igrishin	11:56
Re: Boolean output representation.	Pavel Stehule	14:07
Re: Boolean output representation.	Dmitriy Igrishin	14:22

Aug. 28, 2010

Thread	Author	Time
a general ? on select performance	John Fabiani	15:21
Re: a general ? on select performance	Tom Lane	15:35
Re: a general ? on select performance	John Fabiani	16:11

Aug. 30, 2010

Thread	Author	Time
backup and document views and user functions	David Harel	18:21
Re: backup and document views and user functions	Reinoud van Leeuwen	18:30
Re: backup and document views and user functions	Hélder M. Vieira	18:49
Re: backup and document views and user functions	Pavel Stehule	18:51
Re: backup and document views and user functions	Peter Steinheuser	19:20
PostGres Tables in ArcSDE and ArcCatalog.	Michael Andrew Babb	19:31
Re: backup and document views and user functions	Pavel Stehule	20:10

Aug. 31, 2010

Thread	Author	Time
Re: PostGres Tables in ArcSDE and ArcCatalog.	Scott Marlowe	06:39
polygon overlay	Gary Fu	21:14

Sept. 1, 2010

Thread	Author	Time
Re: PostGres Tables in ArcSDE and ArcCatalog.	Michael Andrew Babb	00:58
Re: polygon overlay	Tom Lane	13:42

Sept. 2, 2010

Thread	Author	Time
SUM the result of a subquery. 📎	negora	12:17
SUM the result of a subquery. 📎	negora	12:19
Re: SUM the result of a subquery.	Jayadevan M	12:28
Re: SUM the result of a subquery. 📎	negora	12:36

Sept. 3, 2010

Thread	Author	Time
Generating Rows from a date and a duration	Tim Schumacher	09:40
procedure help between databases	Daniel Sobey	10:49

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

Browse Archives

Prev | Next