pgsql-sql since 2010-07-27 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

July 27, 2010

Thread Author Time
Re: grouping subsets Oliveiros d'Azevedo Cristina 10:37
Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them Tom Lane 20:50

July 28, 2010

Thread Author Time
Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them Torsten Zühlsdorff 06:45
how to escape _ in select Wes James 17:35
Re: how to escape _ in select Wes James 18:07
Re: how to escape _ in select Tom Lane 18:34
Re: how to escape _ in select 📎 Justin Graf 18:47
Re: how to escape _ in select Wes James 18:52
Re: how to escape _ in select Wes James 20:23
Re: how to escape _ in select Dmitriy Igrishin 20:44

July 29, 2010

Thread Author Time
Re: how to escape _ in select Thomas Kellerer 07:16
Re: grouping subsets Rainer Stengele 09:41
Re: grouping subsets Oliveiros d'Azevedo Cristina 11:47
Re: grouping subsets Rainer Stengele 12:10
How to get geometry enabled Tables form Postgresql/postgis venkat 12:58
Re: grouping subsets Oliveiros d'Azevedo Cristina 13:31
join table problem Jedrin 16:35
Re: How to get geometry enabled Tables form Postgresql/postgis 📎 Lee Hachadoorian 20:13

July 30, 2010

Thread Author Time
Re: How to get geometry enabled Tables form Postgresql/postgis venkat 04:27
Re: grouping subsets Rainer Stengele 09:35
Re: grouping subsets Oliveiros d'Azevedo Cristina 15:07
Re: grouping subsets Joshua Tolley 15:58

July 31, 2010

Thread Author Time
Re: grouping subsets Rainer Stengele 19:48

Aug. 3, 2010

Thread Author Time
What does PostgreSQL do when time goes backward? John Hasler 00:03
Help Need some hindsight Andreas 02:58
aggregate function Viktor Bojović 14:38
Re: aggregate function Tom Lane 14:48
Backslash characters in PLPGSQL Garrett Murphy 15:05
Re: Backslash characters in PLPGSQL Tom Lane 15:54
How do you do the opposite of regexp_split_to_table? John Gage 20:21
Re: How do you do the opposite of regexp_split_to_table? Alvaro Herrera 20:35

Aug. 4, 2010

Thread Author Time
workaround for missing ROWNUM feature with the help of GUC variables Marc Mamin 10:35
Re: join table problem Oliveiros d'Azevedo Cristina 11:11
Re: What does PostgreSQL do when time goes backward? Frank Bax 11:20
Re: Help Need some hindsight A. Kretschmer 11:48
Re: What does PostgreSQL do when time goes backward? Kenneth Marshall 12:55
Some quick questions Joshua Gooding 14:22
Re: Some quick questions Kenneth Marshall 14:43
Using SKYLINE command on PostgreSQL LaboRecherche 16:26
Re: What does PostgreSQL do when time goes backward? John Hasler 16:56
Domains, casts, and MS Access Peter Koczan 17:31
Re: Domains, casts, and MS Access Richard Broersma 17:47
Re: What does PostgreSQL do when time goes backward? Steve Wampler 17:50
Re: Domains, casts, and MS Access Peter Koczan 18:51
Re: Domains, casts, and MS Access Richard Broersma 18:56
Re: workaround for missing ROWNUM feature with the help of GUC variables Andreas Joseph Krogh 20:07
Re: Domains, casts, and MS Access 📎 Justin Graf 20:24
Delete rules Little, Douglas 20:25
Re: What does PostgreSQL do when time goes backward? Frank Bax 21:33
Re: Domains, casts, and MS Access Richard Broersma 21:40
Re: Delete rules Richard Broersma 21:52
Re: Domains, casts, and MS Access Peter Koczan 22:41

Aug. 5, 2010

Thread Author Time
Re: Domains, casts, and MS Access Richard Broersma 01:49
Re: Domains, casts, and MS Access David Bolen 21:28

Aug. 6, 2010

Thread Author Time
Re: workaround for missing ROWNUM feature with the help of GUC variables Marc Mamin 12:19

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

Browse Archives

Prev | Next