pgsql-sql since 2009-07-14 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 14, 2009

Thread Author Time
Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu 15:08
Re: function returning a cursor and a scalar Surajit Bhattacharjee 15:21
Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane 16:47
Re: Request new version to support "on commit drop" for create temp table ... as select ? Scott Marlowe 17:33
Re: Request new version to support "on commit drop" for create temp table ... as select ? Tom Lane 17:38
Re: Request new version to support "on commit drop" for create temp table ... as select ? Emi Lu 18:52

July 16, 2009

Thread Author Time
Comparing a string against an XPath result set Tim Landscheidt 21:19

July 17, 2009

Thread Author Time
De-duplicating rows Christophe 03:07
Re: De-duplicating rows Richard Huxton 07:21
Re: De-duplicating rows Frank Bax 15:04
Re: De-duplicating rows Scott Marlowe 15:32

July 18, 2009

Thread Author Time
Timestamp with timezone with Default value Gianvito Pio 08:19
Re: Timestamp with timezone with Default value Jasmin Dizdarevic 10:25
Table inheritance problem Gianvito Pio 17:09

July 19, 2009

Thread Author Time
Re: Timestamp with timezone with Default value Jasen Betts 12:59

July 20, 2009

Thread Author Time
how to tell if column set on update chester c young 13:19
unused columns in copy chester c young 13:22
Re: Table inheritance problem Andreas Wenk 13:32
Storing/sorting hex data in PostgreSQL JJ 19:59
Re: unused columns in copy Marcin Stępnicki 22:59

July 21, 2009

Thread Author Time
Re: how to tell if column set on update nha 00:07
Re: unused columns in copy nha 00:20
Re: Storing/sorting hex data in PostgreSQL nha 11:14
Order of operations in ascii vs archive format (moderately urgent) Rob Sargent 16:27
Re: Order of operations in ascii vs archive format (moderately urgent) Tom Lane 16:49
Re: Order of operations in ascii vs archive format (moderately urgent) Rob Sargent 16:54
Re: Order of operations in ascii vs archive format (moderately urgent) Rob Sargent 17:24
Re: Order of operations in ascii vs archive format (moderately urgent) Tom Lane 17:29

July 22, 2009

Thread Author Time
Re: how to tell if column set on update chester c young 03:51
Re: how to tell if column set on update Frank Bax 11:42
Double aggregate problem David Weilers 16:16
Re: Double aggregate problem nha 17:45
Re: Double aggregate problem Peter Eisentraut 18:04

July 23, 2009

Thread Author Time
Re: Double aggregate problem nha 01:23
Re: how to tell if column set on update nha 01:42
Bit by "commands ignored until end of transaction block" again Glenn Maynard 04:58
Need magical advice for counting NOTHING Andreas 05:01
Re: Bit by "commands ignored until end of transaction block" again Richard Huxton 05:31
Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard 06:04
Re: Bit by "commands ignored until end of transaction block" again Richard Huxton 06:41
Re: Need magical advice for counting NOTHING Shane Ambler 06:46
Re: Bit by "commands ignored until end of transaction block" again Joshua Tolley 06:46
Re: Need magical advice for counting NOTHING A. Kretschmer 06:57
Re: Bit by "commands ignored until end of transaction block" again Chris 07:06
Re: Need magical advice for counting NOTHING A. Kretschmer 07:10
Re: Bit by "commands ignored until end of transaction block" again Thomas Kellerer 07:32
Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard 07:39
Re: Double aggregate problem David Weilers 08:03
Re: Bit by "commands ignored until end of transaction block" again Richard Huxton 08:06
Re: Need magical advice for counting NOTHING Glenn Maynard 08:23
using count in other column bartjoosen 09:59
Re: Bit by "commands ignored until end of transaction block" again Stephen Frost 10:55
Re: Bit by "commands ignored until end of transaction block" again Adrian Klaver 14:20

July 24, 2009

Thread Author Time
Re: Bit by "commands ignored until end of transaction block" again Craig Ringer 09:43
Re: Bit by "commands ignored until end of transaction block" again Craig Ringer 09:52
Re: Bit by "commands ignored until end of transaction block" again Alvaro Herrera 16:54
Re: Bit by "commands ignored until end of transaction block" again Joshua Tolley 18:09
Re: using count in other column nha 22:41
Re: using count in other column nha 23:13

July 25, 2009

Thread Author Time
Re: Need magical advice for counting NOTHING nha 00:26
Re: Need magical advice for counting NOTHING Andreas 20:46

July 26, 2009

Thread Author Time
Re: Bit by "commands ignored until end of transaction block" again Glenn Maynard 21:21
Re: Bit by "commands ignored until end of transaction block" again Science 23:15

