Mailing lists [pgsql-sql]
- Re: Heres a good one... Anuradha Ratnaweera
- INSERT slowdown ... Gerald Gutierrez
- Re: order of multiple assignments in UPDATE Anuradha Ratnaweera
- RE: List Concatination [warning] Wilkinson Charlie E
- Cannot build PL/Perl ... Adam Walczykiewicz
- PL/Perl documentation ... Adam Walczykiewicz
- Re: Cannot build PL/Perl ... clayton cottingham
- Re: PL/Perl documentation ... Jie Liang
- "correct" sorting. Jeff MacDonald
- How to encode and decode password in pgsql !! Subhramanya Shiva
- Re: How to encode and decode password in pgsql !! darcy@druid.net (D'Arcy J.M. Cain)
- '13 months ago'::reltime Albert REINER
- Re: How to encode and decode password in pgsql !! Josh Berkus
- Re: How to encode and decode password in pgsql !! Tom Lane
- Re: How to encode and decode password in pgsql !! Bruce Momjian
- Re: '13 months ago'::reltime Tom Lane
- RE: "correct" sorting. Gerald Gutierrez
- RE: "correct" sorting. Joel Burton
- Re: How to encode and decode password in pgsql !! Roberto Mello
- Re: How to encode and decode password in pgsql !! Subhramanya Shiva
- Re: How to encode and decode password in pgsql !! darcy@druid.net (D'Arcy J.M. Cain)
- Re: Dateadd Vivek Khera
- Re: "correct" sorting. Jeff Self
- Timestamp Resolution in Postgres Michael Schroepfer
- delete with cascade Martín Marqués
- Dateadd Ligia Pimentel
- create table LeoDeBeo
- Re: Dateadd Stephan Szabo
- Re: Re: Use of the LIMIT clause ? Bruce Momjian
- Re: delete with cascade Tom Lane
- Re: [GENERAL] delete with cascade Stephan Szabo
- Re: create table Tom Lane
- Re: create table Joel Burton
- Re: create table Martín Marqués
- Re: Dateadd Cliff Crawford
- Re: '13 months ago'::reltime Christopher Sawtell
- Re: '13 months ago'::reltime Peter Eisentraut
- Re: Dateadd Josh Berkus
- Need help with search-and-replace Josh Berkus
- Re: Dateadd Tom Lane
- Re: Need help with search-and-replace Christopher Sawtell
- update error guard
- Re: create table Albert REINER
- Re: update error Tom Lane
- 7.1 REFERENCES contstraints Michael Richards
- Re: 7.1 REFERENCES contstraints Stephan Szabo
- calling a function within a view causes problems doing a pg_dumpall juerg.rietmann@pup.ch
- Re: Need help with search-and-replace Ian Harding
- Re: calling a function within a view causes problems doing a pg_dumpall Josh Berkus
- OFFTOPIC: search and replace with unix tools Oliver Seidel
- Re: RI permission problem Kyle
- Re: Dateadd Bruce Momjian
- Re: Re: Need help with search-and-replace tjk@tksoft.com
- General ISA and Foreign Key BOUCHPAN-LERUST-JUERY Lionel
- Re: RI permission problem Peter Eisentraut
- Re: [GENERAL] Timestamp Resolution in Postgres Joseph Shraibman
- Re: General ISA and Foreign Key Oliver Elphick
- Re: RI permission problem Tom Lane
- left join syntax Haywood J'Bleauxmie
- Re: left join syntax Oliver Elphick
- INT8 sequences Radius Administrator
- Re: [GENERAL] Timestamp Resolution in Postgres David Wall
- no more pg_dump cause of multiple declared database?? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Re: INT8 sequences Richard Huxton
- Re: General ISA and Foreign Key BOUCHPAN-LERUST-JUERY Lionel
- Re: no more pg_dump cause of multiple declared database?? Tom Lane
- Information passing, Perl, Unix and Postgresql Database Issurdatt, Portia CECOM RDEC STCD SRC"
- 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joe Conway
- RE: 'record old is unassigned yet' when using trigger in 7.1.1 Michael Davis
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman
- Re: Information passing, Perl, Unix and Postgresql Database Roberto Mello
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joe Conway
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joe Conway
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Joseph Shraibman
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Tom Lane
- Re: 'record old is unassigned yet' when using trigger in 7.1.1 Tom Lane
- postmaster admin questions Markus Wagner
- Order by email address by domain ? Hervé Piedvache
- Re: Order by email address by domain ? Bruce Momjian
- Re: Order by email address Josh Berkus
- Re: Order by email address Josh Berkus
- RE: Order by email address by domain ? Jeff Eckermann
- Escape Quotes Keith Gray
- Re: Order by email address by domain ? Frank Bax
- Re: Escape Quotes Tom Lane
- Re: Escape Quotes Tom Lane
- Re: Escape Quotes Keith Gray
- Re: Escape Quotes Keith Gray
- Re: Re: Escape Quotes Roberto Mello
- ipsql (was - Escape Quotes) Keith Gray
- Question about Committed Isolation datactrl
- Client Applications come with PostGreSQL V7.1 datactrl
- RE: Order by email address by domain ? Maxim Maletsky
- Client Applications come with PostGreSQL V7.1 Jack
- Re: Informix->PostgreSQL database convertion Sergey E. Volkov
- Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? Robert Beer
- Re: Informix->PostgreSQL database convertion Sylte
- Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement David D. Kilzer
- Informix->PostgreSQL database convertion Sylte
- Problem in Porting from Oracle to Postgres SQl Amit
- execute client application from PL/pgSql Jack
- transaction isolation question Jack
- number of days in a month Cwhisperer
- Postgres function library Lajtos Mate
- Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? Cliff Crawford
- Re: How to store gif or jpeg? Thanks! Sylte
- Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement David D. Kilzer
- Is this possible? Wei Weng
- Re: Newbie ex-Oracle person's question: Oracle ROWID = PSQL OID, Orac le ROWNUM = PSQL ??? jdassen@cistron.nl (J.H.M. Dassen (Ray))
- RE: Order by email address by domain ? Jeff Eckermann
- Re: [HACKERS] Problems in porting from Oracle to Postgres Roberto Mello
- Re: execute client application from PL/pgSql Jeff MacDonald
- create type and domains Valerio Santinelli
- Re: execute client application from PL/pgSql clayton cottingham
- Max simultaneous users webb sprague
- Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement Tom Lane
- Re: Postgres function library Roberto Mello
- Re: Is this possible? Roberto Mello
- Re: number of days in a month Kaare Rasmussen
- Re: Re: How to store gif or jpeg? Thanks! Mathijs Brands
- Re: execute client application from PL/pgSql datactrl
- Re: Cannot build PL/Perl ... Mark Nielsen
- Constraints... Michael Richards
- multi-table join, final table is outer join count ... The Hermit Hacker
- Re: multi-table join, final table is outer join count ... The Hermit Hacker
- Re: Constraints... Stephan Szabo
- Re: Re: multi-table join, final table is outer join count ... Tom Lane
- can't get rid of unnesesary SORT step in explain plan for hash join Alexey Nalbat
- Re: Informix->PostgreSQL database convertion Sylte
- SELECT timestamp('2001-06-12'::date - '2000-06-12'::date) Hans-Jürgen Schönig
- Re: can't get rid of unnesesary SORT step in explain plan for hash join Tom Lane
- Re: SELECT timestamp('2001-06-12'::date - '2000-06-12'::date) Tom Lane
- Problem using IP functions Marc Lamothe
- Re: Problem using IP functions Tom Lane
- BLOB Antti Linno
- DISTINCT ON () with UNION pgsql@peope.net
- Re: DISTINCT ON () with UNION Tom Lane
- how to remove ? Subhramanya Shiva
- unwritable /tmp causes initdb to crash John Scott
- Re: can't get rid of unnesesary SORT step in explain plan for hash join Tom Lane
- Counting rows in a table Srikanth Rao
- Re: Re: Informix->PostgreSQL database convertion rmcm@compsoft.com.au
- plpgsql function / ??? / help Larry Rosenman
- Re: execute client application from PL/pgSql Jeff MacDonald
- Case Cwhisperer
- error message... S.E.Franke
- working with stored procedures Radhika Vutukuru
- Re: Using ORDER BY with AGGREGATE/GROUP BY in a SELECT statement David D. Kilzer
- Re: can't get rid of unnesesary SORT step in explain plan for hash join Alexey Nalbat
- Auto incrementing an integer Sylte
- fatal ERROR running simple join query... Ligia Pimentel
- Re: Case Peter Eisentraut
- Re: Auto incrementing an integer Martín Marqués
- Re: fatal ERROR running simple join query... Martín Marqués
- Re: Auto incrementing an integer Philip Hallstrom
- RE: Auto incrementing an integer Michael Davis
- How NULL is interpreted in Pgsql Guru Prasad
- Re: error message... Justin Clift
- Re: execute client application from PL/pgSql Justin Clift
- system time Seema Noor
- Re: system time Justin Clift
- Case insensitive string comparison? Borek Lupoměský
- Re: working with stored procedures (fwd) Guru Prasad
- Re: Case insensitive string comparison? Karel Zak
- Re: How NULL is interpreted in Pgsql Tom Lane
- varbit question Laurent Duperval
- Re: varbit question Peter Eisentraut
- Re: varbit question Laurent Duperval
- Re: system time Jason Earl
- Select between two connections cbell
- Please dont flame Olivier PRENANT
- Re: Select between two connections Per-Olof Pettersson
- Re: how to remove ? Per-Olof Pettersson
- Re: How NULL is interpreted in Pgsql Per-Olof Pettersson
- Re: Auto incrementing an integer Thomas Swan
- [Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)] Chris Ryan
- Select most recent record? Marc Sherman
- Restricting the number of decimal digits Srikanth Rao
- Re: Select most recent record? Tom Lane
- Re: Select most recent record? Andrew Perrin
- RE: Select most recent record? Michael Ansley (UK)
- search for groups with a user Martín Marqués
- oid and triggers Adam Doligalski
- To Run 2 database servers at the same time Najm Hashmi
- RE: Select most recent record? Marc Sherman
- Re: Select most recent record? Tom Lane
- Re: To Run 2 database servers at the same time Peter Eisentraut
- Re: [Fwd: [Gborg-bugs] BUG: reference error when using inherited tables (ID: 269) (new)] Stephan Szabo
- Give me a suggestion 'START WITH .. CONNECT BY'. 山さん
- "avg" function for arrays? G. Anthony Reina
- case insensitive sort for output from SELECT spam@freeuk.com (Stephen Patterson)
- Re: Select most recent record? George Moga
- Re: Auto incrementing an integer Sylte
- Exp/Imp Problems... ameet
- Setting session global variables Jonathan Bartlett
- Re: Setting session global variables Tom Lane
- Re: Exp/Imp Problems... Roberto Mello
- Re: Give me a suggestion 'START WITH .. CONNECT BY'. Roberto Mello
- Re: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Forest Wilkinson
- Re: Setting session global variables Jonathan Bartlett
- how to add an new record from part of an old one juerg.rietmann@pup.ch
- Re: how to add an new record from part of an old one George Moga
- Setting session global variables Kyle
- ON UPDATE CASCADE overhead? Forest Wilkinson
- has anyone tried running in MAC OS X postgresql
- Re: has anyone tried running in MAC OS X Mike Castle
- Re: has anyone tried running in MAC OS X Tom Lane
- Inherited tables: How stable is that feature? Florian Weimer
- Re: has anyone tried running in MAC OS X Justin Clift
- Re: Please dont flame Nils Zonneveld
- Help! Record logging Edwin S. Ramirez
- Re: fatal ERROR running simple join query... Ligia Pimentel
- Re: ON UPDATE CASCADE overhead? Jan Wieck
- HELP: what's wrong with my PL/PSQL function?? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Re: has anyone tried running in MAC OS X Giorgio Valoti
- Calculating the age of a person Hans-Jürgen Schönig
- Re: Inherited tables: How stable is that feature? Tom Lane
- Re: has anyone tried running in MAC OS X Peter Eisentraut
- Re: search for groups with a user george young
- Re: Calculating the age of a person tjk@tksoft.com
- are NEW and OLD rule attributes broken? Forest Wilkinson
- Re: are NEW and OLD rule attributes broken? Tom Lane
- Re: search for groups with a user Martín Marqués
- Re: HELP: what's wrong with my PL/PSQL function?? Richard Huxton
- Re: Help! Record logging Richard Huxton
- Re: HELP: what's wrong with my PL/PSQL function?? Tom Lane
- Create an empty record Per-Olof Pettersson
- Re: Create an empty record Per-Olof Pettersson
- Re: [GENERAL] Create an empty record Stephan Szabo
- Truncation of char, varchar, bit, varbit types (fwd) Peter Eisentraut
- Re: Truncation of char, varchar, bit, varbit types (fwd) Joe Conway
- timestamp bug Cedar Cox
- Re: Calculating the age of a person Cedar Cox
- Re: timestamp bug Richard Huxton
- Re: timestamp bug Cedar Cox
- Re: timestamp bug Tom Lane
- problem while starting server ??? Subhramanya Shiva
- Re: problem while starting server ??? (fwd) Grant
- how to check presence of a function and set permissions? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Re: how to check presence of a function and set permissions? Tod McQuillin
- Re: Case insensitive string comparison? Cedar Cox
- Re: HELP: what's wrong with my PL/PSQL function?? Jan Wieck
- Re: Case insensitive string comparison? Karel Zak
- Re: Case insensitive string comparison? tjk@tksoft.com
- Re: HELP: what's wrong with my PL/PSQL function?? Tom Lane
- sequence problem gabi munteanu
- how to set ownership of tables? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Re: sequence problem Peter Eisentraut
- Re: sequence problem Stephan Szabo
- Define timestamp with no timezone Sandhya Bellave
- RULES J.Fernando Moyano
- Re: how to check presence of a function and set permissions? Bruce Momjian
- Re: how to set ownership of tables? Bruce Momjian
- query PostgreSQL from c++ chris Günther
- RULES J.Fernando Moyano
- Re: RULES Martín Marqués
- Re: timestamp bug Alexander Dederer
- Set Datestyle Tubagus Nizomi
- convert date to time? speeves
- c++ wrapper library LeoDeBeo
- Re: Transposing data Hans-Jürgen Schönig
- Why indexes are not used when scanning from functions? Ловпаче Айдамир
- Re: Transposing data Alexander Dederer
- Help with ECPG on debian Potato BOUCHPAN-LERUST-JUERY Lionel
- Transposing data Hans-Jürgen Schönig
- RE: [HACKERS] Re: possible row locking bug in 7.0.3 & 7.1 Mikheev, Vadim
- Re: RULES Ross J. Reedstrom
- Re: Calculating the age of a person Najm Hashmi
- Re: Set Datestyle Peter Eisentraut
- Please help me.... waheed rahman
- Re: query PostgreSQL from c++ Peter Eisentraut
- PL/pgSQL problem with variables Hans-Jürgen Schönig
- Re: c++ wrapper library Peter Eisentraut
- implied rows when a rule gets executed. J.Fernando Moyano
- index/join madness Michael Richards
- Recursive select Martin Smetak
- Re: Truncation of char, varchar, bit, varbit types (fwd) jdassen@cistron.nl (J.H.M. Dassen (Ray))
- Select question Chris Ruprecht
- Re: index/join madness jdassen@cistron.nl (J.H.M. Dassen (Ray))
- Re: index/join madness David Olbersen
- Re: Select question Stephan Szabo
- Re: Select question Tom Lane
- Re: index/join madness Tom Lane
- Re: Why indexes are not used when scanning from functions? Tom Lane
- Error msg. Diehl, Jeffrey
- Re: Error msg. Tom Lane
- where's ALTER TABLE table DROP [ COLUMN ] column??? bboett@erm1.u-strasbg.fr (Bruno Boettcher)
- Re: Recursive select Ron Peterson
- Stored Procedures? Chris Ruprecht
- Re: Stored Procedures? Tod McQuillin
- Recursive select Daniel Wickstrom
- photos and OID's Mark
- ports in use question postgresql
- Select help Linh Luong
- Re: ports in use question Kate Collins
- Re: photos and OID's Richard Huxton
- Re: where's ALTER TABLE table DROP [ COLUMN ] column??? Keith Gray
- locking/concurrency question. Larry Rosenman
- INSERT value of type table Mourad EL HADJ MIMOUNE
- Problems with pg_dump (on Debian i386) Joachim Trinkwitz
- Re: Problems with pg_dump (on Debian i386) Tom Lane
- Large Objects Documentation Roberto Mello
- Re: Large Objects Documentation Peter Eisentraut
- time difference Seema Noor
- batch file Milen
- Re: batch file Jason Earl
- Re: batch file Jie Liang
- Re: batch file Peter Eisentraut
- Re: batch file Richard Huxton
- corrupted tables !!! J.Fernando Moyano
- Re: corrupted tables !!! Tom Lane
- Is it possible to defer triggers? Torsten Knodt
- Left Joins... Michael Richards
- Column reference X is ambiguous? Palle Girgensohn
- Re: Column reference X is ambiguous? Tom Lane
- AW: Column reference X is ambiguous? Hartwig Jens
- Re: Problems with pg_dump (on Debian i386) Joachim Trinkwitz
- START for SERIAL type? jferry@iexposure.com
- Re: Stored Procedures? reinoud@xs4all.nl (Reinoud van Leeuwen)
- Select for LEFT JOIN Linh Luong
- SQL specified sort jeffrey morrison
- Triggers in 7.0.x and SQL syntax. D0
- Very big problem Víctor
- sql user management Vladislav Breus
- Ynt: where's ALTER TABLE table DROP [ COLUMN ] column??? Madness
- Re: Return cursor alla@sergey.com (Alla)
- Difficult SQL Statement jim_esti@hotmail.com (Jim)
- Column reference X is ambiguous? Palle Girgensohn
- Re: Return cursor Sergey E. Volkov
- Ynt: corrupted tables !!! Madness
- Re: batch file bugi
- Recursive select Martin Smetak
- Re: Return cursor alla@sergey.com (Alla)
- Return cursor alla@sergey.com (Alla)
- Re: Return cursor Alexander Dederer
- altering date type of a column Madness
- sql user management Vladislav Breus
- Re: Return cursor Sergey E. Volkov
- Re: SQL specified sort tjk@tksoft.com
- Re: Recursive select Martín Marqués
- Seq Scan Linh Luong
- order after WHERE clause Kovacs Zoltan
- Re: order after WHERE clause Tom Lane
- Re: Problems with pg_dump (on Debian i386) Tom Lane
- Re: Seq Scan Martín Marqués
- ERROR: parser: parse error at or near "$1" Najm Hashmi
- Re: Select for LEFT JOIN tolik@aaanet.ru (Anatoly K. Lasareff)
- Re: sql user management george young
- Case Insensitive Queries Mark
- binary data David Lizano
- Re: Case Insensitive Queries tjk@tksoft.com
- AW: Case Insensitive Queries Manessinger Andreas
- Case Insensitive Queries Dan Lyke
- Re: Case Insensitive Queries Joe Conway
- Re: Case Insensitive Queries Mark
- Re: Case Insensitive Queries Jim Ballard
- Upgd from 7.0 to 7.1 Diehl, Jeffrey
- Re: START for SERIAL type? Vivek Khera
- RE: Upgd from 7.0 to 7.1 Diehl, Jeffrey
- Slow inserts/deletes Diehl, Jeffrey
- RE: Upgd from 7.0 to 7.1 Diehl, Jeffrey
- Re: Slow inserts/deletes Tom Lane
- Shortcut? Phuong Ma
- Re: batch file Grant
- Re: Shortcut? darcy@druid.net (D'Arcy J.M. Cain)
- Re: Shortcut? Tom Lane
- Re: Case Insensitive Queries tjk@tksoft.com
- Re: Difficult SQL Statement Renato De Giovanni
- Re: Left Joins... Renato De Giovanni
- ERROR: Class '37632' not found DI Hasenöhrl
- Re: Case Insensitive Queries Tom Lane
- Re: ERROR: Class '37632' not found Tom Lane
- Re: Case Insensitive Queries Mark
- Re: Case Insensitive Queries Mark
- bpchar compares (was Re: Case Insensitive Queries) Mark
- Re: Case Insensitive Queries tjk@tksoft.com
- RE: primary key scans in sequence Koen Antonissen
- SELECT * INTO TABLE is not working for me. Roy Souther
- Re: Case Insensitive Queries Tom Lane
- RE: primary key scans in sequence Stephan Szabo
- Re: bpchar compares (was Re: Case Insensitive Queries) Richard Huxton
- Re: Case Insensitive Queries Stephan Szabo
- Re: Case Insensitive Queries Mark
- Re: Case Insensitive Queries Stephan Szabo
- Re: Case Insensitive Queries Mark
- Re: Case Insensitive Queries Ian Lance Taylor
- Unique record Identifier? Chris Ruprecht
- Re: Case Insensitive Queries Tom Lane
- Re: Unique record Identifier? Josh Berkus
- Using indexes Linh Luong
- Re: Using indexes Bruce Momjian
- Re: Unique record Identifier? Chris Ruprecht
- Too many rows returning Linh Luong
- RE: primary key scans in sequence Koen Antonissen
- Re: SELECT * INTO TABLE is not working for me. Richard Huxton
- question about PL/pgSQL function datactrl
- 7.1.1 Lock Problems on Views Brian Powell
- RE: primary key scans in sequence Stephan Szabo
- Re: rowset Return from postgresql Josh Berkus
- Re: 7.1.1 Lock Problems on Views Tom Lane
- Re: 7.1.1 Lock Problems on Views Brian Powell
- Date manipulation Mark
- Re: Date manipulation Peter Eisentraut
- RE: primary key scans in sequence Gerald Gutierrez