pgsql-sql since 2003-02-17 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Feb. 17, 2003

Thread Author Time
Re: Table Pivot Joe Conway 04:02
trigger after with cursor betty 04:57
Trigger that will execute external program David Loh 06:16
Re: [SQL] is current_timestamp unique for a transaction? Rajesh Kumar Mallah 07:10
Re: trigger after with cursor betty 10:25
Special Date/Time Inputs Tomasz Myrta 10:53
Re: Special Date/Time Inputs A.Bhuvaneswaran 12:12
Re: Special Date/Time Inputs Tomasz Myrta 12:17
Re: Special Date/Time Inputs Tomasz Myrta 12:19
[No subject] iafmgc 14:32
Re: rownum Terry Yapt 16:25
Re: sub-query optimization Brad Hilton 17:20
Re: sub-query optimization Tomasz Myrta 18:11
Re: PL/PGSQL EDITOR Josh Berkus 19:52
Re: convert from an integer to a date Miquel van Smoorenburg 19:52
Returning multiple rows from plpgsql function Mintoo Lall 20:07
Re: Returning multiple rows from plpgsql function Stephan Szabo 20:18
Format Function Yudie 20:56
Re: Format Function Josh Berkus 20:56
Re: Tomasz Myrta 21:01
Re: select from update from select? Tambet Matiisen 21:22
Re: convert from an integer to a date Frank Bax 21:43

Feb. 18, 2003

Thread Author Time
Re: Format Function Yudie 00:21
Re: DATABASE EXAMPLES? Will Trillich 03:19
Re: trigger after with cursor Christoph Haller 08:48
select from update from select? Dave Gomboc 08:57
How to make sequence skip existing key in table? Raymond Pau 10:01
" Adding missing FROM-clause entry for table .... " problem. Rajesh Kumar Mallah 10:04
Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller 10:34
Re: " Adding missing FROM-clause entry for table .... " problem. Tomasz Myrta 10:43
Re: " Adding missing FROM-clause entry for table .... " problem. Tomasz Myrta 10:48
Re: trigger after with cursor betty 11:37
Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller 11:51
Re: How to make sequence skip existing key in table? Bruno Wolff III 13:43
Re: " Adding missing FROM-clause entry for table .... " problem. Bruno Wolff III 14:12
Re: " Adding missing FROM-clause entry for table .... " problem. Tom Lane 15:40
Re: " Adding missing FROM-clause entry for table .... " problem. Tom Lane 15:50
Re: " Adding missing FROM-clause entry for table .... " problem. Jeff Eckermann 16:03
Re: " Adding missing FROM-clause entry for table .... " problem. Stephan Szabo 16:06
Re: Jeff Eckermann 16:07
Re: Trigger that will execute external program Hans-Jürgen Schönig 16:58
Re: How to make sequence skip existing key in table? Josh Berkus 17:07
Re: Drop temporary table only if it exists Jan Wieck 17:38
Rule Creates Duplicates retry Martin Davidsson 17:57
Re: Drop temporary table only if it exists Josh Berkus 18:28
Re: Trigger that will execute external program Jan Wieck 20:20
Re: trigger after with cursor Jeff Eckermann 20:21
Re: Drop temporary table only if it exists Jan Wieck 20:47
once again, sorting with Unicode JBJ 23:13

Feb. 19, 2003

Thread Author Time
point <-> polygon not supported? Scott Ding 00:12
Re: Drop temporary table only if it exists Josh Berkus 06:29
Re: Rule Creates Duplicates retry Tom Lane 07:39
Re: once again, sorting with Unicode Troy 10:49
Re: once again, sorting with Unicode Antti Haapala 12:37
Re: select from update from select? Richard Huxton 12:49
VIEW or Stored Proc - Is this even possible? Stephen.Thompson 12:56
Re: " Adding missing FROM-clause entry for table .... " problem. Christoph Haller 13:04
Default column titles in a select... Axel Schlueter 14:25
Re: Default column titles in a select... greg 15:07
Re: Default column titles in a select... Christoph Haller 15:10
Re: once again, sorting with Unicode Tom Lane 15:22
Re: Default column titles in a select... Bruno Wolff III 15:22
Re: VIEW or Stored Proc - Is this even possible? Richard Huxton 18:10
simple join problem Matthew Nuzum 18:51
Re: Passing arrays Guy Fraser 19:06
EXCEPT Queries Mark Mitchell 19:16
Re: simple join problem Richard Huxton 20:08
Re: once again, sorting with Unicode Troy 20:16
Re: simple join problem Stephan Szabo 20:25
Re: Passing arrays Guy Fraser 20:26
Re: PL/PGSQL EDITOR Guy Fraser 20:37
Re: simple join problem Josh Berkus 20:49
Re: once again, sorting with Unicode JBJ 20:53
Re: simple join problem Matthew Nuzum 21:15
Re: PL/PGSQL EDITOR Josh Berkus 22:22
Date-range LEFT OUTER JOIN not using an index Michael Nachbaur 22:55