July 27, 2009

Thread Author Time
Re: Bit by "commands ignored until end of transaction block" again Craig Ringer 00:00
Re: Bit by "commands ignored until end of transaction block" again Science 12:40

July 28, 2009

Thread Author Time
sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Gau, Hans-Jürgen 09:58
Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Daryl Richter 12:25
Detect referential integrity structure Akos Gabriel 18:12
Re: Detect referential integrity structure Rob Sargent 20:08
Tweak sql result set... ? Axe 20:49
Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha 21:10

July 29, 2009

Thread Author Time
Re: Tweak sql result set... ? Tim Landscheidt 00:24
Re: Tweak sql result set... ? Axe 06:35
WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Gau, Hans-Jürgen 09:48
Re: WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha 10:21
Re: WG: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL nha 11:03
Re: Tweak sql result set... ? Jasen Betts 12:39
Re: sql-porting-problem oracle to postgresql with UPDATE/IS NOT NULL Daryl Richter 13:44
WG: WG: sql-porting-problem oracle to postgresql with UPDAT E/IS NOT NULL Gau, Hans-Jürgen 16:08
Foreign keys and fixed values... Kjell Rune Skaaraas 20:16

July 30, 2009

Thread Author Time
SQL report wkipjohn 02:48
Re: Tweak sql result set... ? Jasmin Dizdarevic 07:53
SELECT max() group by problem Heigo Niilop 09:07
SELECT max(time) group by problem Heigo Niilop 09:38
Re: Tweak sql result set... ? Axe 13:31
Re: Tweak sql result set... ? Tim Landscheidt 14:19
Re: SQL report Rob Sargent 15:16
Re: Tweak sql result set... ? Rob Sargent 15:25
Re: Foreign keys and fixed values... Daryl Richter 15:33
Re: SQL report Steve Crawford 16:41
Show CAS, USD first; the left ordered by currency name Emi Lu 19:51
Re: Show CAS, USD first; the left ordered by currency name Andreas Kretschmer 20:05
Re: Show CAS, USD first; the left ordered by currency name sergey kapustin 20:06

July 31, 2009

Thread Author Time
Re: SQL report wkipjohn 00:08
Re: SELECT max(time) group by problem nha 00:46
Re: SQL report wkipjohn 03:55
Re: Show CAS, USD first; the left ordered by currency name Harald Fuchs 11:37
Re: Show CAS, USD first; the left ordered by currency name bricklen 13:27
Re: Show CAS, USD first; the left ordered by currency name Emi Lu 14:05
on error resume next Jasmin Dizdarevic 15:24
Re: SQL report Rob Sargent 15:50
Re: on error resume next Andreas Wenk 18:12
Re: on error resume next Jasmin Dizdarevic 18:52
How fetch multiple rows into one text-field? Andreas 20:09
Re: How fetch multiple rows into one text-field? Joshua Tolley 23:29

Aug. 3, 2009

Thread Author Time
Activity count problem dino 09:02
Problems when copy data from dump file Klas Stockhem 11:00
Re: Tweak sql result set... ? Axe 11:13
Problems when copy data from dump file Klas Stockhem 12:08
Create table command fails with permission denied Venkateswara Rao Bondada 12:08
Re: Create table command fails with permission denied Rob Sargent 22:02

Aug. 4, 2009

Thread Author Time
Re: Problems when copy data from dump file Richard Huxton 08:09
Re: Create table command fails with permission denied Venkateswara Rao Bondada 08:11
Re: Problems when copy data from dump file Richard Huxton 13:26
Re: Create table command fails with permission denied Rob Sargent 16:32

Aug. 5, 2009

Thread Author Time
Re: Create table command fails with permission denied Tom Lane 01:16
Re: Problems when copy data from dump file Klas Stockhem 09:56
question about pgagent Jan Verheyden 13:54
Re: Create table command fails with permission denied Venkateswara Rao Bondada 17:05
Re: LOG: unexpected EOF on client connection Bernd Nawothnig 18:40
two records per row from query John 23:51

Aug. 6, 2009

Thread Author Time
Re: LOG: unexpected EOF on client connection Tom Lane 02:19
Re: two records per row from query A. Kretschmer 05:21
Re: Problems when copy data from dump file Richard Huxton 07:36
Re: Problems when copy data from dump file Klas Stockhem 08:39
Re: Problems when copy data from dump file Richard Huxton 08:42
trigger problem Jan Verheyden 09:09
Problems when copy data from dump file Klas Stockhem 10:00
Re: two records per row from query Leo Mannhart 13:42
Re: two records per row from query John 13:48
FW: trigger problem Jan Verheyden 13:56
Re: two records per row from query A. Kretschmer 14:21
Re: two records per row from query John 15:46

