pgsql-sql since 2001-05-03 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 29 30 31

May 3, 2001

Thread Author Time
Dateadd Ligia Pimentel 00:55
"correct" sorting. Jeff MacDonald 04:40
Re: How to encode and decode password in pgsql !! D'Arcy J.M. Cain 12:46
Re: How to encode and decode password in pgsql !! Josh Berkus 16:58
Re: How to encode and decode password in pgsql !! Subhramanya Shiva 18:14
RE: "correct" sorting. Gerald Gutierrez 18:16
Re: '13 months ago'::reltime Tom Lane 18:32
Timestamp Resolution in Postgres Michael Schroepfer 18:36
Re: How to encode and decode password in pgsql !! Bruce Momjian 19:22
Re: How to encode and decode password in pgsql !! Tom Lane 19:32
RE: "correct" sorting. Joel Burton 20:44
Re: How to encode and decode password in pgsql !! Roberto Mello 23:34

May 4, 2001

Thread Author Time
Re: How to encode and decode password in pgsql !! D'Arcy J.M. Cain 11:35
Re: Dateadd Vivek Khera 14:20
Re: "correct" sorting. Jeff Self 15:50
Re: create table Martín Marqués 16:17
Re: Dateadd Stephan Szabo 21:34
Re: create table Joel Burton 21:38
Re: Dateadd Cliff Crawford 21:58
Re: delete with cascade Stephan Szabo 22:06
Re: Re: Use of the LIMIT clause ? Bruce Momjian 22:08
Re: [SQL] delete with cascade Tom Lane 22:24
Re: create table Tom Lane 22:43

May 5, 2001

Thread Author Time
Re: '13 months ago'::reltime Christopher Sawtell 06:58
Re: '13 months ago'::reltime Peter Eisentraut 12:55
Re: create table Albert REINER 16:32
Re: Dateadd Josh Berkus 21:44
Need help with search-and-replace Josh Berkus 22:27
Re: Need help with search-and-replace Ian Harding 23:33

May 6, 2001

Thread Author Time
Re: Dateadd Tom Lane 05:00
Re: Need help with search-and-replace 📎 Christopher Sawtell 10:22
update error guard 14:43
Re: update error Tom Lane 16:22
7.1 REFERENCES contstraints Michael Richards 21:55

May 7, 2001

Thread Author Time
calling a function within a view causes problems doing a pg_dumpall juerg.rietmann 08:28
Re: calling a function within a view causes problems doing a pg_dumpall Josh Berkus 14:53
OFFTOPIC: search and replace with unix tools Oliver Seidel 15:14
INT8 sequences Radius Administrator 16:10
Re: Timestamp Resolution in Postgres David Wall 16:20
Re: RI permission problem 📎 Kyle 16:22
Re: Re: Need help with search-and-replace [email protected] 16:32
Re: Dateadd Bruce Momjian 17:04
Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement David D. Kilzer 17:27
Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement David D. Kilzer 18:12
General ISA and Foreign Key BOUCHPAN-LERUST-JUERY Lionel 18:46
Re: Timestamp Resolution in Postgres Joseph Shraibman 19:21
Re: RI permission problem Peter Eisentraut 19:36
Re: General ISA and Foreign Key Oliver Elphick 21:05

May 8, 2001

Thread Author Time
Re: RI permission problem Tom Lane 04:55
left join syntax Haywood J'Bleauxmie 07:36
Re: left join syntax Oliver Elphick 11:29
Informix->PostgreSQL database convertion Sylte 13:11
Re: Informix->PostgreSQL database convertion Sylte 13:14
Re: How to store gif or jpeg? Thanks! Sylte 13:16
Re: Informix->PostgreSQL database convertion Sergey E. Volkov 14:35
Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? Robert Beer 16:01
Re: SQL Server -> Postgres migration: Stored Procedure replacement? Roger Wernersson 18:31
Re: INT8 sequences Richard Huxton 19:43
transaction isolation question Jack 23:27
execute client application from PL/pgSql Jack 23:45

May 9, 2001

