pgsql-sql - December 2007

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
Jump to day: 1 3 4 5 6 7 8 9 10 11 12 13 14 15 17 18 19 20 21 22 23 24 26 27 29 30 31

Dec. 1, 2007

Thread Author Time
Re: Using schema Scott Marlowe 03:33
Crosstab limitation... ronald tabada 03:47
Re: Crosstab limitation... Tom Lane 04:07

Dec. 3, 2007

Thread Author Time
alias required by standard or PostgreSQL? Joost Kraaijeveld 05:52
Re: alias required by standard or PostgreSQL? Tom Lane 06:13

Dec. 4, 2007

Thread Author Time
Calling functions from within pl/pgsql Achilleas Mantzios 12:16
Re: Calling functions from within pl/pgsql Pavel Stehule 12:59
Re: Calling functions from within pl/pgsql Achilleas Mantzios 13:23
Re: Calling functions from within pl/pgsql Pavel Stehule 13:41
marking tuples Ehab Galal 22:25

Dec. 5, 2007

Thread Author Time
Error OID Yohanes Purnomo 02:24
Re: Error OID Guillaume Lelarge 07:36
Re: marking tuples Gregory Stark 08:44
plpythonu and "hello concurrent world" Gerardo Herzig 13:10
Re: marking tuples Ehab Galal 13:34
Re: plpythonu and "hello concurrent world" Tom Lane 14:42
Re: plpythonu and "hello concurrent world" Gerardo Herzig 15:19

Dec. 6, 2007

Thread Author Time
Re: Error OID Yohanes Purnomo 02:08
execute system command from storage procedure Sabin Coanda 16:32
Re: execute system command from storage procedure Erik Jones 17:05
Re: execute system command from storage procedure Andreas Kretschmer 17:07
polymorphic functions and domains TJ O'Donnell 18:48
Rule rewrite to possible union? Erik Jones 22:03

Dec. 7, 2007

Thread Author Time
Re: polymorphic functions and domains Tom Lane 00:51
INSERT INTO relational tables Stefan Scheidegger 13:22
Re: INSERT INTO relational tables Andreas Kretschmer 15:16

Dec. 8, 2007

Thread Author Time
Re: polymorphic functions and domains TJ O'Donnell 18:32

Dec. 9, 2007

Thread Author Time
Re: INSERT INTO relational tables Steve Midgley 07:50

Dec. 10, 2007

Thread Author Time
join on three tables is slow Gerry Reno 01:31
Re: join on three tables is slow Gerry Reno 02:16
Re: join on three tables is slow Shane Ambler 04:45
SQL INSERT/TRIGGER Help Poovendran Moodley 06:36
Re: SQL INSERT/TRIGGER Help A. Kretschmer 06:44
Re: SQL INSERT/TRIGGER Help Poovendran Moodley 07:27
Re: SQL INSERT/TRIGGER Help A. Kretschmer 07:43
Re: SQL INSERT/TRIGGER Help Poovendran Moodley 09:13
Re: INSERT INTO relational tables Stefan Scheidegger 10:42
Re: INSERT INTO relational tables A. Kretschmer 11:08
Re: INSERT INTO relational tables A. Kretschmer 11:29
Re: INSERT INTO relational tables Stefan Scheidegger 13:21
Re: SQL INSERT/TRIGGER Help Alvaro Herrera 14:08

Dec. 11, 2007