Feb. 20, 2003

Thread Author Time
Re: select from update from select? Dave Gomboc 01:46
Re: simple join problem mallah 04:02
Re: simple join problem Matthew Nuzum 04:25
problem on truncate for v.7.3.2 jack 05:45
Re: problem on truncate for v.7.3.2 Josh Berkus 06:14
Re: EXCEPT Queries Josh Berkus 06:45
Re: EXCEPT Queries Peter Childs 08:29
Re: VIEW or Stored Proc - Is this even possible? Stephen.Thompson 10:09
Re: once again, sorting with Unicode Troy 10:45
Re: once again, sorting with Unicode Troy 10:51
Re: VIEW or Stored Proc - Is this even possible? Richard Huxton 11:08
pg_func problem Graham Vickrage 12:58
Re: VIEW or Stored Proc - Is this even possible? Stephen.Thompson 13:45
Re: point <-> polygon not supported? Tomasz Myrta 14:55
Re: problem on truncate for v.7.3.2 Tom Lane 15:13
How to drop all the sequences Arunachalam Jaisankar 16:40
Re: point <-> polygon not supported? Scott Ding 16:44
Re: point <-> polygon not supported? Tomasz Myrta 17:05
Re: point <-> polygon not supported? Scott Ding 18:34
Re: PL/PGSQL EDITOR Josh Berkus 19:20
Re: How to drop all the sequences Tomasz Myrta 20:39
Re: EXCEPT Queries Jeff Boes 20:59

Feb. 21, 2003

Thread Author Time
Nth Select Mark Mitchell 00:19
Fw: 向华东 03:35
Fw: 向华东 03:35
Re: How to make sequence skip existing key in table? Raymond Pau 06:29
Re: How to drop all the sequences Oleg Samoylov 08:04
Re: Fw: Tomasz Myrta 08:12
Re: Fw: Daniel Schuchardt 11:38
Re: " Adding missing FROM-clause entry for table .... " problem. Rajesh Kumar Mallah 13:08
How do I view triggers Graham Vickrage 13:24
good style? Rafal Kedziorski 13:30
Re: good style? Rajesh Kumar Mallah 13:51
Re: good style? Alan Gutierrez 13:54
function defination help .. Rajesh Kumar Mallah 13:54
Re: good style? Tambet Matiisen 14:39
Re: good style? Rafal Kedziorski 16:05
7.3 "group by" issue Dan Langille 18:01
Re: 7.3 "group by" issue Gaetano Mendola 18:18
Re: 7.3 "group by" issue Dan Langille 18:25
Re: 7.3 "group by" issue Chad Thompson 20:00
Re: 7.3 "group by" issue Dan Langille 20:22
Re: 7.3 "group by" issue Chad Thompson 20:30
Re: How do I view triggers Chad Thompson 20:44
Re: 7.3 "group by" issue Dan Langille 20:45
Re: 7.3 "group by" issue Chad Thompson 20:51
join gone awry Matthew Nuzum 22:33
Users and groups Teddy 22:37
Re: 7.3 "group by" issue Josh Berkus 23:25

Feb. 22, 2003

Thread Author Time
Re: 7.3 "group by" issue Dan Langille 00:13
7.3 GROUP BY differs from 7.2 Dan Langille 01:18
Re: 7.3 "group by" issue Peter Eisentraut 02:09
Re: function defination help .. Peter Eisentraut 02:10
Re: 7.3 GROUP BY differs from 7.2 Tom Lane 03:28
Re: function defination help .. Rajesh Kumar Mallah 06:13
Re: [SQL] 7.3 GROUP BY differs from 7.2 Stephan Szabo 07:57
Re: [SQL] 7.3 GROUP BY differs from 7.2 Tom Lane 08:05
SORT with accents Edipo E. F. Melo 11:01
Re: [SQL] 7.3 GROUP BY differs from 7.2 Stephan Szabo 17:41
Re: 7.3 "group by" issue Josh Berkus 19:34