Aug. 7, 2009

Thread Author Time
Re: two records per row from query Leo Mannhart 09:50
Re: two records per row from query John 13:28

Aug. 11, 2009

Thread Author Time
Updating a specific number of rows in pl/pgsql Peter Headland 00:52
Import (.CVS File) to postgreSql 📎 Premila Devi 03:54
Re: Import (.CVS File) to postgreSql Shoaib Mir 04:22
Re: Import (.CVS File) to postgreSql Shoaib Mir 04:58
Re: Import (.CVS File) to postgreSql A. Kretschmer 05:12
Determining logically unique entities across many partially complete rows where at least one column matches Jamie Tufnell 06:19
Re: Updating a specific number of rows in pl/pgsql D'Arcy J.M. Cain 10:25
Re: Updating a specific number of rows in pl/pgsql Pavel Stehule 10:55
Re: Determining logically unique entities across many partially complete rows where at least one column matches Jasen Betts 11:45
mail alert Jan Verheyden 13:01
Month/year between two dates Bor 13:13
Re: Determining logically unique entities across many partially complete rows where at least one column matches Rob Sargent 15:40
Re: Updating a specific number of rows in pl/pgsql Peter Headland 16:55
Re: Updating a specific number of rows in pl/pgsql Peter Headland 17:05
Re: Updating a specific number of rows in pl/pgsql Pavel Stehule 17:22
Re: Updating a specific number of rows in pl/pgsql Peter Headland 17:24
Race hazard deleting using CTID? Peter Headland 18:29
Re: Race hazard deleting using CTID? Tom Lane 19:00
Re: Race hazard deleting using CTID? Peter Headland 20:13
Re: Month/year between two dates Steve Crawford 22:32
Re: mail alert Denis BUCHER 22:35

Aug. 12, 2009

Thread Author Time
Re: mail alert Rob Sargent 01:38
Re: Month/year between two dates ramasubramanian 03:59
Re: mail alert ramasubramanian 04:01
Re: mail alert Shoaib Mir 06:15
Re: mail alert Jan Verheyden 07:29
Re: Updating a specific number of rows in pl/pgsql Xharon 07:34
Re: mail alert Jan Verheyden 13:27
Re: mail alert Rob Sargent 14:01
Re: mail alert Jan Verheyden 14:44
mysql code questions Ray Stell 18:19
Re: mysql code questions Thomas Kellerer 18:52
Re: mysql code questions Greg Stark 19:00

Aug. 13, 2009

Thread Author Time
Re: Month/year between two dates Jorge Godoy 00:58
simple? query Jan Verheyden 11:36
Re: mail alert Jasen Betts 12:08
Re: mail alert Jasen Betts 12:16
Re: simple? query Relyea, Mike 20:46
Re: mail alert Alvaro Herrera 21:54
Re: mail alert Tim Landscheidt 22:24
Re: mail alert Alvaro Herrera 22:36
Re: mail alert Adrian Klaver 23:30

Aug. 14, 2009

Thread Author Time
Re: simple? query Jasen Betts 08:58
Field or record level encryption / decryption Hengky Lie 09:20
Re: simple? query Relyea, Mike 12:58
Re: Field or record level encryption / decryption Joshua Tolley 13:24
Re: simple? query Relyea, Mike 14:21
Re: simple? query Tim Landscheidt 14:53
Re: mail alert Christopher Browne 15:18
Re: Field or record level encryption / decryption Christopher Browne 15:21
Re: Field or record level encryption / decryption Hengky Lie 16:07
Re: Field or record level encryption / decryption Joshua Tolley 22:28

Aug. 17, 2009

Thread Author Time
Multiple simultaneous queries on single connection Yeb Havinga 12:49

Aug. 18, 2009

Thread Author Time
FW: simple? query Jan Verheyden 07:04
operator contains in older Pgsql W. Kinastowski 07:47
Re: operator contains in older Pgsql Jasen Betts 09:44
Re: operator contains in older Pgsql W. Kinastowski 10:16
Re: operator contains in older Pgsql Jasen Betts 11:18
SQL Query Performance - what gives? 📎 Karl Denninger 19:45
Re: SQL Query Performance - what gives? Kevin Grittner 20:23
Re: SQL Query Performance - what gives? 📎 Karl Denninger 20:58
Updating one table with data from another drew 21:02
Re: SQL Query Performance - what gives? Kevin Grittner 21:59
Re: SQL Query Performance - what gives? 📎 Karl Denninger 23:03
Re: FW: simple? query Tim Landscheidt 23:39

Browse Archives

Prev | Next