Thread Author Time
Is this possible? Wei Weng 01:16
no more pg_dump cause of multiple declared database?? Bruno Boettcher 07:12
Re: General ISA and Foreign Key BOUCHPAN-LERUST-JUERY Lionel 12:25
Re: no more pg_dump cause of multiple declared database?? Tom Lane 14:53
Information passing, Perl, Unix and Postgresql Database Issurdatt, Portia CECOM RDEC STCD SRC 18:38
'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman 20:55
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joe Conway 21:55
RE: 'record old is unassigned yet' when using trigger in 7.1.1 Michael Davis 21:58
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman 22:25
Re: Information passing, Perl, Unix and Postgresql Database Roberto Mello 22:37
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman 23:39
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman 23:44
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joe Conway 23:49
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joe Conway 23:55

May 10, 2001

Thread Author Time
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Tom Lane 00:12
Re: 'record old is unassigned yet' when using trigger in 7.1.1 Tom Lane 00:27
postmaster admin questions Markus Wagner 10:41
Problem in Porting from Oracle to Postgres SQl Amit 11:52
Order by email address by domain ? Hervé Piedvache 18:37
Re: Order by email address by domain ? Bruce Momjian 19:47
Re: Order by email address Josh Berkus 20:17
Re: Order by email address Josh Berkus 20:38
RE: Order by email address by domain ? Jeff Eckermann 21:14

May 11, 2001

Thread Author Time
Escape Quotes Keith Gray 01:11
Re: Order by email address by domain ? Frank Bax 01:53
Re: Escape Quotes Tom Lane 02:34
Re: Escape Quotes Tom Lane 02:38
Re: Escape Quotes Keith Gray 02:40
Re: Escape Quotes Keith Gray 03:17
Re: Re: Escape Quotes Roberto Mello 04:45
ipsql (was - Escape Quotes) 📎 Keith Gray 05:22
Question about Committed Isolation datactrl 05:26
Client Applications come with PostGreSQL V7.1 Jack 05:39
number of days in a month Cwhisperer 06:19
Client Applications come with PostGreSQL V7.1 datactrl 06:20
Postgres function library Lajtos Mate 06:48
Problems in porting from Oracle to Postgres Amit 06:54
RE: Order by email address by domain ? Maxim Maletsky 07:45
Re: Cannot build PL/Perl ... Mark Nielsen 10:41
can't get rid of unnesesary SORT step in explain plan for hash join Alexey Nalbat 11:47
Max simultaneous users webb sprague 14:10
RE: Order by email address by domain ? Jeff Eckermann 14:35
Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? Cliff Crawford 15:01
Re: [HACKERS] Problems in porting from Oracle to Postgres Roberto Mello 15:06
Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? J.H.M. Dassen Ray 15:29
Re: execute client application from PL/pgSql Jeff MacDonald 16:28
Re: execute client application from PL/pgSql clayton cottingham 16:32
create type and domains Valerio Santinelli 16:32
Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement Tom Lane 16:33
Re: Postgres function library Roberto Mello 17:14
Re: Informix->PostgreSQL database convertion Sylte 17:15
Re: Is this possible? Roberto Mello 17:24
Re: number of days in a month Kaare Rasmussen 18:15
WAL logs eating my diskspace!! webb sprague 19:40
Re: Re: How to store gif or jpeg? Thanks! Mathijs Brands 20:18
Problem using IP functions Marc Lamothe 20:33
Re: WAL logs eating my diskspace!! Tom Lane 23:30

May 12, 2001

Thread Author Time
Re: execute client application from PL/pgSql datactrl 00:23
Constraints... Michael Richards 18:57
SELECT timestamp('2001-06-12'::date - '2000-06-12'::date) Hans-Jürgen Schönig 19:26
Re: multi-table join, final table is outer join count ... The Hermit Hacker 22:47

May 13, 2001

Thread Author Time
Re: Constraints... Stephan Szabo 00:38
Re: Re: multi-table join, final table is outer join count ... Tom Lane 00:41
Re: can't get rid of unnesesary SORT step in explain plan for hash join Tom Lane 01:53
Re: SELECT timestamp('2001-06-12'::date - '2000-06-12'::date) Tom Lane 03:03
Re: Problem using IP functions Tom Lane 03:44
Re: Re: Informix->PostgreSQL database convertion rmcm 08:05
BLOB Antti Linno 14:02
how to remove ? Subhramanya Shiva 16:43
DISTINCT ON () with UNION pgsql 23:14

May 14, 2001