Thread Author Time
Insert Rule, Multiple Insert, Update Problem Scott 04:23
Re: join on three tables is slow Gerry Reno 04:24
Re: Insert Rule, Multiple Insert, Update Problem Richard Broersma Jr 04:50
Re: join on three tables is slow Pavel Stehule 06:00
Re: join on three tables is slow Gerry Reno 13:23
Re: join on three tables is slow Pavel Stehule 14:55
case sensitivity for tables, columns, and constraint names Ertel, Steve 17:05
Re: case sensitivity for tables, columns, and constraint names A. Kretschmer 17:24
Re: case sensitivity for tables, columns, and constraint names Andrew Sullivan 17:30
Re: case sensitivity for tables, columns, and constraint names Richard Huxton 17:35
Re: join on three tables is slow Gerry Reno 18:18
Foreign Key for multi PK or design question PostgreSQL Admin 18:20
Re: Foreign Key for multi PK or design question Erik Jones 18:35
Re: Foreign Key for multi PK or design question A. Kretschmer 18:53
Re: Foreign Key for multi PK or design question PostgreSQL Admin 19:12
Re: Foreign Key for multi PK or design question Alvaro Herrera 19:42
Re: join on three tables is slow Pavel Stehule 19:46
Re: Foreign Key for multi PK or design question A. Kretschmer 19:48
Re: Foreign Key for multi PK or design question PostgreSQL Admin 20:04

Dec. 12, 2007

Thread Author Time
Query design assistance - getting daily totals Paul Lambert 01:34
Re: join on three tables is slow Tom Lane 04:35
Function result using execute Paul Lambert 05:15
Re: Function result using execute Tom Lane 06:01
Re: Function result using execute Erik Jones 06:25
Re: Function result using execute Paul Lambert 06:30
Re: Query design assistance - getting daily totals A. Kretschmer 06:31
Re: Query design assistance - getting daily totals Paul Lambert 06:39
Re: Query design assistance - getting daily totals A. Kretschmer 07:29
Re: join on three tables is slow Gerry Reno 14:29
Re: Query design assistance - getting daily totals Scott Marlowe 15:48
Query Assistance Gary Chambers 16:58
Re: Query Assistance D'Arcy J.M. Cain 17:31
Re: Query Assistance Gary Chambers 18:00
Re: Query design assistance - getting daily totals Rodrigo De León 19:53
Re: Query Assistance Richard Huxton 20:21
Trigger definition . . . puzzled Rolf A. de By 21:38
Re: Trigger definition . . . puzzled Erik Jones 22:30

Dec. 13, 2007

Thread Author Time
Re: Trigger definition . . . puzzled Rolf A. de By 07:19
Re: Trigger definition . . . puzzled Tom Lane 15:49
Re: Trigger definition . . . puzzled Rolf A. de By 15:59
Re: Trigger definition . . . puzzled Tom Lane 16:33
Re: Trigger definition . . . puzzled Rolf A. de By 20:22
Re: Query design assistance - getting daily totals Steve Midgley 21:11
SELECT MAX returns wrong value 📎 Gavin Baumanis 23:09
Re: SELECT MAX returns wrong value Tom Lane 23:32

Dec. 14, 2007

Thread Author Time
odd error updating - varchar Gary Stainburn 17:02
Re: odd error updating - varchar Tom Lane 17:17
Re: SELECT MAX returns wrong value Scott Marlowe 17:24

Dec. 15, 2007

Thread Author Time
Bad count of rows estimated for emerge join Oleg Kharin 15:15

Dec. 17, 2007

Thread Author Time
passing a multiple join to a function? Louis-David Mitterrand 13:06
Describe Table danap 16:56
Re: passing a multiple join to a function? Rodrigo De León 17:27
Re: Describe Table Erik Jones 17:33
Re: Describe Table Colin Wetherbee 17:34
Re: Describe Table Richard Broersma Jr 17:47
Re: Describe Table Tom Lane 18:03
Insert into and Sequence Luigi Pirillo 19:30

Dec. 18, 2007

Thread Author Time
Re: Describe Table danap 01:21
System catalog future changes Steve Midgley 16:53
Re: System catalog future changes Pavel Stehule 17:36
Re: System catalog future changes Erik Jones 17:38
Re: System catalog future changes Steve Midgley 19:29

Dec. 19, 2007

Thread Author Time
Re: Insert into and Sequence 📎 Ireneusz Pluta 13:21
DBLink or setof record functions & type shortcuts Jeff Trout 15:23

Dec. 20, 2007

Thread Author Time
sql query - create replace function Iuri Sampaio 05:29
Re: sql query - create replace function Richard Huxton 08:31

Dec. 21, 2007

