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

July 5, 2010

Thread Author Time
How to store Byte strings into a table. Trinath Somanchi 05:57
Re: silly sad 06:12
Re: Trinath Somanchi 06:30
Re: Pavel Stehule 06:35
Re: silly sad 06:36
Re: Pavel Stehule 06:43
Re: How to store Byte strings into a table. Sergey Konoplev 06:45
Re: silly sad 06:56
Re: Pavel Stehule 07:03
Re: silly sad 07:10
Re: Pavel Stehule 07:18
Re: silly sad 07:28
Re: Pavel Stehule 07:51

July 6, 2010

Thread Author Time
Re: 📎 Justin Graf 17:52
How To Calculate Table Size Minus Deleted Rows Brian Helm 19:42

July 7, 2010

Thread Author Time
Re: silly sad 05:00
How to Get Column Names from the Table venkat 09:08
Re: How to Get Column Names from the Table AI Rumman 09:13
Re: [SQL] How to Get Column Names from the Table Viktor Bojović 09:14
Re: How to Get Column Names from the Table A. Kretschmer 09:14
Re: How to Get Column Names from the Table venkat 09:17
Re: How to Get Column Names from the Table Jayadevan M 09:29
Re: [SQL] How to Get Column Names from the Table Sreelatha G 10:12
Re: [SQL] How to Get Column Names from the Table venkat 10:14
Re: 📎 Justin Graf 14:35
strangest thing happened John 19:59
Re: strangest thing happened John 20:38
tsearch2 and wildcards/pattern matching? Peter Koczan 20:41
Re: strangest thing happened Ross J. Reedstrom 20:42
Re: strangest thing happened Joe Conway 20:45
How to find events within a timespan to each other? Andreas 21:20
Re: strangest thing happened 📎 Justin Graf 21:25
Re: How to find events within a timespan to each other? Tim Landscheidt 22:01
Re: strangest thing happened 📎 Justin Graf 22:14
Re: strangest thing happened John 22:41
Re: tsearch2 and wildcards/pattern matching? Oleg Bartunov 22:44

July 8, 2010

Thread Author Time
Re: tsearch2 and wildcards/pattern matching? Peter Koczan 01:51
Re: strangest thing happened Viktor Bojović 06:36
Re: silly sad 07:31
Re: strangest thing happened Ben Morrow 07:37
Re: Dave Page 07:38
Re: silly sad 08:47
Question about domains. Dmitriy Igrishin 13:27
Re: strangest thing happened 📎 Justin Graf 14:52
Re: strangest thing happened Torsten Zühlsdorff 14:57
Re: Question about domains. Vibhor Kumar 19:41
Re: Cant execute the query Thomas Kellerer 22:08

July 9, 2010

Thread Author Time
Re: Well-formed SQL check in postgres? Davor J. 07:52

July 10, 2010

Thread Author Time
How would I store little key-Nr to text lists? Andreas 07:57
Re: How would I store little key-Nr to text lists? Pavel Stehule 09:02

July 13, 2010

Thread Author Time
subtract two dates to get the number of days Campbell, Lance 14:58
Re: subtract two dates to get the number of days Tom Lane 15:02
Re: subtract two dates to get the number of days Thomas Kellerer 15:05

July 14, 2010

Thread Author Time
Re: subtract two dates to get the number of days silly sad 05:28
Question on COUNT performance Anders Østergaard Jensen 11:58
Re: Question on COUNT performance Reinoud van Leeuwen 12:30
Re: subtract two dates to get the number of days Jean-David Beyer 12:37
Re: Question on COUNT performance Joshua Tolley 13:30
Re: Question on COUNT performance Reinoud van Leeuwen 13:44
Re: subtract two dates to get the number of days Thomas Kellerer 16:06
Re: Question on COUNT performance Lee Hachadoorian 16:21
Re: Question on COUNT performance Lee Hachadoorian 16:49
Re: subtract two dates to get the number of days Jean-David Beyer 17:05
Re: Question on COUNT performance Anders Østergaard Jensen 23:49

July 15, 2010

Thread Author Time
Re: Question on COUNT performance Anders Østergaard Jensen 00:14
Re: Question on COUNT performance 📎 Lee Hachadoorian 03:43
Re: subtract two dates to get the number of days Thomas Kellerer 07:18
Re: Question on COUNT performance REISS Thomas DSIC BIP 09:16

July 16, 2010

Thread Author Time
Presentación JHONATAN CANO FURAGARO 14:52

July 19, 2010

Thread Author Time
How oids of the base data types often change? Dmitriy Igrishin 10:47
Re: How oids of the base data types often change? Peter Eisentraut 11:04

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

Browse Archives

Prev | Next