Thread Author Time
Re: DISTINCT ON () with UNION Tom Lane 00:52
Re: can't get rid of unnesesary SORT step in explain plan for hash join Alexey Nalbat 07:36
unwritable /tmp causes initdb to crash John Scott 08:16
error message... S.E.Franke 11:10
Auto incrementing an integer Sylte 13:02
Re: can't get rid of unnesesary SORT step in explain plan for hash join Tom Lane 14:17
fatal ERROR running simple join query... Ligia Pimentel 14:28
Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement David D. Kilzer 14:42
Re: Auto incrementing an integer Martín Marqués 15:15
Case Cwhisperer 15:21
Re: fatal ERROR running simple join query... Martín Marqués 15:21
Counting rows in a table Srikanth Rao 15:21
plpgsql function / ??? / help Larry Rosenman 18:00
Re: execute client application from PL/pgSql Jeff MacDonald 18:16
working with stored procedures Radhika Vutukuru 19:41
Re: Case Peter Eisentraut 20:39
Re: Auto incrementing an integer Thomas Swan 21:27
Re: Auto incrementing an integer Philip Hallstrom 21:53
Re: Auto incrementing an integer Sylte 21:55

May 15, 2001

Thread Author Time
RE: Auto incrementing an integer Michael Davis 01:33
How NULL is interpreted in Pgsql Guru Prasad 08:08
Give me a suggestion 'START WITH .. CONNECT BY'. 山さん 08:40
Re: error message... Justin Clift 10:09
Re: execute client application from PL/pgSql Justin Clift 10:31
system time Seema Noor 10:46
Re: system time Justin Clift 10:57
Case insensitive string comparison? Borek Lupoměský 12:48
Re: working with stored procedures (fwd) Guru Prasad 13:10
Re: Case insensitive string comparison? Karel Zak 13:47
Re: How NULL is interpreted in Pgsql Tom Lane 14:12
varbit question Laurent Duperval 14:31
Exp/Imp Problems... ameet 14:52
Re: varbit question Peter Eisentraut 15:41
Re: varbit question Laurent Duperval 15:47
Re: system time Jason Earl 19:04
Select between two connections cbell 19:43
Please dont flame Olivier PRENANT 21:01
Re: Select between two connections Per-Olof Pettersson 23:30
Re: How NULL is interpreted in Pgsql Per-Olof Pettersson 23:38
Re: [SQL] Is this possible? Peter J. Schoenster 23:47
Re: how to remove ? Per-Olof Pettersson 23:51

May 16, 2001

Thread Author Time
search for groups with a user Martín Marqués 08:49
[Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)] Chris Ryan 12:45
Select most recent record? Marc Sherman 13:28
Restricting the number of decimal digits Srikanth Rao 13:34
Re: Select most recent record? Tom Lane 14:35
Re: Select most recent record? Andrew Perrin 14:43
Re: Select most recent record? Tom Lane 14:50
RE: Select most recent record? Michael Ansley (UK) 14:50
RE: Select most recent record? Marc Sherman 14:52
oid and triggers Adam Doligalski 14:56
To Run 2 database servers at the same time Najm Hashmi 15:01
Re: Please dont flame Nils Zonneveld 15:33
Re: To Run 2 database servers at the same time Peter Eisentraut 15:51
Re: [Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)] Stephan Szabo 17:19
Help! Record logging Edwin S. Ramirez 17:30
case insensitive sort for output from SELECT Stephen Patterson 19:21
"avg" function for arrays? G. Anthony Reina 19:43
Re: Select most recent record? George Moga 19:49
Re: fatal ERROR running simple join query... Ligia Pimentel 21:29

May 17, 2001

Thread Author Time
Setting session global variables Jonathan Bartlett 00:43
Re: Setting session global variables Tom Lane 01:12
Re: Exp/Imp Problems... Roberto Mello 01:22
Re: Give me a suggestion 'START WITH .. CONNECT BY'. Roberto Mello 01:26
Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Forest Wilkinson 02:18
Re: Setting session global variables Jonathan Bartlett 02:48
how to add an new record from part of an old one juerg.rietmann 12:32
Re: how to add an new record from part of an old one 📎 George Moga 14:28
Setting session global variables 📎 Kyle 14:57

May 18, 2001

Thread Author Time
ON UPDATE CASCADE overhead? Forest Wilkinson 00:19

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 29 30 31