Thread Author Time
Concatenation through SQL Philippe Lang 10:33
Re: Concatenation through SQL Andreas Kretschmer 10:58
Re: Concatenation through SQL Pavel Stehule 11:07
Re: Concatenation through SQL Leif B. Kristensen 11:16
Re: Concatenation through SQL imad 11:51
Re: Concatenation through SQL Niklas Johansson 12:07
Re: Concatenation through SQL Leif B. Kristensen 12:31
Re: Concatenation through SQL Philippe Lang 13:48
Re: Concatenation through SQL Pavel Stehule 14:24
Re: Concatenation through SQL Philippe Lang 16:01

Dec. 22, 2007

Thread Author Time
Misnamed field in subquery does not cause error when field name exists in parent query Rick Innis 22:12

Dec. 23, 2007

Thread Author Time
Re: Misnamed field in subquery does not cause error when field name exists in parent query Michael Glaesemann 00:14
Re: passing a multiple join to a function? Louis-David Mitterrand 16:37
returning an array as a list fo single-column rows? Louis-David Mitterrand 20:55
Re: returning an array as a list fo single-column rows? Pavel Stehule 21:19
Re: returning an array as a list fo single-column rows? Louis-David Mitterrand 21:22
Re: returning an array as a list fo single-column rows? Pavel Stehule 21:27
Re: returning an array as a list fo single-column rows? Louis-David Mitterrand 21:33
Re: returning an array as a list fo single-column rows? Pavel Stehule 21:45
returning an array as a list of single-column rows... (different approach) pgsql 23:02

Dec. 24, 2007

Thread Author Time
Different Query plans filtering between dates Dani Castaños 12:49
Re: Different Query plans filtering between dates Pavel Stehule 13:12
slow query - only uses indices Marc 14:46
Re: slow query - only uses indices imad 16:34
Re: slow query - only uses indices Pavel Stehule 16:41
Re: Misnamed field in subquery does not cause error when field name exists in parent query Rick Innis 19:25

Dec. 26, 2007

Thread Author Time
Advice for generalizing trigger functions Richard Broersma Jr 00:20
Re: Advice for generalizing trigger functions chester c young 18:11
need help A. Wiryawan 19:19
Re: Advice for generalizing trigger functions Richard Broersma Jr 20:20
Re: need help Richard Broersma Jr 20:22
Re: need help Richard Broersma Jr 20:42

Dec. 27, 2007

Thread Author Time
how to use pgsql like mssql 📎 liuzg2 00:18
Re: how to use pgsql like mssql 📎 liuzg2 02:05
Re: how to use pgsql like mssql Pavel Stehule 04:54
Re: how to use pgsql like mssql Pavel Stehule 04:55
Re: Advice for generalizing trigger functions Erik Jones 17:51
Re: Advice for generalizing trigger functions Richard Broersma Jr 18:03
Re: Advice for generalizing trigger functions Erik Jones 18:22

Dec. 29, 2007

Thread Author Time
Re: Advice for generalizing trigger functions Marcin Stępnicki 02:09
PL/pgsql: function passing argument to IN operator Daniel Myers 06:40
Re: PL/pgsql: function passing argument to IN operator Pavel Stehule 07:29
sql query question ? Trilok Kumar 10:52
Re: sql query question ? Shane Ambler 17:22
temp table existence Marcin Krawczyk 19:16
Re: temp table existence Pavel Stehule 19:33
Re: temp table existence Marcin Krawczyk 20:43
Re: temp table existence Marcin Krawczyk 21:16
Re: temp table existence Pavel Stehule 21:23
Re: temp table existence Adrian Klaver 22:25

Dec. 30, 2007

Thread Author Time
Re: temp table existence Erik Jones 06:26
Re: temp table existence Pavel Stehule 08:44

Dec. 31, 2007

Thread Author Time
Re: sql query question ? Trilok Kumar 13:53
Limit # of recs on inner join? Josh 18:52

Browse Archives

Prev | Next
Jump to day: 1 3 4 5 6 7 8 9 10 11 12 13 14 15 17 18 19 20 21 22 23 24 26 27 29 30 31