Feb. 23, 2003

Thread Author Time
how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 00:14
sql question after upgrade James Cooper 00:58
Re: sql question after upgrade Neil Conway 01:42
Re: 7.3 "group by" issue Peter Eisentraut 02:24
Re: sql question after upgrade Peter Eisentraut 02:24
how to return ONE single record from a function in plpgsql? Hubert depesz Lubaczewski 10:47
Porting from db2 problem Wayne Armstrong 11:11
Re: how to return ONE single record from a function in plpgsql? Tom Lane 16:34
Help with query involving aggregation and joining. Eddie Cheung 19:02
Re: inserting multiple rows with one statement codeWarrior 19:26
Re: 7.3 "group by" issue Josh Berkus 19:59
Re: [SQL] 7.3 GROUP BY differs from 7.2 Josh Berkus 20:19
Re: Help with query involving aggregation and joining. Josh Berkus 20:24
Re: Help with query involving aggregation and joining. Bruno Wolff III 20:45
syntax question James Cooper 22:07
SQL Statements question, why I get errors... plist 22:17
Re: syntax question Josh Berkus 22:52
Re: SQL Statements question, why I get errors... Josh Berkus 22:57
Re: syntax question Josh Berkus 23:07
Re: SQL Statements question, why I get errors... plist 23:13
Re: good style? Rafal Kedziorski 23:51

Feb. 24, 2003

Thread Author Time
Re: syntax question Josh Berkus 00:25
Re: SQL Statements question, why I get errors... Bruno Wolff III 03:27
Re: Help with query involving aggregation and joining. Eddie Cheung 05:17
Re: Help with query involving aggregation and joining. Eddie Cheung 05:18
Re: Help with query involving aggregation and joining. Josh Berkus 06:46
Re: Porting from db2 problem Christoph Haller 09:30
Re: Help with query involving aggregation and joining. Rajesh Kumar Mallah 13:24
Re: Help with query involving aggregation and joining. Christoph Haller 13:49
Re: syntax question Jeff Eckermann 15:17
Re: syntax question Tom Lane 15:30
Re: Help with query involving aggregation and joining. mallah 15:51
Re: Help with query involving aggregation and joining. Bruno Wolff III 17:16
Denormalizing during select no.spam 17:18
Dynamic SELECT condition Victor Yegorov 17:53
Re: syntax question Josh Berkus 18:22
Re: Denormalizing during select Jeff Boes 19:12
indexing James Cooper 20:38
Re: Denormalizing during select Josh Berkus 22:33
indexing James Cooper 22:38
Problem with deferred referential integrity checks Bob Smith 23:38

Feb. 25, 2003

Thread Author Time
Inquiry From Form [pgsql] Jack Kiss 00:22
Re: indexing Josh Berkus 01:16
Re: Denormalizing during select no.spam 03:37
Re: Denormalizing during select Edmund Lian 03:44
Sub Select inside Check ? Rudi Starcevic 05:48
Re: good style? Tambet Matiisen 06:42
two dates mixo 06:55
Re: Problem with deferred referential integrity checks Stephan Szabo 07:09
Re: Help with query involving aggregation and joining. Eddie Cheung 08:22
Re: good style? Rafal Kedziorski 08:44
Re: Sub Select inside Check ? Tomasz Myrta 11:29
STORAGE and GiST Itai Zukerman 14:06
Any limitation in size for return result from SELECT? Natasa Bulatovic 14:25
how can i drop a <unnamed> constraint rute solipa 14:55
Re: how can i drop a <unnamed> constraint Christoph Haller 15:05
Polymorphic? Itai Zukerman 15:09
Re: how can i drop a <unnamed> constraint Christoph Haller 15:23
Re: STORAGE and GiST Tom Lane 15:32
Re: Sub Select inside Check ? Stephan Szabo 15:50
Relation "pg_relcheck" Victor Yegorov 15:50
Re: Relation "pg_relcheck" Victor Yegorov 16:08
Re: Relation "pg_relcheck" Stephan Szabo 16:11
Re: Polymorphic? Tom Lane 16:20

Browse Archives

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