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

Thread	Author	Time
Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock	Brett Hoerner	02:06
Re: Problem with pg_try_advisory_lock and two connections (seemingly) getting the same lock	Rob Sargent	20:33

July 21, 2010

Thread	Author	Time
PostgreSQL ontop of FreeBSD jails, maybe there is still hope!	Achilleas Mantzios	06:47
Re: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!	Dave Page	07:57
Re: PostgreSQL ontop of FreeBSD jails, maybe there is still hope!	Achilleas Mantzios	08:06
UUID for Postgresql 8.4	Trinath Somanchi	12:19
Re: UUID for Postgresql 8.4	A. Kretschmer	12:33
Re: UUID for Postgresql 8.4	MIkhail Puzanov	12:37
Re: UUID for Postgresql 8.4	Kenneth Marshall	12:38

July 22, 2010

Thread	Author	Time
Aggregates (last/first) not behaving	Wes Devauld	06:37
grouping subsets	Rainer Stengele	08:09
Re: Aggregates (last/first) not behaving	Richard Huxton	08:44
Re: grouping subsets	A. Kretschmer	10:02
Re: grouping subsets	Richard Huxton	10:53
Re: grouping subsets	Tim Landscheidt	11:31
Re: grouping subsets	Oliveiros d'Azevedo Cristina	13:18
Re: grouping subsets	Rainer Stengele	13:25
Re: grouping subsets	Tim Landscheidt	14:18
Re: Aggregates (last/first) not behaving	Wes Devauld	15:50
Re: Aggregates (last/first) not behaving	Tim Landscheidt	18:42
Re: Aggregates (last/first) not behaving	Richard Huxton	19:24

July 23, 2010

Thread	Author	Time
[TRIGGER] Returning values from BEFORE UPDATE trigger, without using them	Torsten Zühlsdorff	12:53

July 24, 2010

Thread	Author	Time
howto delete using a join ?	Andreas	04:05
Re: howto delete using a join ?	Dmitriy Igrishin	09:22
Re: howto delete using a join ?	Joshua Tolley	11:47

July 26, 2010

Thread	Author	Time
Re: [TRIGGER] Returning values from BEFORE UPDATE trigger, without using them	Torsten Zühlsdorff	07:41
Returning only alphanumeric values from a query	Enrique Palacios	13:55
Re: Returning only alphanumeric values from a query	Osvaldo Kussama	15:44

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

Browse Archives

Prev | Next